Weekend Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sale65best

Free Microsoft DP-300 Practice Exam with Questions & Answers | Set: 3

Questions 21

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?

Options:
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.

Microsoft DP-300 Premium Access
Questions 22

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.

What should you run as part of the implementation?

Options:
A.

CREATE LOGIN and the FROM WINDOWS clause

B.

CREATE USER and the FROM CERTIFICATE clause

C.

CREATE USER and the FROM LOGIN clause

D.

CREATE USER and the ASYMMETRIC KEY clause

E.

CREATE USER and the FROM EXTERNAL PROVIDER clause

Questions 23

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?

Options:
A.

Configure the Deleted databases settings for ResearchSrvOL

B.

Deploy and configure an Azure Backup server.

C.

Configure the Advanced Data Security settings for ResearchDBL

D.

Configure the Manage Backups settings for ResearchSrvOL

Questions 24

You create all of the tables and views for ResearchDB1.

You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.

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 Question 24

Options:
Questions 25

You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements.

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-300 Question 25

Options:
Questions 26

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.

You execute the following Transact-SQL statements.

DP-300 Question 26

You need to reduce the time it takes to perform analytic queries on the database.

Which configuration should you enable?

Options:
A.

ROW_ MODE_MEMORY GRANT_FEEDBACK

B.

BATCH MODE_MEMORY GRAIJT_FEEDBACK

C.

BATCH_MODE_ADAPTIVE_TOIMS

D.

BATC H_MODE_ON_ROWSTOR E

Questions 27

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

The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.

You need to resolve the performance issues.

What should you do?

Options:
A.

Implement memory-optimized tables.

B.

Run the dbcc flushprocindB command.

C.

Replace the sequential index keys with nonsequential keys.

D.

Run the dbcc dbreindex command.

Questions 28

You have an Azure Data Factory that contains 10 pipelines.

You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be

available for grouping and filtering when using the monitoring experience in Data Factory.

What should you add to each pipeline?

Options:
A.

an annotation

B.

a resource tag

C.

a run group ID

D.

a user property

E.

a correlation ID

Questions 29

You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.

What should you recommend? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

DP-300 Question 29

Options:
Questions 30

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?

Options:
A.

Configure Microsoft Entra authentication for the logical server that hosts DB3.

B.

Create a database that has database-scoped credentials.

C.

Configure a private endpoint for connectivity to DB3.

D.

Create data base-scoped credentials in DB3.