Exam 70-764 topic 1 question 317 discussion

Actual exam question from Microsoft's 70-764

Question #: 317
Topic #: 1

HOTSPOT -
You view the Restore Transaction Log settings for a database named DB1 as shown in the following exhibit.

Use the drop down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer

Suggested Answer:

Log shipping secondary database can be kept in two restore modes:
Restoring - This mode is also known as NORECOVERY mode.
Standby - This mode is also known as Read-Only mode.
When you use the NORECOVERY mode, the database will be in a restoring state and inaccessible to users, so uncommitted database transactions are not an issue.
When you use the STANDBY mode, database will be in Read-Only state and users can access this database for read operations. Transactions in process on primary server or any uncommitted transaction cannot be read in secondary database.
References: https://www.mssqltips.com/sqlservertip/3600/change-the-restore-mode-of-a-secondary-sql-server-database-in-log-shipping-with-ssms/

by TheSwedishGuy at Feb. 4, 2020, 1:08 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 5 months ago

STANDBY mode means you can read committed transactions on the secondary databases, but not issue any further transactions.

upvoted 2 times

...