What should you do to comply with the company service level agreements (SLAs) on querying response time?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2005 instance. In Domain.com there are 15 servers which are used by other administrator at the
company. However, they need to comply with the company service level agreements (SLAs) on
querying response time. Some of the administrators need information of the method on controlling
query response times on the servers.
What should you do?
What steps would meet this requirement?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 instance. Your CEO tells you that all user-defined stored procedures must have the
prefix tk_. You must prevent user-defined procedures from being created that do not meet
her requirement.
exhibit What steps would meet this requirement?
Implement a (Options above) on the (Place here Options) of user-defined stored procedures that is triggert on (Options below).
How can you setup a backup service while also making sure that minimum disk space is used?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 instance that contains a database named TK_DB. TK_DB have 200 GB information
where 3 GB of the information is changed daily. TK_DB has its recovery model set for
Simple. However, TestKing.com states that data loss of more than one hour for transactions
during business hours is a NO – NO.
How can you setup a backup service while also making sure that minimum disk space is
used? (Select two.)
What steps should you take to eliminate the replication of the data that is produced by the trigger?
You work as a database administrator at TestKing.com. TestKing.com has 12 separate
branch offices and a main office, each office is equipped with their own SQL Server 2008 computer.
A database table named TK-Sales is used to store point-of-sale transactions. Furthermore,
TK-Sales also hosts sales information from all 12 of the TestKing.com branch offices to
accommodate customer returns of products. Consequently the data should be refreshed
from the main office to all 12 branch offices every hour, on the hour. To this end you make
use of a trigger called Stats_Trigger to produce sales statistics based on customer sales and
buying patterns. Currently replication between the server in each of the 12 branch offices
and a middle server in the main office occurs in real time. You need to decide which type of
replication would be best in this scenario. You should also eliminate the replication of the
data that is produced by the trigger.
What steps should you take? (Each correct answer presents part of the solution. Choose TWO.)
How can this be achieved and still keep the performance and functionality of the web application?
You work as a database administrator at TestKing.com. TestKing.com is using a SQL Server
2008 instance that contains a database named TK_DB. TestKing.com contains a lot of
customer data which is processed by the Web application. You need to keep the customer
information safe since it is confidential. This information includes files of data, backups, and log files.
How can this be achieved and still keep the performance and functionality of the web application? (Select one or two.)
What should you do to ensure that the information changes are properly doubled ?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. The database contains a Products table.
You have developed a Merge Replication topology and a Publication which owns a 25-day
retention period; so that the Products table can be reproduce to the SQL Server instances at
remote locations. After a one month break the Domain.com user named Mia Hamm, noticed that
CK_Prod does not include her latest data. During the investigation you came upon the following
error message: "Replication: expired subscription dropped."
Mia Hamm needs the latest data in her database and you should ensure that the information
changes are properly doubled.
What should you do?
What should you do next to troubleshoot the log shipping of CK_Prod?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_Prod which are
logged shipping to a remote SQL Server 2008. However, after reboot of the primary SQL Server
instance, you notice that the log shipping has no functionality. You need to troubleshoot the log
shipping of CK_Prod.
What should you do next?
What should you do to make CK_ProdID the primary key?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB1. CK_DB1 contains a table named
CK_Prod that has a clustered primary key called CK_ProdID. Also, the CK_DB1 contains a single
XML column called CK_ProdXml which stores XML data. However, CK_ProdXml has an XML
index. You then create a new column called CK_ProdName to the Production table. You need to
make CK_ProdID the primary key.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
What should you do to make sure that the service disruption is minimized by setting the cluster to failover?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You then install an important cluster which allows constant availability on two
cluster-ready nodes. However, you have received instructions from management to make sure
that the service disruption is minimized by setting the cluster to failover.
What should you do?
What should you do to correct the following problem?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. The SQL Server 2008 instance contains a database named CK_DB that has a
stored procedure which is as follows:
1 CREATE PROCEDURE Products.TestProcedure
2 AS
3 IFOBJECT_ID(‘ Products. TableTest1’) IS NOT NULL
4 DROPTABLE Products.TableTest1;
5
6 CREATE TABLE Products. TableTest1 (
7 Idint PRIMARY KEY CLUSTERED,
8 Namevarchar(100);
9 );
10
11 …
12 GO
However, a Domain.com user has called the TestProcedure and received the following:
Msg 262, Level 14, State 1, Procedure TestProcedure, Line 15CREATE TABLE permission
permitted in database ‘ CK_DB ‘."
You need to correct the problem. What should you do?