70-465 Exam - Free Microsoft Questions and Answers

Question #1 (Topic: Topic 1)

You need to recommend a solution for Application1 that meets the security requirements.
What should you include in the recommendation?

A. Signed stored procedures B. Certificate Authentication C. Encrypted columns D. Secure Socket Layer (SSL)

Answer: A

Question #2 (Topic: Topic 1)

You need to recommend a solution to allow application users to perform tables. The
solution must meet the business requirements.
What should you recommend?

A. Create a Policy-Based Management Policy. B. Create a user-defined database role and add users to the role. C. Create stored procedures that use EXECUTE AS clauses. D. Create functions that use EXECUTE AS clauses.

Answer: D

Question #3 (Topic: Topic 1)

You need to recommend a database reporting solution that meets the business
requirements.
What should you include in the recommendation?

A. Data collection B. Performance Monitor C. A maintenance plan D. A dynamic management view

Answer: A

Question #4 (Topic: Topic 1)

You need to recommend a solution for the deployment of SQL Server 2014. The solution
must meet the business requirements.
What should you include in the recommendation?

A. Create a new instance of SQL Server 2014 on the server that hosts the SQL Server 2008 instance. B. Upgrade the existing SQL Server 2008 instance to SQL Server 2014. C. Deploy two servers that have SQL Server 2014 installed and implement Failover Clustering. D. Deploy two servers that have SQL Server 2014 installed and implement database mirroring.

Answer: C

Question #5 (Topic: Topic 1)

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 table variable B. A common table expression C. A subquery D. A cursor

Answer: A

Microsoft 70-465 - Designing Database Solutions for Microsoft SQL Server Exam