How to pass Microsoft DP-300 exam with the help of dumps?

Question # 1

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.

A. an Azure Policy assignment
B. an Azure Automation account
C. an Azure Policy initiative
D. an Azure Automation runbook
E. an Azure Policy definition

Show Answer

Question # 2

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?

A. log shipping
B. auto-failover groups
C. active geo-replication
D. Microsoft SQL Server failover clusters

Show Answer

Question # 3

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.

A. Delete data from a database.
B. Remove a database from the pool.
C. Increase the maximum storage of the elastic pool.
D. Shrink individual databases.
E. Enable data compression.

Show Answer

Question # 4

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?

A. auto failover groups
B. Azure Site Recovery
C. availability groups
D. active geo - replication

Show Answer

Question # 5

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.

A. On Server2, grant the contoso\sqlproxy account the Impersonate a client afterauthentication user right.
B. On Server2, grant the contoso\sqlproxy account the Access this computer from thenetwork user right.
C. On Server2. create a proxy account.
D. On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1.
E. On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1.

Show Answer

Question # 6

You have an Azure subscription that contains the resources shown in the following table. You plan louse SQLDB11 as an elastic job database to run jobs on SQlDb11 andSOtDB22.What is the minimum number of database scoped credentials required tor the elastic jobs?

A. 1
B. 2
C. 3
D. 4

Show Answer

Question # 7

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.

A. Generate a shared access signature (SAS)
B. Enable infrastructure encryption.
C. Create an access policy.
D. Rotate the storage keys

Show Answer

Question # 8

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.

A. Create the private endpoint connection on SQLMI1.
B. Configure Azure SQL Analytics to use Workspace1.
C. Modify the Computer + storage settings for SQLMI1.
D. Modify the diagnostic settings for SQLMI1.

Show Answer

Question # 9

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?

A. Azure SQL Edge
B. Azure SQL Database
C. SQL Server on Azure Virtual Machines
D. Azure SQL Managed instance

Show Answer

Question # 10

You have an Azure SQL database named DB1 that contains a private certificate namedSales. The private key for Sales is encrypted with a password. You need to change thepassword for the private key. Which Transact-SQL statement should you run?

A. Option A
B. Option B
C. Option C
D. Option D

Show Answer

Question # 11

You have an Azure SQL database named DB1. DB1 has a table named Table1 thatcontains the following columns. You plan to enable Always Encrypted for Table1.Which two columns support encryption? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point

A. Column1
B. Column2
C. Column3
D. Column4
E. Column5

Show Answer

Question # 12

You have an Azure subscription that contains an Azure SQL database. The databasecontains a table named tablet.You execute the following Transact-SQL statements. You need to reduce the time it takes to perform analytic queries on the database.Which configuration should you enable?

A. ROW_ MODE_MEMORY GRANT_FEEDBACK
B. BATCH MODE_MEMORY GRAIJT_FEEDBACK
C. BATCH_MODE_ADAPTIVE_TOIMS
D. BATC H_MODE_ON_ROWSTOR E

Show Answer

Question # 13

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?

A. sysadmin
B. SQLAgentUserRole
C. SQLAgentReaderRole
D. SQLAgentOperatorRole

Show Answer

Question # 14

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.

A. General Purpose Standard
B. Business Critical Premium
C. Business Critical Memory Optimized Premium
D. General Purpose Premium
E. Business Critical Standard

Show Answer

Question # 15

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?

A. Azure Automation
B. an elastic job
C. a SQL Server Agent job
D. an Azure function

Show Answer

Question # 16

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?

A. log to table
B. email notifications
C. schedules
D. output files

Show Answer

Question # 17

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?

A. 2
B. 4
C. 8
D. 64

Show Answer

Question # 18

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?

A. db_owner
B. dbmanager
C. dbo
D. db_ddladmin

Show Answer

Question # 19

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?

A. Create a proximity group and an availability set. Deploy each virtual machine to theavailability set Add both virtual machines to the proximitygroup.
B. Create two proximity groups and a single availability set. Deploy both virtual machines tothe availability set. Add one virtual machine to each proximity group.
C. Create two proximity groups and two availability sets. Deploy each virtual machine to aunique availability set. Add one virtual machine to each proximity group.
D. Create a proximity group and two availability sets. Deploy each virtual machine to aunique availability set. Add both virtual machines to the proximity group.

