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?

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

Run the sys.5p_cdc_enble_db stored procedure.

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

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

Run the sp_addarticle stored procedure.

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes.What should you include in the solution?

From SQL Server Management Studio (SSMS), create a Database Mail profile

From SQL Server Configuration Manager (SSMS), enable SQL Server Agent

From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties

From SQL Server Management Studio (SSMS), create a Database Mail profile

From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action

You have the following Azure Data Factory pipelines:Ingest Data from System1Ingest Data from System2Populate DimensionsPopulate FactsIngest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.What should you do to schedule the pipelines for execution?

Create a parent pipeline that contains the four pipelines and use a schedule trigger.

Add a schedule trigger to all four pipelines.

Add an event trigger to all four pipelines.

Create a parent pipeline that contains the four pipelines and use an event trigger.

Create a parent pipeline that contains the four pipelines and use a schedule trigger.

You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.You need to implement alerts by using Azure Monitor. The solution must meet the following requirements:Minimize costs.Aggregate Intelligent Insights telemetry from each database.What should you do?

From the Diagnostic settings of each database, select Send to Log Analytics.

From the Diagnostic settings of each database, select Stream to an event hub.

From the Diagnostic settings of SQLMI1, select Send to Log Analytics.

From the Diagnostic settings of SQLMI1, select Stream to an event hub.

You have an Azure SQL managed instance that hosts multiple databases.You need to configure alerts for each database based on the diagnostics telemetry of the database.What should you use?

Azure SQL Analytics alerts based on diagnostics logs

Azure SQL Analytics alerts based on metrics

SQL Health Check alerts based on diagnostics logs

SQL Health Check alerts based on metrics

Azure SQL Analytics alerts based on diagnostics logs

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. You need to initiate a full backup of DB1 on SQL2.Which statement should you run?

BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);

BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/mycontainer/DB1.bak' with (Differential, STATS=5, COMPRESSION);

BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/mycontainer/DB1.bak' with (COPY_ONLY, STATS=5, COMPRESSION);

BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/mycontainer/DB1.bak' with (File_Snapshot, STATS=5, COMPRESSION);

BACKUP DATABASE DB1 TO URL='https://mystorageaccount.blob.core.windows.net/mycontainer/DB1.bak' with (NoInit, STATS=5, COMPRESSION);

You plan to move two 100-GB databases to Azure.You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?

An Azure SQL Database elastic pool

SQL Server on Azure virtual machines

an Azure SQL Database managed instance

You have 10 Azure virtual machines that have SQL Server installed.You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?

Automated Backup in the SQL virtual machine settings

You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine. In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs. Which type of storage accounts should you use for the backups?

read-access geo-redundant storage (RA-GRS)

locally-redundant storage (LRS)

read-access geo-redundant storage (RA-GRS)

You are planning disaster recovery for the failover group of an Azure SQL Database managed instance. Your company's SLA requires that the database in the failover group become available as quickly as possible if a major outage occurs. You set the Read/Write failover policy to Automatic.What are two results of the configuration? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

In the event of a datacenter or Azure regional outage, the databases will fail over automatically.

In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.

In the event of a datacenter or Azure regional outage, the databases will fail over automatically.

In the event of an outage, the databases in the primary instance will fail over immediately.

In the event of an outage, you can selectively fail over individual databases.

In the event of an outage, you can set a different grace period to fail over each database.

In the event of an outage, the minimum delay for the databases to fail over in the primary instance will be one hour.

You have an Azure SQL database named DB1.You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails. The solution must minimize costs. Which deployment option and pricing tier should you configure?

Azure SQL Database managed instance General Purpose

You plan to move two 100-GB databases to Azure.You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?

two Azure SQL Databases in an elastic pool

two databases hosted in SQL Server on an Azure virtual machine

two databases in an Azure SQL Managed instance

You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1. You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync. You need to recommend a database service for the deployment. The solution must minimize administrative effort. What should you include in the recommendation?

Azure SQL Database single database

SQL Server on Azure virtual machines

You have an Azure subscription that uses a domain named contoso.com.You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a default SQL Server instance. DBServer1 is in the East US Azure region and contains a database named DatabaseA. DBServer2 is in the West US Azure region.DBServer1 has a high volume of data changes and low latency requirements for data writes.You need to configure a new availability group for DatabaseA. The secondary replica will reside on DBServer2.What should you do?

Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode to Asynchronous.

Configure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the secondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode to Asynchronous.

Configure the primary endpoint as TCP://DBServer1.contoso.com:445, configure the secondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode to Synchronous.

Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode to Asynchronous.

Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure the secondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability mode to Synchronous.

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.What should you include in the recommendation?

Windows Server Failover Cluster

Microsoft DP-300 Practice Test 3 - Free Online Exam Prep & Questions

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?

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

Show Case Study

Comment (0)

Microsoft DP-300 Practice Test 3

Question

Microsoft DP-300 Practice Tests

Practice Tests