Winter Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netbudy65

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

Questions 4

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

Buy Now
Questions 5

You need to identify the cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

A.

sys.dm_pdw_nodes_tran_locks

B.

sys.dm_exec_compute_node_errors

C.

sys.dm_exec_requests

D.

sys.dm_cdc_errors

E.

sys.dm_pdw_nodes_os_wait_stats

F.

sys.dm_tran_locks

Buy Now
Questions 6

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.

Options:

Buy Now
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.

Options:

Buy Now
Questions 8

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.

Options:

Buy Now
Questions 9

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.

Buy Now
Questions 10

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 11

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 12

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 13

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.

Buy Now
Questions 14

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.

Options:

Buy Now
Questions 15

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.

Options:

Buy Now
Questions 16

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:

A.

dynamic data masking

B.

Conditional Access in Azure

C.

service principals

D.

row-level security (RLS)

Buy Now
Questions 17

You have an Azure SQL database.

You need to identify whether a delayed query execution is associated to a RESOURCE wait.

How should you complete the Transact –SQL statement? To answer, select the appropriate option in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 18

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.

Options:

Buy Now
Questions 19

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1. You need to monitor DB1 by using Extended Events. The solution must meet the following requirements:

• Capture raw event data and store the data in Azure Storage.

• Minimize the performance impact of capturing extended events.

How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 20

You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL databases named DB1 and DB2.

You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQL authentication.

You need to ensure that App1 can access DB2. The solution must meet the following requirements:

    App1 must be able to view only DB2.

    Administrative effort must be minimized.

What should you create?

Options:

A.

a contained database user for App1 on DB2

B.

a login for App1 on Server1

C.

a contained database user from an external provider for App1 on DB2

D.

a contained database user from a Windows login for App1 on DB2

Buy Now
Questions 21

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements:

The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.

Administrative effort must be minimized.

What should you use to host the databases?

Options:

A.

a single Azure SQL database

B.

an Azure SQL Database elastic pool

C.

SQL Server on Azure Virtual Machines

D.

Azure SQL Managed Instance

Buy Now
Questions 22

You have an Azure SQL database named DB1 in the General Purpose service tier.

You need to monitor D81 by using SQL insights.

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 23

You have 50 Azure SQL databases.

You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.

What should you do?

Options:

A.

Create a diagnostic setting for the activity log that has the Security log enabled.

B.

For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.

C.

Create an alert rule that uses a Metric signal type.

D.

Create an alert rule that uses an Activity Log signal type.

Buy Now
Questions 24

You have an Azure subscription.

You need to deploy an Azure SQL database. The solution must meet the following requirements:

• Dynamically scale CPU resources.

• Ensure that the database can be paused to reduce costs.

What should you use?

Options:

A.

the Business Critical service tier

B.

the serverless compute tier

C.

an elastic pool

D.

the General Purpose service tier

Buy Now
Questions 25

You have two instances of SQL Server on Azure virtual Machines named VM1 and VM2. VM1 hosts a database named dbl.

You plan to create a database availability group (DAG) for dbl. The solution must use certificate authentication between VM1 and VM2.

You need to configure authentication for the outbound connections of VM1.

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.

Options:

Buy Now
Questions 26

You have an Azure subscription.

You create a logical SQL server that hosts four databases Each database will be used by a separate customer.

You need to ensure that each customer can access only its own database. The solution must minimize administrative effort

Which two actions should you perform? Each correct answer presents part of the solution

NOTE: Each correct selection is worth one point.

Options:

A.

Create a network security group (NSG)

B.

Create a server-level firewall rule

C.

Create a private endpoint

D.

Create a database-level firewall rule.

E.

Deny public access.

Buy Now
Questions 27

You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL Database deployments in an Azure subscription. The solution must minimize administrative effort.

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.

Options:

Buy Now
Questions 28

Your company uses Azure Stream Analytics to monitor devices.

The company plans to double the number of devices that are monitored.

You need to monitor a Stream Analytics job to ensure that there are enough processing resources to handle the

additional load.

Which metric should you monitor?

Options:

A.

Input Deserialization Errors

B.

Late Input Events

C.

Early Input Events

D.

Watermark delay

Buy Now
Questions 29

You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.

You plan to implement a disaster recovery solution.

You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:

• Minimize administrative effort for the recovery drills.

• Isolate the recovery environment from the production environment.

What should you use?

Options:

A.

Recovery Services vaults

B.

Azure Site Recovery

C.

Azure Backup

D.

native Microsoft SQL Server backup

Buy Now
Questions 30

You have SQL Server on an Azure virtual machine that contains a database named DB1.

You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:

What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

Options:

A.

Force the query execution plan for plan 1221065.

B.

Run the DBCC FREEPROCCACHE command.

C.

Force the query execution plan for plan 1220917.

D.

Disable parameter sniffing.

Buy Now
Questions 31

You configure version control for an Azure Data Factory instance as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 32

You have an Azure subscription that contains a logical SQL server named Serverl. The master database of Serverl contains a user named Userl. You need to ensure that Userl can create databases on Serverl. Which database role should you assign to Userl?

Options:

A.

db_owner

B.

dbmanager

C.

dbo

D.

db_ddladmin

Buy Now
Questions 33

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 34

You have an Azure SQL Database instance named DatabaseA on a server named Server1.

You plan to add a new user named App1 to DatabaseA and grant App1 db_datacenter permissions. App1 will use SQL Server Authentication.

You need to create App1. The solution must ensure that App1 can be given access to other databases by using the same credentials.

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.

Options:

Buy Now
Questions 35

You need to recommend a service tier and a method to offload analytical workloads for the databases migrated from SVR1. The solution must meet the availability and business requirements.

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

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 36

You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1.

You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service.

How should you configure the backup of DB1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 37

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

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

Buy Now
Questions 39

You are evaluating the role assignments.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 40

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

Buy Now
Questions 41

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

Buy Now
Questions 42

You need to recommend an authentication solution for App1 access to DB1 and DB2 after their migration to Instance1. The solution must meet the availability requirements.

Which actions should you perform in sequence? To answer, drag the appropriate actions to the correct order. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Options:

Buy Now
Questions 43

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.

Options:

Buy Now
Questions 44

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.

Buy Now
Questions 45

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:

A.

transaction log

B.

point-in-time restore (PITR)

C.

differential

D.

long-term retention (LTR)

Buy Now
Questions 46

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.

Buy Now
Questions 47

You plan to deploy Instance1 by using the following script.

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.

Options:

Buy Now
Questions 48

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 49

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

Buy Now
Questions 50

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 51

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

Options:

A.

Configure virtual network service endpoints.

B.

Enable database firewall rules.

C.

Create database-scoped credentials.

D.

Configure connection strings that reference the read-write listener.

Buy Now
Exam Code: DP-300
Exam Name: Administering Relational Databases on Microsoft Azure
Last Update: Dec 12, 2024
Questions: 341

PDF + Testing Engine

$144.99

Testing Engine

$109.99

PDF (Q&A)

$94.99