DP-300 Exam Question 11

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

You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set.
Which three Transact-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

DP-300 Exam Question 12

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 Synapse Analytics dedicated SQL pool that contains a table named Table1.
You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.
You plan to insert data from the files into Table1 and transform the dat a. Each row of data in the files will produce one row in the serving layer of Table1.
You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.
Solution: You use a dedicated SQL pool to create an external table that has an additional DateTime column.
Does this meet the goal?
  • DP-300 Exam Question 13

    Which counter should you monitor for real-time processing to meet the technical requirements?
  • DP-300 Exam Question 14

    You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1.
    Several users execute adhoc queries to DW1 concurrently.
    You regularly perform automated data loads to DW1.
    You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run.
    What should you do?
  • DP-300 Exam Question 15

    You have a new Azure subscription.
    You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1.
    You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings.
    Which two actions should you perform? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.