DP-300 Practice Question: Monitor, configure, and optimize database resources

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✓

  Create a secondary managed instance, then create the link, then configure the secondary as readable, then monitor replication, then initiate failover when needed.

  Why this is correct

  This is correct because the secondary instance must exist before the link is created. After creating the link, the secondary can be configured as readable. Monitoring should occur before failover to ensure data consistency.

• ✗

  Create the link, then create a secondary managed instance, then configure as readable, then monitor, then failover.

  Why it's wrong here

  This is incorrect because the secondary instance must be created before the link can be established. Creating the link first will fail or be invalid.

• ✗

  Create a secondary managed instance, then create the link, then monitor, then failover, then configure as readable.

  Why it's wrong here

  This is incorrect because configuring the secondary as readable should happen before monitoring and failover. The readable configuration is part of the link setup and should be done early.

• ✗

  Create a secondary managed instance, then configure as readable, then create the link, then monitor, then failover.

  Why it's wrong here

  This is incorrect because the link must be created before configuring the secondary as readable. The readable setting is configured on the link, not on the standalone instance.

Go deeper

Related to this question