The Microsoft DP-300 Questions & Practice Test are Available On-Demand
Valid DP-300 Exam Dumps Ensure you a HIGH SCORE
The Microsoft DP-300 is also known as Administering Relational Databases on Microsoft Azure. It is a broad step towards emerging as a top-notch Microsoft accredited Azure Database Administrator Associate. As a rule, this test has mainly been conducted to check out an aspirant’s capability to perform countless tasks, such as implementing a safe environment, analyzing and improving various operational supplies, improving query performance, performing administration by utilizing T-SQL, planning, incorporating resources of data platform, and finally accomplishing automation of tasks.
To prepare for the DP-300 certification exam, Microsoft offers a range of resources, including online training courses, practice exams, and study guides. These resources can help you familiarize yourself with the exam format, identify areas where you need to improve, and build your confidence before taking the exam.
NEW QUESTION # 38
You have an Azure subscription that contains the resources shown in the following table.
You need to configure a connection between VM1 and MIL The solution must meet the following requirements:
* The connection must be encrypted.
* Network latency must be minimized.
What should you implement?
- A. virtual network peering
- B. private endpoints
- C. service endpoints
- D. a site-to-site VPN
Answer: B
NEW QUESTION # 39
You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.
Which Azure Storage functionality should you include in the solution?
- A. change feed
- B. soft delete
- C. time-based retention
- D. lifecycle management
Answer: D
Explanation:
The lifecycle management policy lets you:
Delete blobs, blob versions, and blob snapshots at the end of their lifecycles
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts
NEW QUESTION # 40
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.
Answer:
Explanation:
Explanation
NEW QUESTION # 41
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 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 # 42
Hotspot Question
You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
You execute the Transact-SQL query 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.
Answer:
Explanation:
Explanation:
Box 1: CSV files that have file named beginning with "tripdata_2020"
Box 2: a header
FIRSTROW = 'first_row'
Specifies the number of the first row to load. The default is 1 and indicates the first row in the specified data file. The row numbers are determined by counting the row terminators. FIRSTROW is 1-based.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-openrowset
NEW QUESTION # 43
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:
Explanation
Text Description automatically generated
Reference:
https://sqlserverguides.com/read-only-replica-azure-sql/
NEW QUESTION # 44
You have an Azure subscription.
You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
How should you complete the template? 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/database/single-database-create-arm-template-quickstart
NEW QUESTION # 45
You have an Azure SQL database named db1 that contains an Azure Active Directory (Azure AD) user named user1.
You need to test impersonation of user1 in db1 by running a SELECT statement and returning to the original execution context.
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/execute-as-transact-sql?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/t-sql/functions/suser-sname-transact-sql?view=sql-server-ver15
NEW QUESTION # 46
You have SQL Server on an Azure virtual machine that contains a database named DB1.
The database reports a CHECKSUM error.
You need to recover the database.
How should you complete the statements? 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/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql
NEW QUESTION # 47
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. Azure SQL Analytics alerts based on metrics
- B. SQL Health Check alerts based on metrics
- C. Azure SQL Analytics alerts based on diagnostics logs
- D. SQL Health Check alerts based on diagnostics logs
Answer: C
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-expor
NEW QUESTION # 48
You have an Azure SQL database named sqldb1.
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?
- A. Double the value of Statistics Collection Interval
- B. Decrease by half the value of Statistics Collection interval
- C. Decrease by half the value of Data Flush Interval
- D. Double the value of Data Flush interval
Answer: C
Explanation:
The Max Size (MB) limit isn't strictly enforced. Storage size is checked only when Query Store writes data to
disk. This interval is set by the Data Flush Interval (Minutes) option. If Query Store has breached the maximum
size limit between storage size checks, it transitions to read-only mode.
Incorrect Answers:
C: Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed in
minutes. The default is 60 minutes. Consider using a lower value if you require finer granularity or less time to
detect and mitigate issues. Keep in mind that the value directly affects the size of Query Store data.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store
NEW QUESTION # 49
You are building an Azure virtual machine.
You allocate two 1-TiB, P30 premium storage disks to the virtual machine. Each disk provides 5,000 IOPS.
You plan to migrate an on-premises instance of Microsoft SQL Server to the virtual machine. The instance has a database that contains a 1.2-TiB data file. The database requires 10,000 IOPS.
You need to configure storage for the virtual machine to support the database.
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation:
Follow these same steps to create striped virtual disk:
* Create Log Storage Pool.
* Create Virtual Disk
* Create Volume
Box 1: a storage pool
Box 2: a virtual disk that uses stripe layout
Disk Striping: Use multiple disks and stripe them together to get a combined higher IOPS and Throughput limit. The combined limit per VM should be higher than the combined limits of attached premium disks.
Box 3: a volume
Reference:
https://hanu.com/hanu-how-to-striping-of-disks-for-azure-sql-server/
NEW QUESTION # 50
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 the on-premises networks shown in the following table.
You have an Azure subscription that contains an Azure SQL Database server named SQL1.
SQL1 contains two databases named DB1 and DB2.
You need to configure access to DB1 and DB2. The solution must meet the following requirements:
- Ensure that DB1 can be accessed only by users in Branch1.
- Ensure that DB2 can be accessed only by users in Branch2.
Solution: You connect to the master of SQL1 and run the following command.
EXECUTE sp_set_firewall_rule 'Allow db1 and db2 users', '131.107.10.0',
'131.107.10.255'
Does this meet the goal?
- A. No
- B. Yes
Answer: A
NEW QUESTION # 51
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.
Answer:
Explanation:
1 - Create an Azure AD administrator for the logical server
2 - Create contained database users
3 - Connect to the databases by using an Azure AD account
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
NEW QUESTION # 52
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.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
NEW QUESTION # 53
You have a new Azure SQL database. The database contains a column that stores confidential information.
You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Apply sensitivity labels named Highly Confidential to the column.
- B. Turn on auditing and write audit logs to an Azure Storage account.
- C. Turn on Advanced Data Security for the Azure SQL server.
- D. Add extended properties to the column.
- E. Turn on Azure Advanced Threat Protection (ATP).
Answer: A,B,C
Explanation:
C: Advanced Data Security (ADS) is a unified package for advanced SQL security capabilities. ADS is available for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It includes functionality for discovering and classifying sensitive data D: You can apply sensitivity-classification labels persistently to columns by using new metadata attributes that have been added to the SQL Server database engine. This metadata can then be used for advanced, sensitivity-based auditing and protection scenarios.
A: An important aspect of the information-protection paradigm is the ability to monitor access to sensitive data.
Azure SQL Auditing has been enhanced to include a new field in the audit log called data_sensitivity_information. This field logs the sensitivity classifications (labels) of the data that was returned by a query. Here's an example:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview
NEW QUESTION # 54
Drag and Drop Question
You have a burstable Azure virtual machine named VMI that hosts an instance of Microsoft SQL Server.
You need to attach an Azure ultra disk to VMI. The solution must minimize downtime on VMI.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
NEW QUESTION # 55
You have an Azure subscription.
You need to deploy an Azure SQL managed instance by using an Azure Resource Manager (ARM) template.
The solution must meet the following requirements:
The SQL managed instance must be assigned a unique identity.
The SQL managed instance must be available in the event of an Azure datacenter outage.
How should you complete the template? To answer, drag the appropriate values to the correct targets. Each value 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.
Answer:
Explanation:
Explanation:
NEW QUESTION # 56
......
DP-300 Exam Practice Questions prepared by Microsoft Professionals: https://pass4sure.updatedumps.com/Microsoft/DP-300-updated-exam-dumps.html