×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You are a database administrator for Certkiller .com. You migrate several SQL Server 2000 Data
Transformation Services (DTS) packages to a 64-bit version of SQL Server 2005 Standard Edition. After
migrating the packages, you notice that they do not run.
You verify that the packages run on a 32-bit version of SQL Server 2005 Standard Edition. You need to ensure
that the packages run. You must minimize the amount of additional development time required. What should
you do?
2.
You work as DBA at Certkiller .com. You administer a SQL Server 2005 computer named CertkillerA. Certkiller
A has recently been upgraded from two to eight processors. The Certkiller A configuration is summarized in the
following table.
You need to optimize Certkiller A so that longer running queries can run parallel plans.
What should you do?
3.
You are a database administrator for Certkiller .com. The company's financial forecasting application uses a
SQL Server 2005 database that enables business users to run both ad hoc and predefined queries. You
suspect that some queries consume an excessive amount of server resources. You need to identify which
queries consume the most resources. You want to achieve this goal as quickly as possible. What should you
do?
4.
You are the database administrator of a SQL Server 2005 computer named Certkiller A.
The following query is run frequently.
All tables referenced in the query are read-intensive with very few inserts and updates.
You cannot change existing objects in the database. You can add new objects to the database. You need to
optimize the performance of the query. What should you do?
5.
You are a database administrator for Certkiller .com. Your company has 10 SQL Server 2005 computers in a
distributed environment. The SQL Server computers each subscribe to a transactional replication publication.
Company policy defines service level agreements (SLAs) for maximum replication latency. You need to verify
that the SLAs are being met. What should you do?
6.
You are a database administrator for Certkiller .com. The company uses a SQL Server 2005 computer that
runs Reporting Services. Reporting Services is used to produce hundreds of reports each day. You discover
that the ReportServerTempDB database is growing. You need to minimize the size of the
ReportServerTempDB database. What should you do?
7.
You are a database administrator for Certkiller .com. You run SQL Server Profiler by using the SP:Recompile
event class. You notice a large number of recompiles occurring.
You need to identify the possible cause of the large number of recompiles. What is the most likely cause of the
problem?
8.
You are a database administrator for Certkiller .com. You are responsible for 20 SQL Server 2005 computers.
These computers are monitored by other administrators who are required to ensure that query response times
meet company service level agreements (SLAs). You need to provide these administrators with a consistent
way of monitoring query response times on the servers. What should you do?
9.
You work as DBA at Certkiller .com. You administer a SQL Server 2005 computer named Certkiller B. Certkiller
B runs a single SQL Server instance. You manage Certkiller B from an administrative workstation named
DBA1. Certkiller B intermittently fails to respond to user queries. Currently, it is not responding to your
connection through SQL Server Management Studio. You need to correct the problem. What should you do?
10.
You work as DBA at Certkiller .com. You administer a SQL Server 2005 computer named CertkillerA. You
create a security template that disables unnecessary services. The template is appropriate only for CertkillerA.
You need to ensure that the security template is applied to CertkillerA. Your solution must ensure that the
template automatically overrides any manual configuration changes made by other administrators within an
hour. What should you do?