Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Microsoft
  3. Microsoft Certified: Azure Database Administrator Associate
  4. DP-300
  5. Administering Relational Databases on Microsoft Azure Questions and Answers

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

Go to Exam
Viewing page 12 out of 13 pages
Viewing questions 111-120 out of questions
Questions # 111:

Task 4

You need to enable change data capture (CDC) for db1.

Options:

Questions # 112:

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.

a public endpoint via a database-level firewall rule

B.

a private endpoint

C.

a public endpoint via a server-level firewall rule

D.

a Point-to-Site (P2S) VPN

Questions # 113:

You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements.

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

NOTE Each correct selection is worth one point.

Question # 113

Options:

Questions # 114:

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:

A.

Resource Governor

B.

a custom resource pool

C.

vertical scaling

D.

horizontal scaling

Questions # 115:

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?

Options:

A.

Run the sys.5p_cdc_en«ble_db stored procedure.

B.

Run the alter table statement and specify the enable chahgc_tracking clause.

C.

Run the alter database statement and specify the set cmange_trackinc > - on clause.

D.

Run the sp_addarticle stored procedure.

Questions # 116:

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

Questions # 117:

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.

Questions # 118:

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

Options:

A.

Sliding

B.

Hopping

C.

Session

D.

Tumbling

Questions # 119:

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,

What should you use as the event_file target?

Options:

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

Questions # 120:

You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements.

What should you use as the event_file target?

Options:

A.

an Azure SQL database

B.

an Azure Blob Storage container

C.

a SQL Server filegroup

D.

an Azure Files share

Viewing page 12 out of 13 pages
Viewing questions 111-120 out of questions