Microsoft 70-465 - Designing Database Solutions for Microsoft SQL Server Exam
Page: 2 / 23
Total 111 questions
Question #6 (Topic: Topic 1)
You need to recommend an isolation level for usp_UpdateOrderDetails.
Which isolation level should you recommend?
Which isolation level should you recommend?
A. Read committed
B. Repeatable read
C. Read uncommitted
D. Serializable
Answer: B
Question #7 (Topic: Topic 1)
You need to recommend a feature to support your backup solution.
What should you include in the recommendation?
What should you include in the recommendation?
A. Transparent Data Encryption (TDE)
B. Column-level encryption
C. An NTFS file permission
D. A Secure Sockets Layer (SSL)
Answer: A
Question #8 (Topic: Topic 1)
You need to recommend a disk monitoring solution that meets the business requirements.
What should you include in the recommendation?
What should you include in the recommendation?
A. An audit
B. A dynamic management view
C. A maintenance plan
D. An SQL Server Agent alert
Answer: B
Question #9 (Topic: Topic 1)
During performance testing, you discover that database INSERT operations against the
Inventory table are slow.
You need to recommend a solution to reduce the amount of time it takes to complete the
INSERT operations.
What should you recommend?
Inventory table are slow.
You need to recommend a solution to reduce the amount of time it takes to complete the
INSERT operations.
What should you recommend?
A. Partition the nonclustered index.
B. Partition the Inventory table.snapshot replication
C. Create a column store index.Master Data Services
D. Drop the clustered index.change data capture
Answer: A
Question #10 (Topic: Topic 1)
You need to recommend a solution to synchronize Database2 to App1_Db1.
What should you recommend?
What should you recommend?
A. Change data capture
B. Snapshot replication
C. Master Data Services
D. Transactional replication
Answer: D
