Microsoft DP-300 Exam Questions Instant Access

Question 1

You have an Azure SQL database named db1 on a server named server1.

You need to modify the MAXDOP settings for db1.

What should you do?

AConnect to db1 and run the sp_configure command.

BConnect to the master database of server1 and run the sp_configure command.

CConfigure the extended properties of db1.

DModify of db1.

Answer : D

https://docs.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism

Question 2

You have an Azure SQL Database failover group named AzFG1.

You plan to run the following CLI command.

How will this affect AzFG1?

AUp to two hours of data will be lost during an automatic failover.

BAutomatic failover will occur after a minimum of two hours.

CA forced failover cannot be initiated during the grace period.

DAzFG1 will attempt to fail back within two hours.

Answer : B

Question 3

You have an Azure subscription. The subscription contains an instance of SQL Server on Azure Virtual Machines named SQL1 and an Azure Automation account named account1. You need to configure account1 to restart the SQL Server Agent service if the service stops. Which setting should you configure?

AStart/Stop VM

BUpdate management

CState configuration (DSC)

DChange tracking

Answer : C

Question 4

You have an Azure subscription named Subscriptions

You have an Azure Resource Manager (ARM) template named Template.json that contains the following JSON data.

You need to deploy Template.json to Subscription1.

Which Azure Command-Line Interface (CLI) command should you run?

Aaz group deployment create --name Deployment1 --resource-group RG1 --template-uri https://www.contoso.com/ed7f0949-6b29-4e15-8e47-2f79c9c6c6a5

Baz group deployment create --name Deployment1 --resource-group RG1 --template-file c:\MyTemplates\azuredeploy.json --parameters c:\MyTemplates\azuredeploy.parameters.json

Caz group deployment create --resource-group RG1 --template-file template.json --parameters @parameters.json

Daz group deployment create --resource-group RG1 --template-file template.json

Answer : D

Question 5

You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.

You plan to create a database named DB1 in Pool1.

You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.

Which format should you use for the tables in DB1?

AJSON

BCSV

CParquet

DORC

Answer : C

Serverless SQL pool can automatically synchronize metadata from Apache Spark. A serverless SQL pool database will be created for each database existing in serverless Apache Spark pools.

For each Spark external table based on Parquet and located in Azure Storage, an external table is created in a serverless SQL pool database. As such, you can shut down your Spark pools and still query Spark external tables from serverless SQL pool.

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables

Question 6

You plan to perform batch processing in Azure Databricks once daily.

Which type of Databricks cluster should you use?

Aautomated

Binteractive

CHigh Concurrency

Answer : A

Azure Databricks makes a distinction between all-purpose clusters and job clusters. You use all-purpose clusters to analyze data collaboratively using interactive notebooks. You use job clusters to run fast and robust automated jobs.

The Azure Databricks job scheduler creates a job cluster when you run a job on a new job cluster and

terminates the cluster when the job is complete.

https://docs.microsoft.com/en-us/azure/databricks/clusters

Question 7

You have an Azure SQL database.

Users report that the executions of a stored procedure are slower than usual. You suspect that a regressed query is causing the performance issue.

You need to view the query execution plan to verify whether a regressed query is causing the issue. The solution must minimize effort.

What should you use?

APerformance Recommendations in the Azure portal

BExtended Events in Microsoft SQL Server Management Studio (SSMS)

CQuery Store in Microsoft SQL Server Management Studio (SSMS)

DQuery Performance Insight in the Azure portal

Answer : C

Use the Query Store Page in SQL Server Management Studio.

Query performance regressions caused by execution plan changes can be non-trivial and time consuming to resolve.

Since the Query Store retains multiple execution plans per query, it can enforce policies to direct the Query Processor to use a specific execution plan for a query. This is referred to as plan forcing. Plan forcing in Query Store is provided by using a mechanism similar to the USE PLAN query hint, but it does not require any change in user applications. Plan forcing can resolve a query performance regression caused by a plan change in a very short period of time.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store

Microsoft Administering Microsoft Azure SQL Solutions DP-300 Exam Questions