Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free Microsoft DP-300 Exam Questions (page: 2)

Page 2 of 54
PDF with 418 Questions
View Related Case Study

HOTSPOT (Drag and Drop is not supported)

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.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Scenario:
Existing
An on-premises server named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1-TB databases.

Planned changes
Migrate the SERVER1 databases to the Azure SQL Database platform.

Business Requirements
Minimize downtime during the migration of the SERVER1 databases.

Box 1: Premium 4-vCore
Azure Database Migration Service price tier

To minimize migration time with Azure Database Migration Service (DMS), the Premium pricing tier should be used. The Premium tier, with its higher vCore options (e.g., 4 vCore), allows for faster data transfer and parallel processing, leading to quicker migration completion.
While the Standard tier is free and suitable for offline migrations, it may take longer for large databases due to slower processing speed.

Incorrect:
* Standard 2-vCore
* Standard 4-vCore

Box 2: A VPN gateway
Required Azure resource.

A VPN gateway (specifically a Site-to-Site VPN or ExpressRoute) is generally needed for migrating on- premises Microsoft SQL Server databases to Azure SQL Database using the Azure Database Migration Service (DMS). This is because DMS needs a secure and reliable connection between the on-premises SQL Server and the Azure environment where the Azure SQL Database resides.

Security:
A VPN gateway provides a secure and encrypted tunnel for data transmission between your on-premises network and Azure.

Connectivity:
DMS relies on a network connection to access the source database during the migration process. A VPN gateway ensures this connectivity.

Hybrid Environments:
Many migration scenarios involve migrating data between on-premises and cloud environments, requiring a VPN or ExpressRoute to establish a connection between them.


Reference:

https://azure.microsoft.com/en-us/pricing/details/database-migration/ https://learn.microsoft.com/en-us/azure/dms/faq



View Related Case Study

HOTSPOT (Drag and Drop is not supported)

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.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Managed Instance link
Migration service

Managed Instance link feature, which enables near real-time data replication between SQL Server and Azure SQL Managed Instance. The link provides hybrid flexibility and database mobility as it unlocks several scenarios, such as scaling read-only workloads, offloading analytics and reporting to Azure, and migrating to Azure. And, with SQL Server 2022, the link enables online disaster recovery with fail back to SQL Server (currently in preview), as well as configuring the link from SQL Managed Instance to SQL Server 2022.

Incorrect:
* log Replay Service (LRS)
Log Replay Service (LRS), which you can use to migrate databases from SQL Server to Azure SQL Managed Instance. LRS is a free cloud service that's available for Azure SQL Managed Instance and based on SQL Server log-shipping technology.

Consider using LRS in the following cases, when:

You need more control for your database migration project.
*-> There's little tolerance for downtime during migration cutover.
Etc.

However, Tip:
If you require a database to be read-only accessible during the migration, with a much longer time frame for performing the migration and with minimal downtime, consider using the Azure SQL Managed Instance link feature as a recommended migration solution.

* SQL Data Sync
Azure SQL Data Sync does not support Azure SQL Managed Instance or Azure Synapse Analytics at this time.

Box 2: A VNet-local endpoint
Target endpoint

Only VNet-local endpoint is supported to establish a link with SQL Managed Instance.

Scenario:
Availability Requirements
Minimize downtime during the migration of DB1 and DB2.

Planned Changes
Deploy an Azure SQL managed instance named Instance1 to Network1.
Migrate DB1 and DB2 to Instance1.

Existing Environment. Network Infrastructure
ADatum has an on-premises datacenter
ADatum has an on-premises datacenter and an Azure subscription named Sub1. Sub1 contains a virtual network named Network1 in the East US Azure region. The datacenter is connected to Network1 by using a Site-to-Site (S2S) VPN.

Existing Environment. Database Environment
SVR1: Windows Server 2016 with SQL Server 2016 Enterprise, and has Always On availability group containing databases DB1 and Db2.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-feature-overview



View Related Case Study

