Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

Pass the Microsoft Certified: Azure Database Administrator Associate DP-300 Questions and answers with ValidTests

Exam DP-300 All Questions
Exam DP-300 Premium Access

View all detail and faqs for the DP-300 exam

Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions
Questions # 1:

You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.

Which Azure Storage functionality should you include in the solution?

Options:

A.

time-based retention

B.

change feed

C.

lifecycle management

D.

soft delete

Expert Solution
Questions # 2:

You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.

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

NOTE: Each correct selection is worth one point.

Question # 2

Options:

Expert Solution
Questions # 3:

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.

What should you create?

Options:

A.

a table that has a FOREIGN KEY constraint

B.

a table the has an IDENTITY property

C.

a user-defined SEQUENCE object

D.

a system-versioned temporal table

Expert Solution
Questions # 4:

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

Options:

A.

Configure SalesSQLDb1 as writable.

B.

Update the connection strings of SalesSQLDb1App1.

C.

Update the firewall rules of SalesSQLDb1.

D.

Update the users in SalesSQLDb1.

Expert Solution
Questions # 5:

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.

Question # 5

Options:

Expert Solution
Questions # 6:

You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.

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

NOTE: Each correct selection is worth one point.

Question # 6

Options:

Expert Solution
Questions # 7:

You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements.

Which four 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.

Question # 7

Options:

Expert Solution
Questions # 8:

You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements.

How should you collect and stream metrics? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 8

Options:

Expert Solution
Questions # 9:

You need to configure user authentication for the SERVER1 databases. 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.

Question # 9

Options:

Expert Solution
Questions # 10:

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

Expert Solution
Viewing page 1 out of 5 pages
Viewing questions 1-10 out of questions