×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You have a Microsoft SQL Server instance that has a database named DB1. The database is used for reporting purposes. You plan to capture all queries for a
specific table and save the data as a text file.
You need to ensure that queries are captured and that a failure to capture a query will shut down the SQL Server instance.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
specific table and save the data as a text file.
You need to ensure that queries are captured and that a failure to capture a query will shut down the SQL Server instance.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
2.
You maintain three datacenters in different geographical regions. You have a four-node failover cluster that hosts a Microsoft SQL Server Failover Cluster Instance
(FCI) in Datacenter1.
You must extend FCI to add four nodes in Datacenter2.
You need to configure a node majority quorum mode for the cluster.
What are the two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
(FCI) in Datacenter1.
You must extend FCI to add four nodes in Datacenter2.
You need to configure a node majority quorum mode for the cluster.
What are the two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
3.
You have an application that queries a database.
Users report that the application is slower than expected.
You discover that several server process identifiers (SPIDs) have PAGELATCH_UP and PAGELATCH_EX waits. The resource descriptions of the SPIDs contains 2:1:1.
You need to resolve the issue.
What should you do?
Users report that the application is slower than expected.
You discover that several server process identifiers (SPIDs) have PAGELATCH_UP and PAGELATCH_EX waits. The resource descriptions of the SPIDs contains 2:1:1.
You need to resolve the issue.
What should you do?
4.
You manage a Microsoft SQL Server environment. You plan to configure Database Mail.
You need to ensure that all users can access a private Database Mail profile.
What should you do?
You need to ensure that all users can access a private Database Mail profile.
What should you do?
5.
You plan to integrate an on-premises Microsoft SQL Server environment with Microsoft Azure.
You need to create the authentication object so that you can connect to Azure.
Which Windows PowerShell command or commands should you run?
You need to create the authentication object so that you can connect to Azure.
Which Windows PowerShell command or commands should you run?