DP-300 Exam Question 66

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?
  • DP-300 Exam Question 67

    You are evaluating the business goals.
    Which feature should you use to provide customers with the required level of access based on their service agreement?
  • DP-300 Exam Question 68

    You have an Azure subscription that contains the resources shown in the following table.

    You need to create a read-only replica of DB1 and configure the App1 instances to use the replica.
    What should you do? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    DP-300 Exam Question 69

    You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
    You need to initiate a full backup of DB1 on SQL2.
    Which statement should you run?
  • DP-300 Exam Question 70

    You have 20 Azure SQL databases provisioned by using the vCore purchasing model.
    You plan to create an Azure SQL Database elastic pool and add the 20 databases.
    Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.