Independence Day Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592

DP-300 Administering Relational Databases on Microsoft Azure Questions and Answers

Questions 4

Which audit log destination should you use to meet the monitoring requirements?

Options:

A.

Azure Storage

B.

Azure Event Hubs

C.

Azure Log Analytics

Buy Now
Questions 5

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.

  • Clustered columnstore indexes
  • Automatic tuning
  • Change tracking
  • PolyBase

You plan to migrate DB1 to an Azure SQL database.

What feature should be removed or replaced before DB1 can be migrated?

Options:

A.

Clustered columnstore indexes

B.

PolyBase

C.

Change tracking

D.

Automatic tuning

Buy Now
Questions 6

Which windowing function should you use to perform the streaming aggregation of the sales data?

Options:

A.

Sliding

B.

Hopping

C.

Session

D.

Tumbling

Buy Now
Questions 7

You are building an Azure Stream Analytics job to retrieve game data.

You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.

How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 8

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

Buy Now
Questions 9

You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool.

You need to create a surrogate key for the table. The solution must provide the fastest query performance.

What should you use for the surrogate key?

Options:

A.

an IDENTITY column

B.

a GUID column

C.

a sequence object

Buy Now
Questions 10

What should you use to migrate the PostgreSQL database?

Options:

A.

Azure Data Box

B.

AzCopy

C.

Azure Database Migration Service

D.

Azure Site Recovery

Buy Now
Questions 11

You plan to deploy an app that includes an Azure SQL database and an Azure web app. The app has the following requirements:

  • The web app must be hosted on an Azure virtual network.
  • The Azure SQL database must be assigned a private IP address.
  • The Azure SQL database must allow connections only from the virtual network.

You need to recommend a solution that meets the requirements.

What should you include in the recommendation?

Options:

A.

Azure Private Link

B.

a network security group (NSG)

C.

a database-level firewall

D.

a server-level firewall

Buy Now
Questions 12

Which counter should you monitor for real-time processing to meet the technical requirements?

Options:

A.

SU% Utilization

B.

CPU% utilization

C.

Concurrent users

D.

Data Conversion Errors

Buy Now
Questions 13

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.

Options:

Buy Now
Questions 14

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.

Options:

Buy Now
Questions 15

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.

Options:

Buy Now
Questions 16

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

Buy Now
Questions 17

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

Buy Now
Questions 18

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

Options:

A.

Business Critical 4-vCore

B.

Hyperscale

C.

General Purpose v-vCore

D.

Serverless

Buy Now
Exam Code: DP-300
Exam Name: Administering Relational Databases on Microsoft Azure
Last Update: Jul 4, 2022
Questions: 206

PDF + Testing Engine

$76  $189.99

Testing Engine

$64  $159.99
buy now DP-300 testing engine

PDF (Q&A)

$56  $139.99
buy now DP-300 pdf