New (2024) Download free DP-300 PDF for Microsoft Practice Tests
100% Free DP-300 Files For passing the exam Quickly
Microsoft DP-300 exam consists of multiple-choice questions and performance-based tasks that require candidates to demonstrate their ability to perform various database administration tasks on Azure. DP-300 exam is divided into several sections, each of which covers a specific area of database administration. Candidates must score at least 700 out of 1000 points to pass the exam.
Microsoft DP-300 evaluates one’s capacity to perform the technical tasks identified in the exam objectives. It is important to review these topics before sitting for the test and develop competence in each domain. The details of the subject area that you need to study for this certification exam are enumerated below:
Plan and Apply Data Platform Resources: 15-20%
- Assess the Strategy for Transferring to Azure: This topic covers competence in assessing online/offline migration strategies, prerequisites for migrations, online/offline upgrade strategies, and prerequisites for the upgrade.
- Use Manual Techniques to Deploy Resources: The candidates must demonstrate competence in deploying different database offerings on specific platforms, configuring tailored deployment models, and using updates and patches for IaaS and hybrid deployment.
- Implement the Upgrade/Migration Strategy for Transferring to Azure: The applicants should develop competence in implementing the online/offline migration and online/offline upgrade strategies.
- Suggest a Suitable Database Offering according to Specified Prerequisites: This section requires that the examinees have the skills in measuring the prerequisites for deploying as well as measuring the functional impacts/benefits of likely database offerings. They should also have the expertise in evaluating various security areas of probable database offerings as well as HA/DR of likely database offerings.
- Configure Identified Resources for Performance & Scale: This domain will measure the individuals’ skills in the configuration of Azure SQL database, managed instances, and Azure VMs for performance and scale. It also evaluates their capacity to measure the resource prerequisites, set-up SQL Data Sync, and assess database partitioning methods.
The DP-300 certification exam is intended for database administrators, architects, and developers who work with Azure SQL Database and Azure SQL Managed Instance. Candidates who pass the exam can demonstrate their proficiency in designing, implementing, and managing databases on the Azure platform, as well as their ability to troubleshoot issues and optimize performance.
NEW QUESTION # 125
You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order.
You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders.
What should you include in the solution? To answer, select the appropriate options in the answer are a.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 126
You have an Azure SQL database.
You are reviewing a slow performing query 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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics?view=sql-server-ver15
NEW QUESTION # 127
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?
- A. SQL Health Check alerts based on diagnostics logs
- B. SQL Health Check alerts based on metrics
- C. Azure SQL Analytics alerts based on diagnostics logs
- D. Azure SQL Analytics alerts based on metrics
Answer: C
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-expor
NEW QUESTION # 128
Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection.
You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database.
What should you use?
- A. Azure Database Migration Service
- B. Azure Data BOX
- C. Azure Migrate
- D. Data Migration Assistant (DMA)
Answer: A
Explanation:
https://www.techtarget.com/searchitoperations/tip/Easily-transfer-VMs-to-the-cloud-with-Microsoft-Azure-Migrate
NEW QUESTION # 129
You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.
ADF1 contains the following pipelines:
P1:Uses a copy activity to copy data from a nonpartitioned table in a dedicated SQL pool of WS1 to an Azure Data Lake Storage Gen2 account P2:Uses a copy activity to copy data from text-delimited files in an Azure Data Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2 You need to configure P1 and P2 to maximize parallelism and performance.
Which dataset settings should you configure for the copy activity of each pipeline? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse
https://docs.microsoft.com/en-us/azure/data-factory/load-azure-sql-data-warehouse
NEW QUESTION # 130
You have an Azure SQL database named D61.
You need to identify how much unused space in megabytes was allocated to DB1.
How should you complete the Transact-SQL query? To answer select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION # 131
You have an Azure subscription that contains an Azure SQL database named db1.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. an Azure logic app
- B. an Azure function
- C. a storage account
- D. a Log Analytics workspace
- E. a virtual machine
Answer: D,E
NEW QUESTION # 132
You have an Azure SQL database that contains a table named factSales. FactSales contains the columns
shown in the following table.
FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?
- A. row compression
- B. columnstore archival compression
- C. page compression
- D. columnstore compression
Answer: B
Explanation:
Section: [none]
Explanation:
Columnstore tables and indexes are always stored with columnstore compression. You can further reduce the
size of columnstore data by configuring an additional compression called archival compression.
Note: Columnstore - The columnstore index is also logically organized as a table with rows and columns, but
the data is physically stored in a column-wise data format.
Incorrect Answers:
B: Rowstore - The rowstore index is the traditional style that has been around since the initial release of SQL
Server.
For rowstore tables and indexes, use the data compression feature to help reduce the size of the database.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression
NEW QUESTION # 133
You have an Azure SQL database named that contains a table named Table1.
You run a query to bad data into Table1.
The performance Of Table1 during the load operation are shown in exhibit.
Answer:
Explanation:
Explanation
NEW QUESTION # 134
You have an Azure subscription.
You need to deploy an Azure SQL managed instance that meets the following requirements:
*Optimize latency.
*Maximize the memory-to-vCore ratio.
Which service tier and hardware generation should you use? To answer, select the apocopate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 135
You have an Azure SQL managed instance named MI1.
You need to implement automatic tuning for the databases of MI1.
What should you do?
- A. Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property.
- B. From the Azure portal, configure automatic tuning.
- C. Use Transact-SQL to enable the force_last_good_plan option.
Answer: C
NEW QUESTION # 136
You plan to perform batch processing in Azure Databricks once daily.
Which type of Databricks cluster should you use?
- A. High Concurrency
- B. automated
- C. interactive
Answer: B
Explanation:
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
NEW QUESTION # 137
Case Study 2 - Contoso, Ltd
Overview
General Overview
Contoso, Ltd. is a financial data company that has 100 employees. The company delivers financial data to customers.
Physical Locations
Contoso has a datacenter in Los Angeles and an Azure subscription. All Azure resources are in the US West 2 Azure region. Contoso has a 10-Gb ExpressRoute connection to Azure.
The company has customers worldwide.
Existing Environment
Active Directory
Contoso has a hybrid Azure Active Directory (Azure AD) deployment that syncs to on-premises Active Directory.
Database Environment
Contoso has SQL Server 2017 on Azure virtual machines shown in the following table.
SQL1 and SQL2 are in an Always On availability group and are actively queried. SQL3 runs jobs, provides historical data, and handles the delivery of data to customers.
The on-premises datacenter contains a PostgreSQL server that has a 50-TB database.
Current Business Model
Contoso uses Microsoft SQL Server Integration Services (SSIS) to create flat files for customers.
The customers receive the files by using FTP.
Requirements
Planned Changes
Contoso plans to move to a model in which they deliver data to customer databases that run as platform as a service (PaaS) offerings. When a customer establishes a service agreement with Contoso, a separate resource group that contains an Azure SQL database will be provisioned for the customer. The database will have a complete copy of the financial data. The data to which each customer will have access will depend on the service agreement tier. The customers can change tiers by changing their service agreement.
The estimated size of each PaaS database is 1 TB.
Contoso plans to implement the following changes:
Move the PostgreSQL database to Azure Database for PostgreSQL during the next six months.
Upgrade SQL1, SQL2, and SQL3 to SQL Server 2019 during the next few months.
Start onboarding customers to the new PaaS solution within six months.
Business Goals
Contoso identifies the following business requirements:
Use built-in Azure features whenever possible.
Minimize development effort whenever possible.
Minimize the compute costs of the PaaS solutions.
Provide all the customers with their own copy of the database by using the PaaS solution.
Provide the customers with different table and row access based on the customer's service agreement.
In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal downtime. The solution must provide automatic failover.
Ensure that users of the PaaS solution can create their own database objects but he prevented from modifying any of the existing database objects supplied by Contoso.
Technical Requirements
Contoso identifies the following technical requirements:
Users of the PaaS solution must be able to sign in by using their own corporate Azure AD credentials or have Azure AD credentials supplied to them by Contoso. The solution must avoid using the internal Azure AD of Contoso to minimize guest users.
All customers must have their own resource group, Azure SQL server, and Azure SQL database. The deployment of resources for each customer must be done in a consistent fashion.
Users must be able to review the queries issued against the PaaS databases and identify any new objects created.
Downtime during the PostgreSQL database migration must be minimized.
Monitoring Requirements
Contoso identifies the following monitoring requirements:
Notify administrators when a PaaS database has a higher than average CPU usage.
Use a single dashboard to review security and audit data for all the PaaS databases.
Use a single dashboard to monitor query performance and bottlenecks across all the PaaS databases.
Monitor the PaaS databases to identify poorly performing queries and resolve query performance issues automatically whenever possible.
PaaS Prototype
During prototyping of the PaaS solution in Azure, you record the compute utilization of a customer's Azure SQL database as shown in the following exhibit.
Role Assignments
For each customer's Azure SQL Database server, you plan to assign the roles shown in the following exhibit.
Hotspot Question
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.
Answer:
Explanation:
Explanation:
Box 1: No
DBAGroup1 is member of the Contributor role.
The Contributor role grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC, manage assignments in Azure Blueprints, or share image galleries.
Box 2: No
Contributor - Grants full access to manage all resources, but does not allow you to assign roles in Azure RBAC SQL DB Contributor - Lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers.
Box 3: Yes
DBAGroup2 is member of the SQL DB Contributor role.
The SQL DB Contributor role lets you manage SQL databases, but not access to them. Also, you can't manage their security-related policies or their parent SQL servers. As a member of this role you can create and manage SQL databases.
Reference:
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles
NEW QUESTION # 138
Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks.
You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions in the answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Configure your Azure Databricks cluster to use the Databricksmonitoring library.
2 - Build the spark-listeners-loganalytics-1.0-SNAPSHOT.jar JAR file
3 - Create Dropwizard counters in your application code.
NEW QUESTION # 139
You have an Azure subscription that contains the resources shown in the following table.
You need to create a read-only replica of DB1 and configure the App1 instances to use the replica.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://sqlserverguides.com/read-only-replica-azure-sql/
NEW QUESTION # 140
You have an Azure SQL database named D61.
You need to identify how much unused space in megabytes was allocated to DB1.
How should you complete the Transact-SQL query? To answer select the appropriate options m the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION # 141
You have SQL Server on an Azure virtual machine.
You need to use Policy-Based Management in Microsoft SQL Server to identify stored procedures that do not comply with your naming conventions.
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.
Answer:
Explanation:
1 - Create a custom condition based on a built-in facet.
2 - Create a custom policy based on a condition.
3 - Run a policy evalution.
Reference:
https://www.mssqltips.com/sqlservertip/2298/enforce-sql-server-database-naming-conventions-using-policy-based-management/
NEW QUESTION # 142
You plan to migrate on-premises Microsoft SQL Server databases to Azure.
You need to identify which deployment and resiliency options meet the following requirements:
Support user-initiated backups.
Support multiple automatically replicated instances across Azure regions.
Minimize administrative effort to implement and maintain business continuity.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview
https://docs.microsoft.com/en-us/dotnet/architecture/cloud-native/infrastructure-resiliency-azure
NEW QUESTION # 143
You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime.
What should you do?
- A. Import a BACPAC.
- B. Configure transactional replication.
- C. Implement Always On availability groups.
- D. Configure Transaction Log Shipping.
Answer: A
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server#method-1-migration-with-downtime-during-the-migration
NEW QUESTION # 144
......
DP-300 Premium Exam Engine - Download Free PDF Questions: https://itcertspass.itcertmagic.com/Microsoft/real-DP-300-exam-prep-dumps.html