Free Microsoft 70-469 Exam Dumps Questions & Answers

DRAG DROP
You have a table named Table1 that contains 1 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 need to replace Column1 with a new encrypted column that uses two-way encryption.
Which code segment should you execute before you remove Column1?
To answer, move the appropriate code segments from the list of code segments to the
answer area and arrange them in the correct order.

Correct Answer:

You are creating a database that will store usernames and passwords for an application.
You need to recommend a solution to store the passwords in the database.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

• A.Encrypting File System (EFS)
• B.Transparent Data Encryption (TDE)
• C.One-way encryption
• D.Reversible encryption

You have a database that contains a user-defined function named Schema1.Udf1 and two tables named Schema1.Table1 and Schema1.Table2.
Schema1.Table1 has 1 million rows. The schema for Schema1.Table1 is configured as shown in the following table.

Schema1.Udf1 was defined by using the following code:

You need to write a query that will contain the following columns:
---
Country CountryID CustomerName
The solution must meet the following requirements:
--
Rows must be returned only if the function returns data.
The amount of time it takes the query to execute must be minimized.
Which query should you use?

• A.Option B
• B.Option D
• C.Option C
• D.Option A

You need to implement a backup strategy to support the requirements.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A.Create a credential called MyCredential on SQL Server, using MyStorageAccount for the storage account name and StorageAccountKey for the access key.
• B.Create a share on the hot standby site and grant permission to the SQL Server service login.
• C.Schedule a full backup by using the command BACKUP DATABASE ProdDB TO SHARE ... WITH CREDENTIAL=N' MyCredential'
• D.Schedule a full backup by using the command BACKUP DATABASE ProdDB TO DISK...
• E.Create a credential called MyCredential on SQL Server by using a Windows domain account and password.
• F.Schedule a full backup by using the command BACKUP DATABASE ProdDB TO URL ... WTTH CREDENTIAL=N'MyCredential'
• G.Create a share on your Windows Azure site by using your Windows Azure storage account information, and grant permission to the SQL Server service login.

You are evaluating the index design.
You need to recommend a change to Indexes.sql that will minimize the amount of time it takes for usp_AttendeesReport to execute. The solution must minimize the amount of database fragmentation.
Which line of code should you use to replace line 12 of Indexes.sql?

• A.(LastName, FirstName);
• B.(LastName) INCLUDE (FirstName);
• C.(LastName);
• D.(FirstName) INCLUDE (LastName);