Exam 70-462 topic 2 question 187 discussion

Actual exam question from Microsoft's 70-462

Question #: 187
Topic #: 2

You have a SQL Server database named DB1.
You plan to load 10 million rows to DB1 by running bcp.exe.
You need to modify DB1 to minimize the amount of space required to store the transaction logs during the load operation. The solution must ensure that you can perform a point-in-time restore.
What data base setting should you modify?

A. Compatibility level to 120
B. Recovery model to Bulk logged
C. Containment type to Partial
D. Recovery model to Simple

Show Suggested Answer

Suggested Answer: C 🗳️
A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database.
Incorrect Answers:
A: To change the compatibility level, select a different option from the list. The choices are SQL Server 2008 (100), SQL Server 2012 (110), or SQL Server 2014
(120).
B: Point-in-time recovery is not supported in the Bulk logged recovery model.
D: The Simple recovery model does not support Point-in-time restores
References:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/recovery-models-sql-server

by mickeygeorge at Dec. 30, 2020, 2:47 p.m.

Comments

Submit Cancel

mickeygeorge

4 years, 4 months ago

Should the answer not be Bulk-logged recovery model

upvoted 1 times

...

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam

Exam 70-462 topic 2 question 187 discussion

Comments

mickeygeorge

SY0-701