What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server 2008 instance.
Domain.com contains two SQL Server 2008 computers named CERTKILLER-DB1 and CERTKILLER-DB2.
Both of these computers contain a copy of a database named CK_DB.
You are using transactional replication between CERTKILLER-DB1 and CERTKILLER-DB2 for CK_DB.
The backups of the databases are as follows:
* Full backup is performed nightly.
* Transaction log backups are performed hourly.
Furthermore, replication latency is less than two minutes.
One morning CK_DB becomes corrupt on CERTKILLER-DB1 and its state was rendered irreparable.
Fortunately, the database on CERTKILLER-DB2 was not affected.
You need to return CK_DB on CERTKILLER-DB1 and
ensure that minimal amount of data loss impact on the users of these servers.
What should you do?
which is processed by the Web application. You need to keep the customer information safe since it is confiden
You work as a database administrator at Domain.com.
Domain.com is using a SQL Server 2008 instance that contains a database named CK_DB.
Domain.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.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instructions from management to encrypt the database of
Domain.com. However, you have just installed the new license and need to use it for encryption.
What should you do?
which owns an estimated execution cost less than 2.What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. You have received instruction from management to set the instance to utilize one
thread for searches which owns an estimated execution cost less than 2.
What should you do?
What should you do?
You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance. Domain.com contains a SQL Agent job that contains a Windows PowerShell job
step that uses the SQLCmd function to move data between servers. You need to ensure that an
operator named TestTeam is notified through an e-mail message if the job is lost while being
moved between servers.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
What should you do to automate these tasks to occur at the scheduled time on all weekdays?
You are a database administrator for your company. You are managing the production database Prod1 thatresides on the SQL Server 2008 instance named Sql1.
You perform the following tasks on Prod1 as a part of your daily activities:
? Perform a differential database backup at 8:00 P.M.
? Rebuild indexes on database tables at 9:00 A.M.
? Perform a backup of the transaction log in the database at 12:00 P.M.
? Update the database statistics at 8:00 A.M.
You want to automate these tasks to occur at the scheduled time on all weekdays. exhibit What should you do? (Choose two. Each correct answer represents part of the solution.)
What should you do?
You work as a database administrator at Domain.com. Domain.com have 12 retail stores, each
store is equipped with their own SQL Server 2008 computer.
A database table named CK-Sales is used to store point-of-sale transactions. Furthermore,
CK-Sales also hosts sales information from all 12 of the Domain.com stores to accommodate
customer returns of products. Consequently the data should be refreshed from the main office to
all 12 retail stores every hour, on the hour. To this end you make use of a trigger called
trg_Coupon to produce sales coupons based on customer sales and buying patterns. Currently
replication between the server in each of the 12 retail stores and a middle server in the main office
occurs in real time. You should receive instruction to eliminate this replication.
What should you do? (Each correct answer presents part of the solution. Choose TWO.)
Which statement is true of the notification received by John for the Alert1 alert?
You are the database administrator for your company. You have been assigned the task of managing alerts andissuing notifications for events occurring in the database.
John is a new employee in the organization. You add an operator for John by using the following Transact-SQL batch:
EXECUTE dbo.sp_add_operator
@name = ‘John’,
@enabled = 1,
@email_address = ‘john@esoft.com’,
@weekday_pager_start_time = 070000,
@weekday_pager_end_time = 200000,
@pager_days = 10,
@pager_address = ‘568923@pager.esoft.com’; GO
You want John to be notified each time the alert named Alert1 is generated. To add the notification, you issue thefollowing Transact-SQL batch:
EXECUTE dbo.sp_add_notification
@alert_name = ‘Alert1’,
@operator_name = ‘John’,
@notification_method = 1; GO
exhibit Which statement is true of the notification received by John for the Alert1 alert?
What should you do?
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.
Domain.com also has a Windows group named CertKillerManagers that makes use of CK_Prod.
Some of the users in that group are members for the db_owner role.
However, one member in the CertKillerManagers group named Mia is not allowed to access the SQL Server instance.
You have received instructions from the CEO to make sure that the Mia does not access the instance.
You need to complete this task using the appropriate Transact-SQL statement.
What should you do?
How should you configure the @include_event_description_in parameter?
You are the SQL administrator for your company. You install a new instance of SQL Server 2008 on a servernamed SQL1 . SQL1 contains a database named SalesDB that is accessed by all users on the network. You are in the process of creating an alert using the sp_add_alert system stored procedure that will be triggered when the number of deadlocks for the SalesDB database exceeds two. You want to ensure that you receive anotification message through e-mail that includes the description of the error. How should you configure the @include_event_description_in parameter?