Free Microsoft 70-469 Exam Dumps Questions & Answers

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 not hash clustered index on POSTransactionId and CreateDate.
• B.  Add a not hash nonclustered index to CreateDate.
• C.  Add a hashed clustered index on POSTransactionId and CreateDate.
• D.  Add a hashed nonclustered index to CreateDate.

You need to modify Production.ProductDetails_Insert to comply with the application
requirements.
Which code segment should you execute?

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

You need to recommend a solution to improve the performance of usp.UpdateInventory. The solution must minimize the amount of development effort.
What should you include in the recommendation?

• A.  A subquery
• B.  A cursor
• C.  A common table expression
• D.  A table variable

You use SQL Server 2012 to maintain the data used by the applications at your company.
You plan to create a table named Table1 by using the following statement. (Line numbers are included for reference only.)

---
You need to ensure that Table1 contains a column named UserName. The UserName column will:
Store string values in any language.
Accept a maximum of 200 characters.
Be case-insensitive and accent-insensitive.
Which code segment should you add at line 03?

• A.  UserName nvarchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
• B.  UserName varchar(200) COLLATE Latin1_General_CI_AI NOT NULL,
• C.  UserName varchar(200) COLLATE Latin 1_General_CS_AS NOT NULL,
• D.  UserName nvarchar(200) COLLATE Latin1_General_CS_AS NOT NULL,

You are creating a database that will store usernames and credit card numbers for an application.
You need to recommend a solution to store and reuse 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.  Data hashing
• B.  Transparent Data Encryption (TDE)
• C.  Encrypting File System (EPS)
• D.  Data encryption