HOTSPOT (Drag and Drop is not supported)

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.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Premium
Service tier

The read scale-out feature allows you to offload read-only workloads using the compute capacity of one of the read-only replicas, instead of running them on the read-write replica. This way, some read-only workloads can be isolated from the read-write workloads, and don't affect their performance. The feature is intended for the applications that include logically separated read-only workloads, such as analytics. In the Premium and Business Critical service tiers, applications could gain performance benefits using this additional capacity at no extra cost.

Incorrect:
* Business Critical more expensive.

Box 2: Read-scale-out

Incorrect:
* Geo-replicated secondary replicas
Scenario: For DB1 and DB2, offload analytical workloads to a read-only database replica in the *same Azure region*.

* A failover group read-only listener

Scenario:
Requirements. Availability Requirements
ADatum identifies the following post-migration availability requirements:
For DB1 and DB2, offload analytical workloads to a read-only database replica in the same Azure region.

Business Requirements
Minimize costs whenever possible, without affecting other requirements.
Minimize administrative effort.

Existing Environment. Database Environment
SVR1: Windows Server 2016 with SQL Server 2016 Enterprise, and has Always On availability group containing databases DB1 and Db2.
DB1 and DB2 are used for transactional and analytical workloads by an application named App1.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out



You have 20 Azure SQL databases provisioned by using the vCore purchasing model.

You plan to create an Azure SQL Database elastic pool and add the 20 databases.

Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.

Note: Each correct selection is worth one point.

  1. total size of all the databases
  2. geo-replication support
  3. number of concurrently peaking databases * peak CPU utilization per database
  4. maximum number of concurrent sessions for all the databases
  5. total number of databases * average CPU utilization per database

Answer(s): A,C,E

Explanation:

CE: Estimate the vCores needed for the pool as follows:
For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB)
A: Estimate the storage space needed for the pool by adding the number of bytes needed for all the databases in the pool.


Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview



DRAG DROP (Drag and Drop is not supported)

You have a resource group named App1Dev that contains an Azure SQL Database server named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database project.

You need to populate a new resource group named App1Test with the DB1 database and an Azure SQL Server named TestServer1. The resources in App1Test must have the same configurations as the resources in App1Dev.

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.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.

You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of aXXX@XXXX.com instead.

What should you do?

  1. From the Azure portal, set a mask on the Email column.
  2. From the Azure portal, set a sensitivity classification of Confidential for the Email column.
  3. From Microsoft SQL Server Management Studio, set an email mask on the Email column.
  4. From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

Answer(s): A



You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1.

You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs.

What should you do first?

  1. Upgrade workspace1 to the Premium pricing tier.
  2. Configure a global init script for workspace1.
  3. Create a pool in workspace1.
  4. Create a cluster policy in workspace1.

Answer(s): C

Explanation:

You can use Databricks Pools to Speed up your Data Pipelines and Scale Clusters Quickly.
Databricks Pools, a managed cache of virtual machine instances that enables clusters to start and scale 4 times faster.


Reference:

https://databricks.com/blog/2019/11/11/databricks-pools-speed-up-data-pipelines.html



Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Table1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2 container named container1.

You plan to insert data from the files into Table1 and transform the data. Each row of data in the files will produce one row in the serving layer of Table1.

You need to ensure that when the source data files are loaded to container1, the DateTime is stored as an additional column in Table1.

Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that retrieves the DateTime of the files.

Does this meet the goal?

  1. Yes
  2. No

Answer(s): A

Explanation:

You can use the Get Metadata activity to retrieve the metadata of any data in Azure Data Factory or a Synapse pipeline. You can use the output from the Get Metadata activity in conditional expressions to perform validation, or consume the metadata in subsequent activities.


Reference:

https://docs.microsoft.com/en-us/azure/data-factory/control-flow-get-metadata-activity



Viewing page 2 of 54



Post your Comments and Discuss Microsoft DP-300 exam prep with other Community members:

DP-300 Exam Discussions & Posts