Exam 70-764 topic 1 question 209 discussion

Actual exam question from Microsoft's 70-764

Question #: 209
Topic #: 1

You need to recommend a solution to meet the recovery requirements for the manufacturing database.
Your solution must minimize costs.
What should you recommend?

A. Database snapshots
B. Transaction log backups
C. Differential backups
D. SQL Server Failover Clustering
E. Peer-to-peer replication

Show Suggested Answer

Suggested Answer: A 🗳️

by gdv at Jan. 14, 2020, 3:20 a.m.

Comments

Submit Cancel

Slava_bcd81

4 years, 9 months ago

which "recovery requirements for the manufacturing database"?

upvoted 2 times

Slava_bcd81

4 years, 9 months ago

"We need to be able to immediately return the Manufacturing database to its previous state if the ProcessUpdateProc stored procedure fails to update the process information correctly"?

upvoted 1 times

...

edf

5 years, 5 months ago

Database snapshot not supported for Standard SQL 2012 https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/cc645993(v=sql.110)?redirectedfrom=MSDN

upvoted 3 times

Iva10

5 years ago

Yes, but in SQL 2016 is supported even in express edition https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-ver15

upvoted 1 times

Hoglet

4 years, 5 months ago

And the question specifies SQL2012 Standard So snapshot not available

upvoted 1 times

...