Show Answer

Question # 20

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.

A. From the Azure Active Directory admin center, create a service principal.
B. From the Azure Active Directory admin center, create a user-assigned managed identityfor SQL1.
C. On SQL1. create a SQL user in the databases.
D. On SQL1, create a SQL login.
E. From the Azure Active Directory admin center, create an external identity.

Show Answer

Question # 21

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?

A. Premium SSD v2
B. Premium SSD
C. Ultra SSD
D. Standard SSD

Show Answer

Question # 22

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?

A. Create a proximity group and an availability set. Deploy each virtual machine to theavailability set Add both virtual machines to the proximity group.
B. Create two proximity groups and a single availability set. Deploy both virtual machines tothe availability set. Add one virtual machine to each proximity group.
C. Create two proximity groups and two availability sets. Deploy each virtual machine to aunique availability set. Add one virtual machine to each proximity group.
D. 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.

Show Answer

Question # 23

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?

A. peer-to-pec
B. merge
C. transactional
D. snapshot

Show Answer

Question # 24

You have an Azure subscription that contains the resources shown in the following table.  App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs. What should you do? 

A. Increase the number Of vCores allocated to db1. 
B. Disable auto-pause delay for dbl. 
C. Decrease the auto-pause delay for db1. 
D. Enable automatic tuning for db1. 

Show Answer

Question # 25

You have an Azure subscription that contains the resources shown in the following table. App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs What you do?

A. Increase the number of vCores allocated to db1. 
B. Decrease the auto-pause delay for db1. 
C. Disable auto-pause delay for db1. 
D. Enable automatic tuning for db1. 

Show Answer

Question # 26

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. 

A. From the properties of DB1. configure geo-replication. 
B. From the properties of Server1 add a failover group. 
C. Create a new Azure SQL Database server named Server2. 
D. From the properties of Server1 configure retention for DB1 
E. Create a new Azure SQL Database instance named DB2. 

Show Answer

Question # 27

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? 

A. SQL Server on Azure Virtual Machines
 B. Azure SQL Database 
C. an Azure SQL Database elastic pool 
D. Azure SQL Managed Instance

Show Answer

Question # 28

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? 

A. Hyperscale 
B. General Purpose
 C. Premium 
D. Business Critical 

Show Answer

Question # 29

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 

Show Answer

Question # 30

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? 

A. log shipping 
B. Always On availability groups 
C. Database Migration Assistant 
D. Backup and Restore 

Show Answer

Question # 31

You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do? 

A. Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property. 
B. Use Transact-SQL to enable the force_last_good_plan option. 
C. From the Azure portal, configure automatic tuning. 

Show Answer

Question # 32

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?

A. Azure Migrate 
B. Data Migration Assistant (DMA) 
C. Azure Data BOX 
D. Azure Database Migration Service 

Show Answer

Question # 33

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?

 A. a Log Analytics workspace 
B. Azure Event Hubs 
C. Azure SQL Database 
D. an Azure Blob storage container 

Show Answer

Question # 34

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?

A. a single Azure SQL database
 B. an Azure SQL Database elastic pool 
C. SQL Server on Azure Virtual Machines 
D. Azure SQL Managed Instance 

Show Answer

Question # 35

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?

A. Configure the columns as sparse. 
B. Change the column type to nvarchar (MAX). 
C. Change the column type to varchar (MAX). 
D. Change the column type to varchar (200). 

Show Answer

Question # 36

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?

A. an Azure Automation runbook 
B. a SQL Agent job 
C. Azure SQL Analytics 
D. automatic tuning in Azure SQL Database 

Show Answer

Question # 37

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?

A. Implement memory-optimized tables. 
B. Run the dbcc flushprocindB command. 
C. Replace the sequential index keys with nonsequential keys. 
D. Run the dbcc dbreindex command. 

Show Answer

Question # 38

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?

A. Configure service endpoints. 
B. Configure virtual network peering. 
C. Deploy an Azure firewall. 
D. Configure network security groups (NSGs). 

