GBBDDA

QUESTION 329 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?. Azure SQL Database Premium. Azure SQL Database serverless. Azure SQL Database managed instance General Purpose. Azure SQL Database Hyperscale.

QUESTION 328 Hotspot Question You have an Azure subscription that contains a storage account named databasebackups. You have an Azure SQL managed instance named DB1. You need to back up DB1 to databasebackups. How should you complete the commands? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. DatabaseBackups y COMPRESSION. KeyVault1 y DIFFERENTIAL. SHARED ACCESS SIGNATURE y COPY_ONLY. SHARED ACCESS SIGNATURE y DIFFERENTIAL.

QUESTION 327 Hotspot Question You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to use an Azure Automation runbook to initiate a SQL Server database backup on VM1. How should you complete the command? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Move-AzAutomationHybridRunbookWorker y RunOn. Start-AzAutomationRunBook y AutomationAccountName. Set-AzAutomationRunBook y Parameters. Start-AzAutomationRunBook y Parameters.

QUESTION 326 You have an Azure SQL managed instance named SQLMI1 that has the following settings: • vCores: 4 • Service tier: General Purpose • Hardware generation: Standard-series (Gen5) You discover that memory pressure on SQLMI1 is high. You need to reduce the memory pressure on SQLMI1. The solution must minimize costs. What should to do?. Enable the Query Store. Change vCores to 8. Change Hardware generation to Premium-series. Change Service tier to Business Critical.

QUESTION 325 Drag and Drop Question You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1. You need to enable Transparent Data Encryption (TDE) for DB1. 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. a master key en the master database. a certificate in the master database. a database encryption key in DB1.

QUESTION 324 You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database. You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance. Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. General Purpose Standard. Business Critical Memory Optimized Premium. General Purpose Premium. Business Critical Premium. Business Critical Standard.

QUESTION 323 You have an Azure subscription. You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements: • Custom performance configuration, such as IOPS, capacity, and throughout, must be supported. • Costs must be minimized. Which type of disk should you include in the solution?. Premium SSD v2. Premium SSD. Standard SSD. Ultra SSD.

QUESTION 322 Drag and Drop Question You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs Windows Server. SQLVM1 and Server1 are joined to an Active Directory Domain Services (AD DS) domain. Server1 hosts a file share named Share1. You need to ensure that a SOL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege. 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. Create a credential. Create a proxy. Assign the proxy to the job step.

QUESTION 321 You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL1 to use mixed mode authentication. Which procedure should you run?. sp_addremotelogin. xp_instance_regwrite. sp_change_users_login. xp_grant_login.

QUESTION 320 Hotspot Question You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQ1. You need to use PowerShell to enable and configure automated patching for SQ1. 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. Set-AzVMSqlServerExtension y Lightweight. Get-AzVMSQLServerExtension y Full. Set-AzVMSqlServerExtension y Full. Set-AzVMExtension y NoAgent.

QUESTION 319 You plan to deploy an Azure SQL managed instance. You need to restore database backups across regions. Which type of storage account should you use?. locally-redundant storage (LRS). zone-redundant storage (ZRS). geo-zone-redundant storage (GZRS). geo-redundant storage (GRS).

QUESTION 318 You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: • Returns the solution to an operational state within 15 minutes of a failure • Can perform disaster recovery testing in an isolated environment • Minimizes administrative effort What should you include in the solution?. active geo-replication. auto-failover groups. Azure Site Recovery. a failover cluster instance (FCI).

QUESTION 317 You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines. You plan to implement a disaster recovery solution. You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements: • Minimize administrative effort for the recovery drills. • Isolate the recovery environment from the production environment What should you use?. native Microsoft SQL Server backup. Azure Site Recovery. Recovery Services vaults. Azure Backup.

QUESTION 316 You are modifying an existing disaster recovery solution for an Azure SQL managed instance that contains a failover group named FG1. You need to ensure the maximum in-transit time for FG1 when an automatic failover o馽urs. What should you configure. an availability group. a secondary managed instance. a failover policy. a grace period.

QUESTION 315 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?. Azure SQL Database managed instance General Purpose. Azure SQL Database Hyperscale. Azure SQL Database Premium. Azure SQL Database managed instance Business Critical.

QUESTION 314 You have an Azure SQL database. You need to implement a disaster recovery solution that meets the following requirements: • Minimizes how long it takes to recover the database if a datacenter fails • Minimizes administrative effort What should you include in the solution?. Azure Site Recovery. active geo-replication. auto-failover groups. Azure Backup.

QUESTION 313 You have an Azure subscription. You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements: • Minimize how long it takes to fail over. • Maintain existing connections to the primary replica during a failover. What should you do?. Connect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure load balancer. Connect each virtual machine to a different subnet on a single virtual network. Connect each virtual machine to a single subnet on a single virtual network. Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

QUESTION 312 You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements: • Support real-time data replication to a different geographic region. • Use Azure as a disaster recovery target. • Minimize costs and administrative effort. What should you include in the recommendation?. database mirroring on an instance of SQL Server on Azure Virtual Machines. availability groups for SQL Server on Azure Virtual Machines. an Azure SQL Managed Instance link. transactional replication to an Azure SQL Managed Instance.

QUESTION 311 You have an Azure SQL database named SQL1. You need to implement a disaster recovery solution for SQL1. The solution must minimize the following: • The recovery point objective (RPO) • The recovery time objective (RTO) • Administrative effort What should you include in the solution?. Azure Site Recovery. active geo-replication. availability groups. auto-failover groups.

QUESTION 310 You deploy an instance of SQL Server on Azure Virtual Machines: named SQL1 that hosts multiple databases. You configure the full recovery model for all the databases. You perform a full backup of the master database on SQL1. You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup. Which type of backup should you perform?. log. full. differencial. tail-log.

QUESTION 310 You deploy an instance of SQL Server on Azure Virtual Machines: named SQL1 that hosts multiple databases. You configure the full recovery model for all the databases. You perform a full backup of the master database on SQL1. You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup. Which type of backup should you perform? User1 drops DB1. You need to perform a point-in-time restore of DB1 to SQLMI2. What should you use to perform the restore?. Azure CLI. Transact-SQL. the Azure portal. Azure PowerShell.

QUESTION 308 Drag and Drop Question 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. zoneRedundant SystemAssigned,.

QUESTION 307 You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1. You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements: • Provide an availability SLA. • Minimize costs. What should you create?. an Azure Standard Load Balancer. a virtual network name (VNN) resource. a Basic Azure Load Balancer. a distributed network name (DNN) resource.

QUESTION 306 You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available 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 writes What should you recommend?. Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group. Create a proximity group and an availability set. Deploy each virtual machine to the availability set. Add both virtual machines to the proximity group. Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group. Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.

QUESTION 305 You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover cluster instance (FCI) to VM1 and VM2 that will use Azure shared disks. The solution must maximize resiliency. Which quorum option should you use?. node majority with a cloud witness. node majority with no witness. node majority with a file share witness. node majority with a disk witness.

QUESTION 304 You have an Azure SOI database named SQLDb1 that contains the resources shown in the following table. Column1 contains JSON data. You need to compress Column1. The solution must minimize the amount of storage used. What should you use?. the COMPRESS() function. columnstore archive compression. row compression. columnstore compression.

QUESTION 303 Hotspot Question 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. point-time restore (PITR) backup y 65 backup copies. point-time restore (PITR) backup 64 backup copies. monthly long-term retention (LTR) backup y 65 backup copies. yearly long-term retention (LTR) backup y 64 backup copies.