Microsoft DP-300 Administering Microsoft Azure SQL Solutions Exam Practice Test

Page: 1 / 14
Total 341 questions
Question 1

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 data. 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: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.

Does this meet the goal?



Answer : B

Instead use a serverless SQL pool to create an external table with the extra column.


https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/create-use-external-tables

Question 2

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?



Answer : C


Question 3

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 schedule an Azure Databricks job that executes an R notebook, and then inserts the data into the data warehouse.

Does this meet the goal?



Answer : B

Must use an Azure Data Factory, not an Azure Databricks job.


https://docs.microsoft.com/en-US/azure/data-factory/transform-data

Question 4

You have SQL Server on an Azure virtual machine.

You need to add a 4-TB volume that meets the following requirements:

Maximizes IOPs

Uses premium solid state drives (SSDs)

What should you do?



Question 5

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?



Answer : C

Topic 4, Contoso Ltd Clothing Store


Question 6

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?



Answer : C

The performance capacity of a query is determined by the user's resource class.

Smaller resource classes reduce the maximum memory per query, but increase concurrency.

Larger resource classes increase the maximum memory per query, but reduce concurrency.


https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/resource-classes-for-workloadmanagement

Question 7

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1?



Answer : D


Page:    1 / 14   
Total 341 questions