This page was exported from Latest Exam Prep [ http://certify.vceprep.com ] Export date:Thu Apr 3 23:39:49 2025 / +0000 GMT ___________________________________________________ Title: [Q134-Q149] Free Sample Questions to Practice DP-300 Certification Test Engine [Mar-2025] --------------------------------------------------- Free Sample Questions to Practice DP-300 Certification Test Engine [Mar-2025] 2025 Valid DP-300 Real Exam Questions, practice Microsoft Azure Q134. You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files How should you complete the template? To answer, select the appropriate options in the answer are a.NOTE: Each correct selection is worth one point. Q135. You have an Azure subscription.You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template.How should you complete the ARM template? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Explanation:Reference:https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure-powerQ136. You have an Azure SQL managed instance named SQLMI1 that has Resource Governor enabled and is used by two apps named App1 and App2.You need to configure SQLMI1 to limit the CPU and memory resources that can be allocated to App1.Which four 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. ExplanationText, table Description automatically generatedReference:https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/resource-governor?view=sql-server-https://docs.microsoft.com/en-us/sql/relational-databases/resource-governor/create-and-test-a-classifier-user-defiQ137. You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.What should you include in the migration plan? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Explanation:Azure Database Migration serviceBox 1: Premium 4-VCoreScenario: Migrate the SERVER1 databases to the Azure SQL Database platform.* Minimize downtime during the migration of the SERVER1 databases.Premimum 4-vCore is for large or business critical workloads. It supports online migrations, offline migrations, and faster migration speeds.Reference:https://azure.microsoft.com/pricing/details/database-migration/https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-azure-sql-onlineQ138. You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 is 30 TB and has a 1-GB daily rate of change.You back up the database by using a Microsoft SQL Server Agent job that runs Transact-SQL commands.You perform a weekly full backup on Sunday, daily differential backups at 01:00, and transaction log backups every five minutes.The database fails on Wednesday at 10:00.Which three backups should you restore in sequence? To answer, move the appropriate backups from the list of backups to the answer area and arrange them in the correct order. Explanation:Q139. You have a database named db1.The log for db1 contains the following entry.You need to ensure That db1 can process transactions. Q140. SIMULATIONYou need to provide a user named user2-12345678 with the ability to back up and restore databases and change the compute setting of the databases located on a server named sql12345678. User2-12345678 must be prevented from connecting to the databases and modifying database server settings. The solution must minimize administrative effort.To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Q141. You configure backups for an Azure SQL database 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. Explanation:Q142. SIMULATIONYou need to create a new database role named role1 that can read the contents of the SalesLT.SalesOrderDetail table only in db1.To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal. Q143. You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQL You need to use PowerShell to enable and configure automated patching for SQL The solution must include both SQL Server and Windows security updates.How should you complete the command? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point. Explanation:Q144. You have an Azure SQL database that contains a table named Customer. 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. Reference:https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-maskingQ145. Which audit log destination should you use to meet the monitoring requirements?  Azure Storage  Azure Event Hubs  Azure Log Analytics Scenario: Use a single dashboard to review security and audit data for all the PaaS databases.With dashboards can bring together operational data that is most important to IT across all your Azure resources, including telemetry from Azure Log Analytics.Note: Auditing for Azure SQL Database and Azure Synapse Analytics tracks database events and writes them to an audit log in your Azure storage account, Log Analytics workspace, or Event Hubs.Reference:https://docs.microsoft.com/en-us/azure/azure-monitor/visualize/tutorial-logs-dashboardsTopic 2, LitwareExisting EnvironmentNetwork EnvironmentThe manufacturing and research datacenters connect to the primary datacenter by using a VPN.The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet.Identity EnvironmentLitware has a hybrid Azure Active Directory (Azure AD) deployment that uses a domain named litwareinc.com. All Azure subscriptions are associated to the litwareinc.com Azure AD tenant.Database EnvironmentThe sales department has the following database workload:An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1-TB databases.A logical server named SalesSrv01A contains a geo-replicated Azure SQL database named SalesSQLDb1. SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool. SalesSQLDb1 uses database firewall rules and contained database users.An application named SalesSQLDb1App1 uses SalesSQLDb1.The manufacturing office contains two on-premises SQL Server 2016 servers named SERVER2 and SERVER3. The servers are nodes in the same Always On availability group. The availability group contains a database named ManufacturingSQLDb1 Database administrators have two Azure virtual machines in HubVnet named VM1 and VM2 that run Windows Server 2019 and are used to manage all the Azure databases.Licensing AgreementLitware is a Microsoft Volume Licensing customer that has License Mobility through Software Assurance.Current ProblemsSalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries.RequirementsPlanned ChangesLitware plans to implement the following changes:Implement 30 new databases in Azure, which will be used by time-sensitive manufacturing apps that have varying usage patterns. Each database will be approximately 20 GB.Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01. ResearchDB1 will contain Personally Identifiable Information (PII) data.Develop an app named ResearchApp1 that will be used by the research department to populate and access ResearchDB1.Migrate ManufacturingSQLDb1 to the Azure virtual machine platform.Migrate the SERVER1 databases to the Azure SQL Database platform.Technical RequirementsLitware identifies the following technical requirements:Maintenance tasks must be automated.The 30 new databases must scale automatically.The use of an on-premises infrastructure must be minimized.Azure Hybrid Use Benefits must be leveraged for Azure SQL Database deployments.All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality.Security and Compliance RequirementsLitware identifies the following security and compliance requirements:Store encryption keys in Azure Key Vault.Retain backups of the PII data for two months.Encrypt the PII data at rest, in transit, and in use.Use the principle of least privilege whenever possible.Authenticate database users by using Active Directory credentials.Protect Azure SQL Database instances by using database-level firewall rules.Ensure that all databases hosted in Azure are accessible from VM1 and VM2 without relying on public endpoints.Business RequirementsLitware identifies the following business requirements:Meet an SLA of 99.99% availability for all Azure deployments.Minimize downtime during the migration of the SERVER1 databases.Use the Azure Hybrid Use Benefits when migrating workloads to Azure.Once all requirements are met, minimize costs whenever possible.Q146. 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: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.Does this meet the goal?  Yes  No Correct solution: From the Azure portal, you delete Database1 from Server2, and then you create a new database on Server2 by using the backup of Database1 from Server1.Reference:https://docs.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backupsQ147. You have SQL Server on an Azure virtual machine that contains a database named Db1.You need to enable automatic tuning for Db1.How should you complete the statements? To answer, select the appropriate answer in the answer area.NOTE: Each correct selection is worth one point. Reference:https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enableQ148. You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2.You have an Azure subscriptionYou need to sync a subset of tables between the databases hosted on SQL1 and SQL2 by using SQL Data Sync.Which five 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. Explanation:Q149. 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. Explanation Loading … Genuine DP-300 Exam Dumps Free Demo Valid QA's: https://www.vceprep.com/DP-300-latest-vce-prep.html --------------------------------------------------- Images: https://certify.vceprep.com/wp-content/plugins/watu/loading.gif https://certify.vceprep.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2025-03-15 11:47:03 Post date GMT: 2025-03-15 11:47:03 Post modified date: 2025-03-15 11:47:03 Post modified date GMT: 2025-03-15 11:47:03