Online Access Free 070-464 Practice Test

You need to implement a solution that meets the site requirements.
What should you implement?

• A.A distributed view on Server2
• B.A distributed view on Server1
• C.A non-indexed view on Server2
• D.A non-indexed view on Server1

You have a table named Table1 that contains one million rows. Table1 contains a column named Column1 that stores sensitive information. Column1 uses the nvarchar(16) data type. You have a certificate named Cert1.
You must add a column named Column2 that contains an encrypted version of the data from Column1. You must use two-way encryption. You plan to remove Column1 after you create Column2.
Which five Transact-SQL statements should you run in sequence before you remove Column1? To answer, move the appropriate Transact-SQL statements from the list of Transact-SQL statements to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any correct orders you select.

Correct Answer:

Explanation:
References:
https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/encrypt-a-column-of-data?view=sql-server-2017
https://docs.microsoft.com/en-us/sql/t-sql/statements/close-symmetric-key-transact-sql?view=sql-server-2017

You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)

You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?

• A.WITH SCHEMABINDING
• B.WITH ENCRYPTION
• C.WITH CHECK OPTION
• D.WITH VIEW_METADATA

You need to optimize the index structure that is used by the tables that support the fraud detection services.
What should you do?

• A.Add a hashed clustered index on POSTransactionId and CreateDate.
  The fraud detection service will need to meet the following requirement (among others):
  * Detect micropayments that are flagged with a StatusId value that is greater than 3 and that occurred within the last minute.
• B.Add a hashed nonclustered index to CreateDate.
• C.Add a not hash clustered index on POSTransactionId and CreateDate.
• D.Add a not hash nonclustered index to CreateDate.

You need to recommend a solution that meets the concurrency problems.
What should you include in the recommendation?

• A.Modify the order in which usp_AcceptCandidate accesses the Applications table and the Candidates table.
• B.Modify the stored procedures to use the REPEATABLE READ isolation level.
• C.Modify the order in which usp_UpdateCandidate accesses the Applications table and the Candidates table.
• D.Modify the stored procedures to use the SERIALIZABLE isolation level.