70-465 Exam
Top Microsoft 70-465 preparation exams Choices
Act now and download your Microsoft 70-465 test today! Do not waste time for the worthless Microsoft 70-465 tutorials. Download Renewal Microsoft Designing Database Solutions for Microsoft SQL Server 2012 exam with real questions and answers and begin to learn Microsoft 70-465 with a classic professional.
Q11. 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 row to the Customers table each time a classification changes.
B. Add a table to track any changes made to the classification of each customer.
C. Add columns for each classification to the Customers table.
D. Add a column to the Classifications table to track the status of each classification.
E. Implement change data capture.
Answer: AC
Topic 6, Mix Questions
36. DRAG DROP
You need to recommend a backup process for an Online Transaction Processing (OLTP) database.
The process must meet the following requirements:
-Ensure that if a hardware failure occurs, you can bring the database online with a minimum amount of data loss. -Minimize the amount of administrative effort required to restore any lost data.
What should you include in the recommendation?
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Q12. 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 view
C. a table variable
D. a function
Answer: B
Q13. You have two SQL Server 2012 instances named SQLDev and SQLProd.
You plan to create a new database on SQLProd that will use SQL Server Authentication.
You need to ensure that when the new database is copied from SQLProd to SQLDev, users can connect to the database on SQLDev if they do not have a login on the SQLDev instance.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
A. SQL Server Integration Services (SSIS) scripts
B. Extended Events
C. Triggers
D. SQL Server Analysis Services (SSAS) scripts
E. Contained database
Answer: E
Q14. You have a server that has SQL Server 2012 installed. The server contains 100 user databases.
You need to recommend a backup solution for the user databases. The solution must meet the following requirements:
-Perform a transaction log backup every hour.
-Perform a full backup of each database every week.
-Perform a differential backup of each database every day.
-Ensure that new user databases are added automatically to the backup solution.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.
A. A maintenance plan
B. SQL Server Agent jobs
C. Policy-Based Management
D. A Data Definition Language (DDL) trigger
Answer: A
Q15. You need to recommend a solution to ensure that sp4 adheres to the security requirements. What should you include in the recommendation?
A. Configure data manipulation language (DML) triggers.
B. Enable SQL Server Audit.
C. Enable C2 audit tracing.
D. Enable trace flags.
Answer: B
Q16. DRAG DROP
You plan to deploy SQL Server 2012.
Your company identifies the following monitoring requirements:
-Tempdb must be monitored for insufficient free space.
-Deadlocks must be analyzed by using Deadlock graphs.
You need to identify which feature meets each monitoring requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct monitoring requirement in the answer area.
Answer:
Q17. You need to recommend a solution for the error handling of sp3. The solution must minimize the amount of custom code required.
What should you recommend?
A. Use the @@ERROR variable in the nested stored procedures.
B. Use a TRY CATCH block in the called stored procedures.
C. Use the @@ERROR variable in the called stored procedures.
D. Use the RAISERROR command in the nested stored procedures.
Answer: B
Q18. DRAG DROP
You plan to deploy SQL Server 2012.
Your company identifies the following monitoring requirements for the database:
-An e-mail message must be sent when a user logs in.
-An e-mail message must be sent if CPU utilization exceeds 90 percent.
You need to identify which feature meets each monitoring requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct monitoring requirement in the answer area.
Answer:
Q19. DRAG DROP
You plan to deploy a database by using SQL Server 2012.
Your company identifies the following requirements for the database:
-The name of all stored procedures must start with "usp_"always.
-All distribution statistics must be updated daily.
You need to identify which feature must be used to meet each database requirement.
Which features should you identify?
To answer, drag the appropriate feature to the correct database requirement in the answer area.
Answer:
Q20. Your company has offices in Seattle and Montreal.
The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. The servers are located in separate building within your campus. The latency of the WAN link between the buildings is less than 10 ms.
You plan to implement an AlwaysOn availability group on both servers.
You need to recommend a failover type for the availability group.
What should you recommend?
A. Asynchronous automatic failover
B. Synchronous manual failover
C. Asynchronous manual failover
D. Synchronous automatic failover
Answer: D