What action should you take?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2005 instance. You have multiple applications running fine on this server. You receive a new
third-party application that will not run in SQL Server 2005, as it requires SQL Server 2008.
You are required to make sure that all these applications should run without changing the
environment of the applications and with the minimal amount of cost.
What action should you take? (Each correct option is part of the answer. Choose TWO)
Which query will you use to achieve the objective?
You are the database administrator for a major shipping company. You manage all the SQL Server 2008 instances of the company.
For one of your instances, you have created jobs to perform regular administrative activities.
Some of these jobs in the database fail because the server went down due to a power failure.
You want to analyze these failed jobs. You also want to find out the tasks performed by these failed jobs.
Which query will you use to achieve the objective?
What steps should you take?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server 2008 instance.
TestKing.com has a SQL Agent job that contains a Windows PowerShell job step that uses the SQLCmd function to move data between servers.
The SQL Agent job is working fine for a couple of week. However, occasionally the job fails.
Your CEO tells you that all employees in TestKing must be notified by e-mail if this job is not successfully run.
What steps should you take? (Each correct option is part of the answer. Choose THREE.)
What steps should you take?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 database that makes use of the Analysis Services and Reporting Services.
However, installed components at Testking.com adhere to the Testking.com security policy.
You have received instruction to ensure that you adhere to the Testking.com security policy.
What steps should you take? (Each correct option is part of the answer. Choose THREE)
Which one of the following is NOT a valid workload source?
You’ve been asked to run the DTA to locate potential areas for performance improvement in
the Marketing database on SRV3. SRV3 runs SQL Server 2008 Standard Edition and
Windows Server 2008 Standard Edition. You must select the workload for DTA to analyze.
Which one of the following is NOT a valid workload source?
Select the best answer.
Which of the following functions should Smith use to accomplish the task?
Smith works as an Administrator for TestKing Inc. The company has a SQL Server 2008
computer that contains many securables. Every SQL Server securable has associated
permissions that can be granted to a principal. Smith wants to retrieve description of the
built-in permissions hierarchy of the server.
Which of the following functions should Smith use to accomplish the task?
What steps should you take?
You work as a database administrator at TestKing.com. TestKing.com is using SQL Server
2008 Enterprise Edition. TestKing.com contains a database that unfortunately has torn page
errors. You need to solve the problem of the torn page errors.
What steps should you take? (Each correct option is part of the answer. Choose TWO)
What action should you take?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server 2008 instance.
You have received instruction from management to migrate a web application from Microsoft SQL Server 2005 to Microsoft SQL Server 2008.
Be reminded that when a web application is moved then some features could stop working. You need to detect such instances.
What action should you take? (Each correct option is part of the answer. Choose TWO)
Which statement should you use to create the trigger?
You are the database administrator for your company and manage all the SQL Server 2008
databases of the company. You are responsible for performing the daily backup activities on
all the databases on the server. Database users regularly create new objects in one of the
databases. You want to be notified when new objects are created in the database.
You want to create a trigger that will fire whenever a new user-defined function is created in
the database. The trigger should insert statement-specific data, such as the name of the
database user who issued the CREATE FUNCTION statement, the time the statement was
issued, and the Transact-SQL statement that was issued, into a database table named
Log_structures. The Log_structures table was created by using the following statement:
CREATE TABLE Log_structures ( user1 nvarchar(100), createtime datetime, SQL_stat nvarchar(2000) );
Which statement should you use to create the trigger?
Which steps should you take?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2000 instance that contains a database named TK_DB1. One day you are required to install
a SQL Server 2008 instance. Management wants you to ensure that new third-party SQL
Server 2008 applications can run on both database instances with the minimum amount of
administrative effort while the old SQL Server 2000 applications should be working as before.
Which steps should you take? (Select two.)