Microsoft DP-300 Exam Questions Instant Access

Question 1

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 2

SIMULATION

Task 2

You need to configure your user account as the Azure AD admin for the server named sql3700689S.

ASee the explanation part for the complete Solution

Answer : A

To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps for both methods:

Using the Azure portal:

Go to the Azure portal and selectSQL Server -- Azure Arc.

Select the server namedsql3700689Sand click onActive Directory admin.

Click onSet adminand choose your user account from the list of Azure AD users.

Click onSelectand thenSaveto confirm the change.

You can verify the Azure AD admin by clicking onActive Directory adminagain and checking the current admin.

Using the Azure CLI:

Install the Azure CLI and log in with your Azure account.

Run the following command to get the object ID of your user account:az ad user show --id <your-user-name> --query objectId -o tsv

Run the following command to set your user account as the Azure AD admin for the server:az sql server ad-admin create --server sql3700689S --object-id <your-object-id> --display-name <your-user-name>

You can verify the Azure AD admin by running the following command:az sql server ad-admin show --server sql3700689S

These are the steps to configure your user account as the Azure AD admin for the server named sql3700689S.

Question 3

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.

What should you include in the plan?

AConfigure the Deleted databases settings for ResearchSrvOL

BDeploy and configure an Azure Backup server.

CConfigure the Advanced Data Security settings for ResearchDBL

DConfigure the Manage Backups settings for ResearchSrvOL

Answer : D

https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure

Question 4

You have an Azure Databricks resource.

You need to log actions that relate to changes in compute for the Databricks resource.

Which Databricks services should you log?

Aclusters

Bjobs

CDBFS

DSSH

Eworkspace

Answer : E

Cloud Provider Infrastructure Logs.

Databricks logging allows security and admin teams to demonstrate conformance to data governance

standards within or from a Databricks workspace. Customers, especially in the regulated industries, also need records on activities like:

User access control to cloud data storage

Cloud Identity and Access Management roles

User access to cloud network and compute

Azure Databricks offers three distinct workloads on several VM Instances tailored for your data analytics workflow---the Jobs Compute and Jobs Light Compute workloads make it easy for data engineers to build and execute jobs, and the All-Purpose Compute workload makes it easy for data scientists to explore, visualize, manipulate, and share data and insights interactively.

https://databricks.com/blog/2020/03/25/trust-but-verify-with-databricks.html

Question 5

You have an Azure SQL database named DB1. You run a query while connected to DB1.

You review the actual execution plan for the query, and you add an index to a table referenced by the query.

You need to compare the previous actual execution plan for the query to the Live Query Statistics.

What should you do first in Microsoft SQL Server Management Studio (SSMS)?

AFor DB1, set QUERY_CAPTURE_MODE of Query Store to All.

BRun the SET SHOWPLAN_ALL Transact-SQL statement.

CSave the actual execution plan.

DEnable Query Store for DB1.

Answer : C

The Plan Comparison menu option allows side-by-side comparison of two different execution plans, for easier identification of similarities and changes that explain the different behaviors for all the reasons stated above. This option can compare between:

Two previously saved execution plan files (.sqlplan extension).

One active execution plan and one previously saved query execution plan.

Two selected query plans in Query Store.

Question 6

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

AConfigure virtual network service endpoints.

BEnable database firewall rules.

CCreate database-scoped credentials.

DConfigure connection strings that reference the read-write listener.

Answer : D

Question 7

You deploy an instance of SQL Server on Azure Virtual Machines named VM1.

You need to create a SQL Server Agent job that will rebuild indexes of the databases hosted on VM1. The solution must use the principle of least privilege.

What should you create first?

Aan Elastic Job agent

Ba local Windows account

Ca system-assigned managed identity in Microsoft Entra ID

Da user-assigned managed identity in Microsoft Entra ID

Answer : C

Microsoft Administering Microsoft Azure SQL Solutions DP-300 Exam Questions