Administering Relational Databases on Microsoft Azure: DP-300

Correct Answer: B

For Azure SQL Managed Instance, the supported option FORCE_LAST_GOOD_PLAN can only be configured through T-SQL.

Enable automatic tuning on server On the server level you can choose to inherit automatic tuning configuration from "Azure Defaults" or not to inherit the configuration. Azure defaults are FORCE_LAST_GOOD_PLAN enabled, CREATE_INDEX disabled, and DROP_INDEX disabled.

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

Correct Answer: C

Azure SQL database ALTER CERTIFICATE changes the password used to encrypt the private key of a certificate, removes the private key, or imports the private key if none is present.

Example, changing the password that is used to encrypt the private key:

ALTER CERTIFICATE Shipping11

WITH PRIVATE KEY (DECRYPTION BY PASSWORD = '95hkjdskghFDGGG4%',

ENCRYPTION BY PASSWORD = '34958tosdgfkh##38');

Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-certificate-transact-sql

Correct Answer:

Box 1: point-time restore (PITR) backup.

What is point-in-time restore in Azure?

Point-In-Time Restore allows you to restore an existing database as a new database to an earlier point in time on the same logical server using SQL Database automated backups.

Box 2: 65 backup copies

52 weekly, 12 monthly, and one yearly.

Reference: https://github.com/uglide/azure-content/blob/master/articles/sql-database/sql-database-recovery-using-backups.md