Show Answer

Question # 39

You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?

A. Use the Agent XPs option. 
B. Enable the SQL Server Agent. 
C. Run the sp_configure command. 
D. Run the sp set_agent properties command. 

Show Answer

Question # 40

You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?

A. Configure Transaction Log Shipping. 
B. Implement Always On availability groups. 
C. C. Configure transactional replication. 
D. Import a BACPAC. 

Show Answer

Question # 41

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?

A. Azure SQL Database 
B. SQL Server on an Azure Virtual Machine 
C. Azure SQL Managed Instance 
D. Azure Database for MySQL 

Show Answer

Question # 42

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

A. From the properties of DB1. configure geo-replication. 
B. From the properties of Server1 add a failover group. 
C. Create a new Azure SQL Database server named Server2. 
D. From the properties of Server1 configure retention for DB1 
E. Create a new Azure SQL Database instance named DB2. 

Show Answer

Question # 43

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?

A. Azure Backup 
B. Azure Information Protection 
C. Windows Server Failover Cluster 
D. Azure Site Recovery 

Show Answer

Question # 44

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?

A. Run the set showplan_all Transact-SQL statement. 
B. For DB1, set QUERY_CAPTURE_MODE of Query Store to All. 
C. Run the set forceplan Transact-SQL statement. 
D. Enable Query Store for DB1. 

Show Answer

Question # 45

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?

A. Create User1 in the master database. 
B. Assign User1 the db_datareader role for the master database. 
C. Assign User1 the db_datareader role for the databases that Userl creates. 
D. Grant select on sys.databases to public in the master database. 

Show Answer

Question # 46

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?

A. Yes
B. No 

Show Answer

Question # 47

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?

A. Business Critical 
B. Premium 
C. Hyperscale 

Show Answer

Question # 48

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?

A. a contained database user for App1 on DB2 
B. a login for App1 on Server1 
C. a contained database user from an external provider for App1 on DB2 
D. a contained database user from a Windows login for App1 on DB2 

Show Answer

Question # 49

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?

A. Connect to db1 and run the sp_configure command. 
B. Connect to the master database of server1 and run the sp_configure command. 
C. Configure the extended properties of db1. 
D. Modify the database scoped configuration of db1. 

Show Answer

Question # 50

You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains auser named user1@contoso.com and an Azure SQL managed instance named SQLMI1.You need to ensure that user1@contoso.com can create logins in SQLMI1 that map toAzure AD service principals.Which three actions should you perform in sequence? To answer, move the appropriateactions from the list of actions to the answer area and arrange them in the correct order.

Show Answer

Question # 51

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?

A. From the Diagnostic settings of each database, select Send to Log Analytics. 
B. From the Diagnostic settings of each database, select Stream to an event hub. 
C. From the Diagnostic settings of SQLMI1. select Send to Log Analytics. 
D. From the Diagnostic settings of SQLMI1. select Stream to an event hub. 

Show Answer

Question # 52

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?

A. the Azure portal 
B. Extended Events 
C. Query Store 
D. dynamic management views 

Show Answer

Question # 53

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.

A. Enable query optimizer fixes.
B. Enable Resource Governor. 
C. Enable parameter sniffing. 
D. Create a workload group. 
E. Configure In-memory OLTP. 
F. Run the Database Engine Tuning Advisor. 
G. Reduce the Max Degree of Parallelism value. 

Show Answer

Question # 54

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?

A. Yes 
B. No 

Show Answer

Question # 55

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?

A. RuntheDBCC SQLPERF command. 
B. Run the dbcc dbreindex command. 
C. Modify the automatic tuning settings for db1. 
D. Modify the Query Store settings for db1. 

Show Answer

Question # 56

You plan to deploy an app that includes an Azure SQL database and an Azure web app.The app has the following requirements:The web app must be hosted on an Azure virtual network.The Azure SQL database must be assigned a private IP address.The Azure SQL database must allow connections only from the virtual network.You need to recommend a solution that meets the requirements.What should you include in the recommendation?

A. Azure Private Link 
B. a network security group (NSG) 
C. a database-level firewall 
D. a server-level firewall 

