Spring Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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

Home
Microsoft
Microsoft Certified: Azure Database Administrator Associate
DP-300
DP-300 Questions and Answers

Exam DP-300 Premium Access

View all detail and faqs for the DP-300 exam

Go to Exam

Practice at least 50% of the questions to maximize your chances of passing.

Viewing page 4 out of 5 pages

Viewing questions 31-40 out of questions

Questions # 31:

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.

What should you include in the recommendation?

Options:

Resource Governor

a custom resource pool

vertical scaling

horizontal scaling

Answer

Questions # 32:

You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. Which type of backup should you use?

Options:

transaction log

point-in-time restore (PITR)

differential

long-term retention (LTR)

Answer

Questions # 33:

You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.

What should you include in the recommendation?

Options:

a public endpoint via a database-level firewall rule

a private endpoint

a public endpoint via a server-level firewall rule

a Point-to-Site (P2S) VPN

Answer

Questions # 34:

You plan to deploy Instance1 by using the following script.

Question # 34

You need to specify the licenseType and storagenedundancy parameters. The deployment must meet the availability requirements and the business requirements for DB1 and DB2.

To what should you set each parameter? To answer, select the appropriate options in the answer area.

Question # 34

Options:

Answer

Answer:

Questions # 35:

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 # 35

Options:

Answer

Answer:

Explanation

Box 1: Hash

Scenario:

Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible.

A hash distributed table can deliver the highest query performance for joins and aggregations on large tables.

Box 2: Round-robin

Scenario:

You plan to create a promotional table that will contain a promotion ID. The promotion ID will be associated to a specific product. The product will be identified by a product ID. The table will be approximately 5 GB.

A round-robin table is the most straightforward table to create and delivers fast performance when used as a staging table for loads. These are some scenarios where you should choose Round robin distribution:

When you cannot identify a single key to distribute your data.

If your data doesn’t frequently join with data from other tables.

When there are no obvious keys to join.

[Reference:, https://rajanieshkaushikk.com/2020/09/09/how-to-choose-right-data-distribution-strategy-for-azure-synapse/, , ]

Questions # 36:

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:

time-based retention

change feed

lifecycle management

soft delete

Answer

Explanation

The lifecycle management policy lets you:

Delete blobs, blob versions, and blob snapshots at the end of their lifecycles

[Reference:, https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts, , , ]

Questions # 37:

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 table that has a FOREIGN KEY constraint

a table the has an IDENTITY property

a user-defined SEQUENCE object

a system-versioned temporal table

Answer

Explanation

Scenario: Contoso requirements for the sales transaction dataset include:

Implement a surrogate key to account for changes to the retail store addresses.

A surrogate key on a table is a column with a unique identifier for each row. The key is not generated from the

table data. Data modelers like to create surrogate keys on their tables when they design data warehouse models. You can use the IDENTITY property to achieve this goal simply and effectively without affecting load performance.

[Reference:, https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tablesidentity, , , ]

Questions # 38:

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 # 38

Options:

Answer

Answer:

Explanation

Azure Database Migration service

Box 1: Premium 4-VCore

Scenario: Migrate the SERVER1 databases to the Azure SQL Database platform.

Minimize downtime during the migration of the SERVER1 databases.

Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.

[Reference:, https://azure.microsoft.com/pricing/details/database-migration/, , https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-online, , , ]

Questions # 39:

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

Options:

dynamic data masking

Conditional Access in Azure

service principals

row-level security (RLS)

Answer

Explanation

[Reference:, https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15, , ]

Questions # 40:

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:

Configure the Deleted databases settings for ResearchSrvOL

Deploy and configure an Azure Backup server.

Configure the Advanced Data Security settings for ResearchDBL

Configure the Manage Backups settings for ResearchSrvOL

Answer

Explanation

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

Viewing page 4 out of 5 pages

Viewing questions 31-40 out of questions

Modal title

Registered Required

In order to participate in the comments you need to be logged-in.
You can sign-up or login (it's free).