07 Chapter 07 DP-300T00A-Trainer-Files-Administering-Relational

What is RPO?

• The point to which data needs to be recovered after a failure
• The number of nodes in a cluster
• A partial database restore

What is a hybrid solution?

• A solution that has resources both in Azure as well as on premises or in another cloud provider
• A solution that uses two different database engines e.g. MySQL and SQL Server
• A solution that spans two different versions of SQL Server

What is available after failover with database-level protection in SQL Server?

• Whatever is in the databases; anything outside must be dealt with manually
• Databases and SQL Server Agent jobs
• Logins, Databases, and SQL Server Agent Job

What component in Azure needs to be configured for the listener in an AG to work properly?

• A load balancer
• The NIC
• A load balancer

What feature creates a replica of the database in another region that is asynchronously kept up to date?

• Active geo-replication
• Readable secondary replica
• Failover group

What setting for auto-failover groups must be changed to ensure a low RPO?

• GracePeriodWithDataLossHours
• AlwaysBeInSync
• RPOZero