Show Answer

Question # 57

You have an Azure subscription that uses a domain named contoso.com.You have two Azure VMs named DBServer1 and DBServer2. Each of them hosts a defaultSQL Server instance. DBServer1 is in the East US Azure region and contains a databasenamed DatabaseA. DBServer2 is in the West US Azure region.DBServer1 has a high volume of data changes and low latency requirements for datawrites.You need to configure a new availability group for DatabaseA. The secondary replica willreside on DBServer2.What should you do?

A. Configure the primary endpoint as TCP://DBServer1.contoso.com:445, configure thesecondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode toAsynchronous. 
B. Configure the primary endpoint as TCP://DBServer1.contoso.com:445, configure thesecondary endpoint as TCP://DBServer2.contoso.com:445, and set the availability mode toSynchronous. 
C. Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure thesecondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability modeto Asynchronous. 
D. Configure the primary endpoint as TCP://DBServer1.contoso.com:5022, configure thesecondary endpoint as TCP://DBServer2.contoso.com:5022, and set the availability modeto Synchronous. 

Show Answer

Question # 58

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 create additional tempdb files.Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question # 59

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 reduce the use of table variables and temporary tables.Does this meet the goal?

A. Yes 
B. No 

Show Answer

Question # 60

You have SQL Server on an Azure virtual machine.You need to add a 4-TB volume that meets the following requirements:Maximizes IOPsUses premium solid state drives (SSDs)What should you do?

A. Attach a stripe set that contains four 1-TB SSDs. 
B. Attach a RAID-5 array that contains five 1-TB SSDs. 
C. Attach a single 4-TB SSD. 

Show Answer

Question # 61

You have SQL Server on an Azure virtual machine.You need to add a 4-TB volume that meets the following requirements:Maximizes IOPsUses premium solid state drives (SSDs)What should you do?

A. Attach a stripe set that contains four 1-TB SSDs. 
B. Attach a RAID-5 array that contains five 1-TB SSDs. 
C. Attach a single 4-TB SSD. 

Show Answer

Question # 62

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 thedatabase.What should you use?

A. Azure SQL Analytics alerts based on metrics 
B. SQL Health Check alerts based on diagnostics logs 
C. SQL Health Check alerts based on metrics 
D. Azure SQL Analytics alerts based on diagnostics logs 

Show Answer

Question # 63

You have an Azure SQL managed instance.You need to gather the last execution of a query plan and its runtime statistics. The solutionmust minimize the impact on currently running queries.What should you do?

A. Generate an estimated execution plan. 
B. Generate an actual execution plan. 
C. Run sys.dm_exec_query_plan_scacs. 
D. Generate Live Query Statistics. 

Show Answer

Question # 64

You have an Azure SQL database named DB3.You need to provide a user named DevUser with the ability to view the properties of DB3from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click theExhibit tab.) Which Transact-SQL command should you run?

A. GRANT SHOWPLAN TO DevUser 
B. GRANT VIEW DEFINITION TO DevUser 
C. GRANT VIEW DATABASE STATE TO DevUser 
D. GRANT SELECT TO DevUser 

Show Answer

Question # 65

You need to design a data retention solution for the Twitter feed data records. The solutionmust meet the customer sentiment analytics requirements.Which Azure Storage functionality should you include in the solution?

A. time-based retention 
B. change feed 
C. lifecycle management 
D. soft delete 

Show Answer

Question # 66

You need to implement the surrogate key for the retail store table. The solution must meetthe sales transaction dataset requirements.What should you create?

A. a table that has a FOREIGN KEY constraint 
B. a table the has an IDENTITY property 
C. a user-defined SEQUENCE object 
D. a system-versioned temporal table 

Show Answer

Question # 67

You need to provide an implementation plan to configure data retention for ResearchDB1.The solution must meet the security and compliance requirements.What should you include in the plan?

A. Configure the Deleted databases settings for ResearchSrvOL 
B. Deploy and configure an Azure Backup server. 
C. Configure the Advanced Data Security settings for ResearchDBL 
D. Configure the Manage Backups settings for ResearchSrvOL 

Show Answer