Share real and effective Microsoft DP-300 exam dumps for free. 13 Online DP-300 Exam Practice test questions and answers, online DP-300 pdf download,
easy to learn! Get the full DP-300 Dumps: https://www.leads4pass.com/dp-300.html (Total Questions: 178 Q&A)
to make it easy to pass the exam!
This exam measures your ability to accomplish the following technical tasks: plan and implement data platform resources; implement a secure environment; monitor and optimize operational resources; optimize query performance; perform automation of tasks; plan and implement a High Availability and Disaster Recovery (HADR) environment; and perform administration by using T-SQL.
[PDF] Free Microsoft DP-300 pdf dumps download from Google Drive: https://drive.google.com/file/d/1duhcgEZyoqVXtoqS6VRrS_qCNr98LKD8/
Latest effective Microsoft DP-300 Exam Practice Tests
QUESTION 1
HOTSPOT
You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales.
You need to initiate a backup of Sales.
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.
Hot Area:
Correct Answer:
Box 1: TO URL = \\’https://storage1.blob.core.windows.net/blob1/Sales.bak\\’
Native database backup in Azure SQL Managed Instance.
You can backup any database using standard BACKUP T-SQL command:
BACKUP DATABASE tpcc2501
TO URL = \\’https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak\\’
WITH COPY_ONLY
Box 2: WITH COPY_ONLY
Reference:
https://techcommunity.microsoft.com/t5/azure-sql-database/native-database-backup-in-azure-sql-managed-instance/bap/386154
QUESTION 2
HOTSPOT
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.
Hot Area:
Correct Answer:
Scenario: Business Requirements
Litware identifies business requirements include: meet an SLA of 99.99% availability for all Azure deployments.
Box 1: Cloud witness
If you have a Failover Cluster deployment, where all nodes can reach the internet (by extension of Azure), it is
recommended that you configure a Cloud Witness as your quorum witness resource.
Box 2: Azure Basic Load Balancer
Microsoft guarantees that a Load Balanced Endpoint using Azure Standard Load Balancer, serving two or more Healthy
Virtual Machine Instances, will be available 99.99% of the time.
Note: There are two main options for setting up your listener: external (public) or internal. The external (public) listener
uses an internet facing load balancer and is associated with a public Virtual IP (VIP) that is accessible over the internet.
An
internal listener uses an internal load balancer and only supports clients within the same Virtual Network.
Reference: https://technet.microsoft.com/windows-server-docs/failover-clustering/deploy-cloud-witness
https://azure.microsoft.com/en-us/support/legal/sla/load-balancer/v1_0/
QUESTION 3
HOTSPOT
You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription
contains an Azure Synapse Analytics SQL pool named Pool1.
You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication
(MFA) and database-level authentication.
Which authentication solution or solutions should you include in the recommendation? To answer, select the appropriate
options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Azure AD authentication
Azure Active Directory authentication supports Multi-Factor authentication through Active Directory Universal
Authentication.
Box 2: Contained database users
Azure Active Directory Uses contained database users to authenticate identities at the database level.
Incorrect:
SQL authentication: To connect to dedicated SQL pool (formerly SQL DW), you must provide the following information:
1.
Fully qualified servername
2.
Specify SQL authentication
3.
Username
4.
Password
5.
Default database (optional)
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouseauthentication
QUESTION 4
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 SQL database named Sales.
You need to implement disaster recovery for Sales to meet the following requirements:
1.
During normal operations, provide at least two readable copies of Sales.
2.
Ensure that Sales remains available if a datacenter fails.
Solution: You deploy an Azure SQL database that uses the Business Critical service tier and Availability Zones.
Does this meet the goal?
A. Yes
B. No
Correct Answer: A
Premium and Business Critical service tiers leverage the Premium availability model, which integrates compute
resources (sqlservr.exe process) and storage (locally attached SSD) on a single node. High availability is achieved by
replicating both compute and storage to additional nodes creating a three to four-node cluster.
By default, the cluster of nodes for the premium availability model is created in the same datacenter. With the
introduction of Azure Availability Zones, SQL Database can place different replicas of the Business Critical database to
different availability zones in the same region. To eliminate a single point of failure, the control ring is also duplicated
across multiple zones as three gateway rings (GW).
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
QUESTION 5
You are creating a new notebook in Azure Databricks that will support R as the primary language but will also support
Scala and SQL. Which switch should you use to switch between languages?
A. \\[]
B. %
C. \\[]
D. @
Correct Answer: B
You can override the default language by specifying the language magic command % at the beginning of a cell. The
supported magic commands are: %python, %r, %scala, and %sql.
Reference: https://docs.microsoft.com/en-us/azure/databricks/notebooks/notebooks-use
QUESTION 6
You plan to perform batch processing in Azure Databricks once daily. Which type of Databricks cluster should you use?
A. automated
B. interactive
C. High Concurrency
Correct Answer: A
Azure Databricks makes a distinction between all-purpose clusters and job clusters. You use all-purpose clusters to
analyze data collaboratively using interactive notebooks. You use job clusters to run fast and robust automated jobs.
The Azure Databricks job scheduler creates a job cluster when you run a job on a new job cluster and terminates the
cluster when the job is complete.
Reference:
https://docs.microsoft.com/en-us/azure/databricks/clusters
QUESTION 7
You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?
A. Restore with Recovery
B. Restore with Norecovery
C. Restore with Standby
Correct Answer: B
Prepare a secondary database for an Always On availability group requires two steps:
1.
Restore a recent database backup of the primary database and subsequent log backups onto each server instance that
hosts the secondary replica, using RESTORE WITH NORECOVERY
2.
Join the restored database to the availability group.
Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondarydatabase-for-an-availability-group-sql-server
QUESTION 8
HOTSPOT
You have SQL Server on an Azure virtual machine.
You review the query plan shown in the following exhibit.
For each of the following statements, select yes if the statement is true. Otherwise, select no. NOTE: Each correct
selection is worth one point.
Hot Area:
Correct Answer:
QUESTION 9
DRAG DROP
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.
Select and Place:
Correct Answer:
Step 1: Create an Azure Policy Initiative
The first step in enforcing compliance with Azure Policy is to assign a policy definition. A policy definition defines under
what condition a policy is enforced and what effect to take.
With an initiative definition, you can group several policy definitions to achieve one overarching goal. An initiative
evaluates resources within scope of the assignment for compliance to the included policies.
Step 2: Create an Azure Policy Initiative assignment
Assign the initiative definition you created in the previous step.
Step 3: Run Azure Policy remediation tasks
To apply the Policy Initiative to the existing SQL databases.
Reference:
https://docs.microsoft.com/en-us/azure/governance/policy/tutorials/create-and-manage
QUESTION 10
You have an Azure Stream Analytics job.
You need to ensure that the job has enough streaming units provisioned.
You configure monitoring of the SU % Utilization metric.
Which two additional metrics should you monitor? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Late Input Events
B. Out of order Events
C. Backlogged Input Events
D. Watermark Delay
E. Function Events
Correct Answer: CD
To react to increased workloads and increase streaming units, consider setting an alert of 80% on the SU Utilization
metric. Also, you can use watermark delay and backlogged events metrics to see if there is an impact.
Note: Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies
that your job isn\\’t able to keep up with the number of incoming events. If this value is slowly increasing or consistently
nonzero, you should scale out your job, by increasing the SUs.
Reference: https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring
QUESTION 11
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 two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database
named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: From Microsoft SQL Server Management Studio (SSMS), you rename Database1 on Server2 as Database2.
From the Azure portal, you create a new database on Server2 by restoring the backup of Database1 from Server1, and
then you delete Database2.
Does this meet the goal?
A. Yes
B. No
Correct Answer: B
Instead restore Database1 from Server1 to the Server2 by using the RESTORE Transact-SQL command and the
REPLACE option.
Note: REPLACE should be used rarely and only after careful consideration. Restore normally prevents accidentally
overwriting a database with a different database. If the database specified in a RESTORE statement already exists on
the current server and the specified database family GUID differs from the database family GUID recorded in the
backup set, the database is not restored. This is an important safeguard.
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/restore-statements-transact-sql
QUESTION 12
HOTSPOT
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.
Hot Area:
Correct Answer:
Box 1: Full and log backups only
Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn\\’t
support backups that are appended to a single backup file. Take full backup and log backups to separate backup files.
Box 2: WITH CHECKSUM
Azure Database Migration Service uses the backup and restore method to migrate your on-premises databases to SQL
Managed Instance. Azure Database Migration Service only supports backups created using checksum.
Incorrect Answers:
NOINIT Indicates that the backup set is appended to the specified media set, preserving existing backup sets. If a
media password is defined for the media set, the password must be supplied. NOINIT is the default.
UNLOAD
Specifies that the tape is automatically rewound and unloaded when the backup is finished. UNLOAD is the default
when a session begins.
Reference:
https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online
QUESTION 13
HOTSPOT
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.
Hot Area:
Correct Answer:
Box 1: Hash
Scenario:
Ensure that queries joining and filtering sales transaction records based on product ID complete as quickly as possible.
A hash distributed table can deliver the highest query performance for joins and aggregations on large tables.
Box 2: Round-robin
Scenario:
You plan to create a promotional table that will contain a promotion ID. The promotion ID will be associated to a specific
product. The product will be identified by a product ID. The table will be approximately 5 GB.
A round-robin table is the most straightforward table to create and delivers fast performance when used as a staging
table for loads. These are some scenarios where you should choose Round robin distribution:
When you cannot identify a single key to distribute your data.
If your data doesn\\’t frequently join with data from other tables.
When there are no obvious keys to join.
Incorrect Answers:
Replicated: Replicated tables eliminate the need to transfer data across compute nodes by replicating a full copy of the
data of the specified table to each compute node. The best candidates for replicated tables are tables with sizes less
than
2 GB compressed and small dimension tables.
Reference:
https://rajanieshkaushikk.com/2020/09/09/how-to-choose-right-data-distribution-strategy-for-azure-synapse/
Share 13 of the latest Microsoft DP-300 exam questions and answers for free to help you improve your skills and select the complete DP-300 Dumps: https://www.leads4pass.com/dp-300.html (Total Questions: 178 Q&A) through the exam! Guaranteed to be true and effective! Easily pass the exam!
[PDF] Free Microsoft DP-300 pdf dumps download from Google Drive: https://drive.google.com/file/d/1duhcgEZyoqVXtoqS6VRrS_qCNr98LKD8/