If you are looking for free DP-300 dumps than here we have some sample question answers available. You can prepare from our Microsoft DP-300 exam questions notes and prepare exam with this practice test. Check below our updated DP-300 exam dumps.
DumpsGroup are top class study material providers and our inclusive range of DP-300 Real exam questions would be your key to success in Microsoft Microsoft Certified: Azure Database Administrator Associate Certification Exam in just first attempt. We have an excellent material covering almost all the topics of Microsoft DP-300 exam. You can get this material in Microsoft DP-300 PDF and DP-300 practice test engine formats designed similar to the Real Exam Questions. Free DP-300 questions answers and free Microsoft DP-300 study material is available here to get an idea about the quality and accuracy of our study material.
You have an Azure subscription that contains 50 instances of SQL Server on Azure VirtualMachines. The instances host 500 Azure SQL databases. You need to ensure that all thedatabases have the same configuration. The solution must meet the followingrequirements:• Auditing must be enabled.• Azure Defender must be enabled.• Public network access must be disabled.• Administrative effort must be minimized.Which two resources should you create in the subscription? Each correct answer presentspart of the solution. NOTE: Each correct selection is worth one point.
You have an Azure subscription that contains an Azure SQL database named SQL1.SQL1 is in an Azure region that does not support availability zones.You need to ensure that you have a secondary replica of SQLI in the same region.What should you use?
You have an Azure SQL Database elastic pool that contains 10 databases.You receive the following alert.Msg 1132, Level 16, State 1, Line 1The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs.You need to resolve the alert. The solution must minimize administrative effort.Which three actions can you perform? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.
You have an Azure SQL database named SOL1.You need to implement a disaster recovery solution for SQL1. The solution must minimizethe following:• The recovery point objective JRPO)• The recovery time objective (RTO)• Administrative effortWhat should you include in the solution?
You have two Azure virtual machines named Server 1 and Server2 that run WindowsServer 2022 and are joined to an Active Directory Domain Services (AD DS) domainnamed contoso.com.Both virtual machines have a default instance of Microsoft SQL Server 2019 installed.Server1 is configured as a master server, and Server2 is configured as a target server.On Server1, you create a proxy account named contoso\sqlproxy.You need to ensure that the SQL Server Agent job steps can be downloaded from Server1and run on Server2.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts adatabase named db1. You have an Azure subscription that contains an Azure SQLmanaged instance named MI1 and an Azure Storage account named storage1.You need to ensure that you can back up db1 to storage1. The solution must meet thefollowing requirements: Use block blob storage.* Maximize security.
You have an Azure subscription that contain an Azure SQL managed instance namedSQLMI1 and a Log Analytics workspace named Workspace1.You need to collect performance metrics for SQLMI1 and stream the metrics toWorkspace1.
You have an on-premises Microsoft SQL Server 2019 database named SQL1 that usesmerge replication. You need to migrate SQL1 to Azure. Which service should you use?
You have an instance of SQL Server on Azure Virtual Machines.You need to ensure that a user named User1 can configure proxy accounts for SQL ServerAgent jobs. The solution must use the principle of least privilege.Which role should you assign to User1?
You have an on-premises datacenter that contains a 14-TB Microsoft SQL Serverdatabase.You plan to create an Azure SQL managed instance and migrate the on-premisesdatabase to the new instance.Which three service tiers support the SQL managed instance? Each correct answerpresents a complete solution. NOTE: Each correct selection is worth one point.
You have an Azure subscription that contains 20 Azure SQL databases.You create a Transact-SQL statement to perform index maintenance on a database.You need to schedule the statement to run once daily against each database by usingTransact-SQL commands.What should you use to schedule the statement?
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managedinstance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1.Which job attribute is unsupported in SQLMI1?
You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019.The virtual machine has 4 vCPUs and 28 GB of memory.Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.You need to reduce tempdb contention without regatively affecting server performance.What is the number of secondary data files that you should configure for tempdb?
You have an Azure subscription that contains a logical SQL server named Serverl. Themaster database of Serverl contains a user named Userl. You need to ensure that Userlcan create databases on Serverl. Which database role should you assign to Userl?
You plan to deploy two instances of SQL Server on Azure virtual machines in a highlyavailable configuration that will use an Always On availability group.You need to recommend a deployment solution that meets the following requirements:• Provides a Service Level Agreement (SLA) of at least 99.95%• Replicates databases in the same group synchronously• Minimizes the latency of database writesWhat should you recommend?
You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hostsseveral Azure SQL databases.You plan to assign Azure AD users permissions to the databases automatically by usingAzure Automation.You need to create the required Automation accounts.Which two accounts should you create? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.
You have an Azure subscription.You need to deploy an Instance of SQL Server on Azure Virtual Machines. The solutionmust meet the following 'requirements:• Custom performance configuration. such as lCPS. capacity, and throughout, must besupported.• Costs must be minimizedWhich type of disk should you include in the solution?
You plan to deploy two instances of SQL Server on Azure virtual machines in a highlyavailable configuration that will use an Always On availability group.You need to recommend a deployment solution that meets the following requirements:• Provides a Service Level Agreement (SLA) of at least 99.95%• Replicates databases in the same group synchronously• Minimizes the latency of database writesWhat should you recommend?
You have an on-premises Microsoft SQL Server 2019 instance that hosts a databasenamed DB1.You have an Azure subscription that contains an Azure SQL database named SQLDB1.You need to replicate DB1 to SQlDC1.Which type of replication should you use?
You have a new Azure subscription. You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1. You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
You have a Microsoft SQL Server 2017 server. You need to migrate the server to Azure. The solution must meet the following requirements: • Ensure that the latest version of SQL Server is used. • Support the SQL Server Agent service. Minimize administrative effort. What should you use?
Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1. You have an Azure subscription. You plan to migrate db1 to an Azure SQL managed instance. You need to create the SQL managed instance. The solution must minimize the disk latency of the instance. Which service tier should you use?
You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases. You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss. What should you use?
You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do?
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?
You have an instance of SQL Server on Azure Virtual Machine named SQL1. You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort. Where should you store the metrics?
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL 1 to Azure. The solution must meet the following requirements: The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections. Administrative effort must be minimized. What should you use to host the databases?
You have an Azure SQL database named DB1. You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled. During a database audit, you discover that none of the fields contain more than 150 characters. You need to ensure that you can apply page compression to Table1. What should you do?
You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases. You need to update the column and index statistics for the databases. What should you use?
You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.You need to resolve the performance issues. What should you do?
You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL managed instance namedSQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The onpremises network connects to VNET1 by using an ExpressRoute connection. You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service. You need to configure VNET1 to support the migration. What should you do?
You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?
You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?
You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features. You plan to migrate to Azure SQL. Which service should you use?
You have a new Azure subscription. You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1. You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines. Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure. You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment. What should you include in the recommendation?
You have an Azure SQL database named DB1.You need to display the estimated execution plan of a query by using the query editor inthe Azure portal.What should you do first?
You create five Azure SQL Database instances on the same logical server.In each database, you create a user for an Azure Active Directory (Azure AD) user namedUser1.User1 attempts to connect to the logical server by using Azure Data Studio and receives alogin error.You need to ensure that when User1 connects to the logical server by using Azure DataStudio, User1 can see all the databases.What should you do?
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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, these questions will not appear in the review screen.You have SQL Server 2019 on an Azure virtual machine.You are troubleshooting performance issues for a query in a SQL Server instance.To gather more information, you query sys.dm_exec_requests and discover that the waittype is PAGELATCH_UP and the wait_resource is 2:3:905856.You need to improve system performance.Solution: You change the data file for the master database to autogrow by 10 percent.Does this meet the goal?
You are planning a solution that will use Azure SQL Database. Usage of the solution willpeak from October 1 to January 1 each year.During peak usage, the database will require the following:24 cores500 GB of storage124 GB of memoryMore than 50,000 IOPSDuring periods of off-peak usage, the service tier of Azure SQL Database will be set toStandard.Which service tier should you use during peak usage?
You have an Azure subscription that contains a server named Server1. Server1 hosts twoAzure SQL databases named DB1 and DB2.You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQLauthentication.You need to ensure that App1 can access DB2. The solution must meet the followingrequirements:App1 must be able to view only DB2. Administrative effort must be minimized.What should you create?
You have an Azure SQL database named db1 on a server named server1.You need to modify the MAXDOP settings for db1.What should you do?
You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.You need to implement alerts by using Azure Monitor. The solution must meet the followingrequirements:Minimize costs.Aggregate Intelligent Insights telemetry from each database.What should you do?
You have an Azure SQL Database managed instance.The instance starts experiencing performance issues.You need to identify which query is causing the issue and retrieve the execution plan forthe query. The solution must minimize administrative effort.What should you use?
You have an Azure SQL managed instance named SQL1 and two Azure web apps namedApp1 and App2.You need to limit the number of IOPs that App2 queries generate on SQL1.Which two actions should you perform on SQL1? Each correct answer presents part of thesolution.NOTE: Each correct selection is worth one point.
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 statedgoals. Some question sets might have more than one correct solution, while othersmight not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As aresult, these questions will not appear in the review screen.You have SQL Server 2019 on an Azure virtual machine.You are troubleshooting performance issues for a query in a SQL Server instance.To gather more information, you query sys.dm_exec_requests and discover that the waittype is PAGELATCH_UP and the wait_resource is 2:3:905856.You need to improve system performance.Solution: You shrink the transaction log file.Does this meet the goal?
You have an Azure SQL database named db1 on a server named server1.The Intelligent Insights diagnostics log identifies that several tables are missing indexes.You need to ensure that indexes are created for the tables.What should you do?