The latest Microsoft DP-300 dumps by Lead4Pass helps you pass the DP-300 exam for the first time! Lead4Pass Latest Update Microsoft DP-300 VCE Dump and DP-300 PDF Dumps, Lead4Pass DP-300 Exam Questions Updated, Answers corrected! Get the latest LeadPass DP-300 dumps with Vce and PDF: https://www.leads4pass.com/dp-300.html (Q&As: 56 dumps)
[Free DP-300 PDF] Microsoft DP-300 Dumps PDF can be collected on Google Drive shared by Lead4Pass:
https://drive.google.com/file/d/1sPBWnDsr6Oz8Rpxz5iIL7T9eNkSZMVLo/
[Lead4pass DP-300 Youtube] Microsoft DP-300 Dumps can be viewed on Youtube shared by Lead4Pass
Microsoft DP-300 Online Exam Practice Questions
QUESTION 1
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance
requirements.
What should you run as part of the implementation?
A. CREATE LOGIN and the FROM WINDOWS clause
B. CREATE USER and the FROM CERTIFICATE clause
C. CREATE USER and the FROM LOGIN clause
D. CREATE USER and the ASYMMETRIC KEY clause
E. CREATE USER and the FROM EXTERNAL PROVIDER clause
Correct Answer: E
Scenario: Authenticate database users by using Active Directory credentials.
(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.)
Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user:
CREATE USER [[email protected]] FROM EXTERNAL PROVIDER;
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql
QUESTION 2
DRAG DROP
You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1.
The only user who was created is the server administrator.
You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for
authentication.
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: Set up the Active Directory Admin for AzSQL1.
Step 2: Connect to DB1 by using the server administrator.
Sign in to your managed instance with an Azure AD login granted with the sysadmin role.
Step 3: Create a user by using the FROM EXTERNAL PROVIDER clause.
FROM EXTERNAL PROVIDER is available for creating server-level Azure AD logins in SQL Database managed
instance. Azure AD logins allow database-level Azure AD principals to be mapped to server-level Azure AD logins. To
create an
Azure AD user from an Azure AD login use the following syntax:
CREATE USER [AAD_principal] FROM LOGIN [Azure AD login]
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql
QUESTION 3
You have an Azure SQL database.
You identify a long-running query.
You need to identify which operation in the query is causing the performance issue.
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
A. Live Query Statistics
B. an estimated execution plan
C. an actual execution plan
D. Client Statistics
Correct Answer: C
To include an execution plan for a query during execution
1.
On the SQL Server Management Studio toolbar, click Database Engine Query. You can also open an existing query
and display the estimated execution plan by clicking the Open File toolbar button and locating the existing query.
2.
Enter the query for which you would like to display the actual execution plan.
3.
On the Query menu, click Include Actual Execution Plan or click the Include Actual Execution Plan toolbar button.
Note: Actual execution plans are generated after the Transact-SQL queries or batches execute. Because of this, an
actual execution plan contains runtime information, such as actual resource usage metrics and runtime warnings (if
any). The execution plan that is generated displays the actual query execution plan that the SQL Server Database Engine used to execute the queries.
Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/display-an-actual-execution-plan
QUESTION 4
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 back up any database using the 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 5
DRAG DROP
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.
Select and Place:
Correct Answer:
Scenario: Authenticate database users by using Active Directory credentials.
The configuration steps include the following procedures to configure and use Azure Active Directory authentication.
Create and populate Azure AD.
Optional: Associate or change the active directory that is currently associated with your Azure Subscription.
Create an Azure Active Directory administrator. (Step 1)
Configure your client’s computers.
Create contained database users in your database mapped to Azure AD identities. (Step 2) Connect to your database
by using Azure AD identities. (Step 3)
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
QUESTION 6
HOTSPOT
You have an Azure SQL database that contains a table named Customer. The customer has the columns shown in the
following table.
You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following
requirements:
The first six numerals of each customer\\’s phone number must be masked. The last four digits of each customer\\’s
phone number must be visible. Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.
Hot Area:
Correct Answer:
Box 1: 0 Custom String: Masking method that exposes the first and last letters and adds a custom padding string in the
middle. prefix,[padding],suffix Box 2: xxx-xxx
Box 3: 5 Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking
QUESTION 7
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?
A. Azure SQL Database Premium
B. Azure SQL Database serverless
C. Azure SQL Database managed instance Business Critical
D. Azure SQL Database Standard
Correct Answer: A
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). The routing to a specific gateway ring is controlled by Azure Traffic
Manager (ATM). Because the zone redundant configuration in the Premium or Business Critical service tiers does not
create additional database redundancy, you can enable it at no extra cost. By selecting a zone redundant configuration,
you can make your Premium or Business Critical databases resilient to a much larger set of failures, including
catastrophic datacenter outages, without any changes to the application logic. You can also convert any existing
Premium or Business Critical databases or pools to the zone redundant configuration.
Incorrect Answers:
C. This feature is not available in SQL Managed Instance.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
QUESTION 8
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the
internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.
Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.
What should you create on VNet1?
A. a VPN gateway
B. a service endpoint
C. a private link
D. an ExpressRoute gateway
Correct Answer: C
Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and
Azure-hosted customer-owned/partner services over a private endpoint in your virtual network.
Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to
the public internet is no longer necessary.
Reference:
https://docs.microsoft.com/en-us/azure/private-link/private-link-overview
QUESTION 9
HOTSPOT
You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is 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.
Hot Area:
Correct Answer:
Box 1: delete a row from Table1
Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.
Box 2: db_datareader
Members of the db_datareader fixed database role can read all data from all user tables.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles
QUESTION 10
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?
A. Automated Backup in the SQL virtual machine settings
B. Azure Backup
C. Azure Site Recovery
D. SQL Server Agent jobs
Correct Answer: B
Azure Backup provides an Enterprise-class backup capability for SQL Server on Azure VMs. All backups are stored and
managed in a Recovery Services vault. There are several advantages that this solution provides, especially for
Enterprises.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/backup-restore#azbackup
QUESTION 11
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named
CustomerPII.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. server audit specification
B. SQL Server audit
C. database audit specification
D. a server principal
Correct Answer: AC
An auditing policy can be defined for a specific database or as a default server policy in Azure (which hosts SQL
Database or Azure Synapse):
A server policy applies to all existing and newly created databases on the server.
If server auditing is enabled, it always applies to the database. The database will be audited, regardless of the database
auditing settings.
Enabling auditing on the database, in addition to enabling it on the server, does not override or change any of the
settings of the server auditing. Both audits will exist side by side.
Note:
The Server Audit Specification object belongs to an audit.
A Database Audit Specification defines which Audit Action Groups will be audited for the specific database in which the specification is created.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview
QUESTION 12
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. page compression
B. row compression
C. columnstore compression
D. columnstore archival compression
Correct Answer: D
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 column store 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
QUESTION 13
You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases.
The databases perform slower than expected.
You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1.
What should you do?
A. Run Query Store-based queries
B. Review information provided by SQL Server Profiler-based traces
C. Review information provided by Query Performance Insight
D. Run dynamic management view-based queries
Correct Answer: D
The diagnostics log outputs temp DB contention details. You can use the information as the starting point for
troubleshooting. You can use the Intelligent Insights performance diagnostics log of Azure SQL Database to
troubleshoot performance issues. Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdbcontention https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log
latest updated Microsoft DP-300 exam questions from the Lead4Pass DP-300 dumps! 100% pass the DP-300 exam! Download Lead4Pass DP-300 VCE and PDF dumps: https://www.leads4pass.com/dp-300.html (Q&As: 56 dumps)
Get free Microsoft DP-300 dumps PDF online: https://drive.google.com/file/d/1sPBWnDsr6Oz8Rpxz5iIL7T9eNkSZMVLo/
