×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify queries or stored procedures that are consuming server resources. You also need to view
the query plan that is being used by each of these queries or procedures.
Which Dynamic Management Views (DMVs) should you use to find details about specific queries? (Choose all
that apply.)
2.
You troubleshoot a SQL Server 2008 instance. You suspect that an application uses an inefficient locking strategy and causes concurrency problems. You need to identify the following: The sessions that wait for a resource The resource needed The sessions that block the resource Which dynamic management view should you use?
3.
You administer a SQL Server 2008 instance. The production server hosts databases for several mission-critical applications. You plan to use the Resource Governor to limit the effect of queries that are executed by Microsoft SQL Server Management Studio. You need to ensure that the following requirements are met: Queries initiated through SQL Management Studio do not exceed 20 percent of CPU utilization. Queries initiated by the mission-critical applications are allowed to consume 100 percent utilization when required. What should you do?
4.
You administer a SQL Server 2008 instance.
Users report that applications that run on the server perform poorly. You suspect that the performance issues are related to table scans.
You need to use an appropriate Windows System Monitor object to capture the appropriate information.
Which performance object should you use?
Users report that applications that run on the server perform poorly. You suspect that the performance issues are related to table scans.
You need to use an appropriate Windows System Monitor object to capture the appropriate information.
Which performance object should you use?
5.
You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?
6.
You maintain a SQL Server 2008 instance.
You create a new SQL Agent job that includes a Windows Powershell job step. The Powershell job step uses the SQLCmd utility to transfer data between servers.
You need to ensure that an operator named ResponseTeam is notified by e-mail message if the job fails.
What should you do?
You create a new SQL Agent job that includes a Windows Powershell job step. The Powershell job step uses the SQLCmd utility to transfer data between servers.
You need to ensure that an operator named ResponseTeam is notified by e-mail message if the job fails.
What should you do?
7.
You maintain multiple SQL Server 2008 instances.
You develop a failure recovery strategy.
You need to find out the edition and the build of SQL Server that is deployed in your environment.
What should you use to find the required information?
You develop a failure recovery strategy.
You need to find out the edition and the build of SQL Server that is deployed in your environment.
What should you use to find the required information?
8.
You maintain a SQL Server 2008 instance that contains a database named Finance.
You need to configure SQL Server to automatically send an e-mail message when any file in the Finance database increases.
Which technology should you include in your solution?
You need to configure SQL Server to automatically send an e-mail message when any file in the Finance database increases.
Which technology should you include in your solution?
9.
You administer multiple SQL Server 2008 instances.
You plan to install a SQL Server 2008 mission-critical cluster on two cluster-ready nodes. The mission-critical cluster requires constant availability.
You need to configure the SQL Server cluster to failover by ensuring that the service disruption is minimized.
What failover option should you use?
You plan to install a SQL Server 2008 mission-critical cluster on two cluster-ready nodes. The mission-critical cluster requires constant availability.
You need to configure the SQL Server cluster to failover by ensuring that the service disruption is minimized.
What failover option should you use?
10.
You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?
You need to configure mirroring between two servers in high-performance mode.
What should you do?