DP-300 Microsoft Exam Questions and Free Practice Test

Question 49

- (Exam Topic 1)
You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals.
What should you include in the recommendation?

A. For each customer, grant the customer ddl_admin to the existing schema.

B. For each customer, create an additional schema and grant the customer ddl_admin to the new schema.

C. For each customer, create an additional schema and grant the customer db_writerto the new schema.

D. For each customer, grant the customer db_writerto the existing schema.

Correct Answer:B

Question 50

- (Exam Topic 5)
You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently.
You enable columnstore archival compression.
What are two possible results of the configuration? Each correct answer presents a complete solution.
NOTE:Each correct selection is worth one point.

A. Queries that use the index will consume more disk I/O.

B. Queries that use the index will retrieve fewer data pages.

C. The index will consume more disk space.

D. The index will consume more memory.

E. Queries that use the index will consume more CPU resources.

Correct Answer:BE
For rowstore tables and indexes, use the data compression feature to help reduce the size of the database. In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk.
Use columnstore archival compression to further reduce the data size for situations when you can afford extra time and CPU resources to store and retrieve the data.

Question 51

- (Exam Topic 5)
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?

A. Connect to db1 and run the sp_configure command.

B. Connect to the master database of server1 and run the sp_configure command.

C. Configure the extended properties of db1.

D. Modify the database scoped configuration of db1.

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

Question 52

- (Exam Topic 5)
You create a new Azure SQL managed instance named SQL1 and enable Database Mail extended stored procedures.
You need to ensure that SOL Server Agent jobs running on SQL 1 can notify administrators when a failure occurs.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
DP-300 dumps exhibit
Solution:

Does this meet the goal?

A. Yes

B. No

Correct Answer:A

Question 53

- (Exam Topic 5)
You have the following Azure Data Factory pipelines:
DP-300 dumps exhibit Ingest Data from System1
Ingest Data from System2
Populate Dimensions
Populate Facts
Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.
What should you do to schedule the pipelines for execution?

A. Add a schedule trigger to all four pipelines.

B. Add an event trigger to all four pipelines.

C. Create a parent pipeline that contains the four pipelines and use an event trigger.

D. Create a parent pipeline that contains the four pipelines and use a schedule trigger.

Correct Answer:D
Reference:
https://www.mssqltips.com/sqlservertip/6137/azure-data-factory-control-flow-activities-overview/

Question 54

- (Exam Topic 5)
You have an Azure subscription.
You plan to deploy an instance of SQL Sevier on Azure Virtual Machines that supports Write Accelerator.
Which virtual machine series should you use?

A. H-series

B. G -series

C. M-series

D. E-series

Correct Answer:C

START DP-300 EXAM