What should you do?
You are the SQL administrator for your company. Two SQL Server 2008 computers named SQL_prod and SQL_test are used by your company.
Due to recent security policies established by your company, you need to ensure that a user cannot establishmore than two sessions with SQL_prod.
Users can establish as many sessions as necessary with SQL_test . What should you do?
Which Transact-SQL should you execute?
You are responsible for managing an instance of SQL Server 2008 that is installed on a server that has fourprocessors. The instance contains a database named
FinanceDB . The FinanceDB database is accessed by several users using different types of Transact-SQL queries. You wantto ensure that the SQL server creates and runs a parallel plan for a query if the estimated elapsed time forrunning a serial plan for the query is greater than one second. Which Transact-SQL should you execute?
What should you do to define the alerts for the databases in this scenario?
You are the database administrator for your company. You maintain a database named Sql_ny on a SQL Server2008 instance named Sql1.
This server is located at the head office in New York. You have created 30 differentalerts on this database server.
Your company has recently opened two new branch offices in London and Paris.
The databases, named Sql_lon and Sql_par, in the London and Paris branch offices reside on SQL Server 2008 instances named Sql2 and Sql3, respectively.
The data in these databases is similar to the data stored in the Sql_ny database.
You are now required to define alerts on the Sql_lon and Sql_par databases and on the Sql_ny database.
What should you do to define the alerts for the databases in this scenario?
Which Transact-SQL should you run?
You are the database administrator for your company. The company’s network consists of a single ActiveDirectory domain named nutex.com.
You are configuring the SQL Server Agent operator information for a user named Paul.
You want to ensure thatPaul receives notifications by pager Monday through Friday from 9:00 A.M. to 6:00 P.M.
Which Transact-SQL should you run?
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 2008instances of the company.
For one of your instances, you have created jobs to perform regular administrativeactivities.
Some of these jobs in the database fail because the server went down due to a power failure.
You want toanalyze 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?
Which evaluation mode will prevent you from creating such a policy?
You manage an instance of SQL Server 2008. You are creating a Policy-Based Management policy to enforce anaming convention for databases. You want to ensure that the policy is enabled immediately after it is created. Which evaluation mode will prevent you from creating such a policy?
Which statement will fulfill all the requirements in this scenario?
You are a database administrator for your company. You are required to perform a full backup of the Sales database.
When performing the backup, you must fulfill the following requirements:
? The backup should be written to the disk backup device named ‘ C:sales1a.bak ‘.
? The size of each block for the backup should be 64 KB.
? The backup should expire on the 11th day.
? The new backup sets should be appended to existing backup sets on the backup media.
? The newly created backup should be named FULL BACKUP OF SALES .
Which statement will fulfill all the requirements in this scenario?
What should you do?
You are your company’s SQL administrator. Your company has several SQL Server 2008 computers that youmanage.
One of the SQL Server 2008 computers named SQL5 is configured with dozens of jobs.
While performing routine maintenance, you decide that a job named ProdDBBackup is no longer needed. Youdisable the job’s schedule.
The next day, you discover that several important maintenance jobs did not run.
You need to ensure that these jobs run as scheduled, but that the ProdDBBackup job does not run.
What should you do?
Which evaluation mode should you configure for the policy?
You are the SQL administrator of your company. The network contains an instance of SQL Server 2008.
You arein the process of creating a Policy-Based Management policy on the SQL server to ensure that SQL logins arecreated using a certain naming convention.
You want to ensure that the policy is automated and not violated. Which evaluation mode should you configure for the policy?
Which backup strategy should you implement?
You are the database administrator for your company. You maintain a database named Hr1 on a SQL Server2008 instance named Sql1.
The database size is approximately 45 GB and uses the Full Recovery model. The Hr1 database consists of a primary filegroup and four secondary filegroups.
Each filegroup contains three datafiles that are located on different disks. The Hr1 database is an online transaction processing database.
You perform a full backup of the database everytwo days. The Transaction_details table in the database contains all the transaction details and is updatedfrequently.
You are required to frequently back up the data in the table to prevent loss of transaction details in theevent of a failure. Which backup strategy should you implement?