Question 31

You configure backup for an Azure SQL database as shown in the following exhibit.

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

Question 32

You have an Azure SQL managed instance.
You need to enable SQL Agent Job email notifications.
What should you do?
  • Question 33

    You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime.
    What should you do?
  • Question 34

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have an Azure Data Lake Storage account that contains a staging zone.
    You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
    Solution: You use an Azure Data Factory schedule trigger to execute a pipeline that copies the data to a staging table in the data warehouse, and then uses a stored procedure to execute the R script.
    Does this meet the goal?
  • Question 35

    You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.
    You need to ensure that User! can create a scheduled task to perform a full backup of DB1. The solution must use the principle of least privilege.
    Which built-in database role should you assign to User1?