QUESTION 21
You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store the credit card numbers in the database. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
A. One-way encryption
B. Reversible encryption
C. Encrypting File System (EPS)
D. Transparent Data Encryption (TDE)
Answer: B
QUESTION 22
You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to recommend a solution that meets the following requirements:
– The database schemas must be synchronized from SQLDev to SQLProd.
– The database on SQLDev must be deployed to SQLProd by using a package.
– The package must support being deployed to SQL Azure.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. a database snapshot
B. change data capture
C. a data-tier application
D. SQL Server Integration Services (SSIS)
Answer: C
QUESTION 23
You have a database named DB1. You plan to create a stored procedure that will insert rows into three different tables. Each insert must use the same identifying value for each table, but the value must increase from one invocation of the stored procedure to the next. Occasionally, the identifying value must be reset to its initial value. You need to design a mechanism to hold the identifying values for the stored procedure to use. What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
A. Create a sequence object that holds the next value in the sequence. Retrieve the next value by
using the stored procedure. Reset the value by using an ALTER SEQUENCE statement as needed.
B. Create a fourth table that holds the next value in the sequence. At the end each transaction, update
the value by using the stored procedure. Reset the value as needed by using an UPDATE statement.
C. Create a sequence object that holds the next value in the sequence. Retrieve the next value by using
the stored procedure. Increment the sequence object to the next value by using an ALTER SEQUENCE
statement. Reset the value as needed by using a different ALTER SEQUENCE statement.
D. Create an identity column in each of the three tables. Use the same seed and the same increment for
each table. Insert new rows into the tables by using the stored procedure. Use the DBCC CHECKIDENT
command to reset the columns as needed.
Answer: A
QUESTION 24
You need to recommend a solution for the planned changes to the customer classifications. What should you recommend? (Each correct answer presents part of the solution. Choose all that apply.)
A. Add a table to track any changes made to the classification of each customer.
B. Add columns for each classification to the Customers table.
C. Implement change data capture.
D. Add a row to the Customers table each time a classification changes.
E. Add a column to the Classifications table to track the status of each classification.
Answer: AC
QUESTION 25
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the table. What should you use? More than one answer choice may achieve the goal. Select the BEST answer.
A. a Data Definition Language (DDL) trigger
B. a data manipulation language (DML) trigger
C. a DEFAULT constraint
D. a FOREIGN KEY constraint
E. a CHECK constraint
Answer: E
QUESTION 26
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a table that is used for auditing is updated. What should you use? More than one answer choice may achieve the goal. Select the BEST answer.
A. a DEFAULT constraint
B. a Data Definition Language (DDL) trigger
C. a CHECK constraint
D. a FOREIGN KEY constraint
E. a data manipulation language (DML) trigger
Answer: E
QUESTION 27
You need to recommend a change to sp3 to ensure that the procedure completes only if all of the UPDATE statements complete. Which change should you recommend?
A. Set the IMPLICIT_TRANSACTIONS option to off.
B. Set the XACT_ABORT option to off
C. Set the IMPLICIT_TRANSACTIONS option to on.
D. Set the XACT_ABORT option to on.
Answer: D
QUESTION 28
You need to recommend a solution to meet the security requirements of the junior database administrators. What should you include in the recommendation?
A. a shared login
B. a database role
C. a credential
D. a server role
Answer: D
QUESTION 29
You need to recommend a solution to minimize the amount of time it takes to execute sp1. With what should you recommend replacing Table1?
A. a temporary table
B. a function
C. a view
D. a table variable
Answer: C
QUESTION 30
You need to recommend a disaster recovery strategy for the Inventory database. What should you include in the recommendation?
A. Log shipping
B. Always on availability groups
C. SQL Server Failover Clustering
D. Peer-to-peer replication
Answer: A
If you want to pass Microsoft 70-459 successfully, donot missing to read latest lead2pass Microsoft 70-459 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.