Which actions could you take to accomplish this?
You are the database administrator of your company. You create a two-node SQL Server 2008 failover clusterinstance and configure database mirroring for a database named
Products. The database mirroring sessions arealso configured to support automatic failover. You are relocating the two SQL servers. You want to disableautomatic failover.
Which actions could you take to accomplish this? (Choose two. Each correct answer presents a completesolution.)
Which conditions must be met to achieve the stated objectives?
You are the database administrator of your company. You want to configure high-availability for a SQL Server2008 database named Corpdb by using database mirroring.
You want to configure automatic failover databasemirroring sessions. You must also improve reliability of the automatic failover.
Which conditions must be met to achieve the stated objectives? (Choose three. Each correct answer representspart of the solution.)
What should you do?
You are the database administrator of Nutex Corporation. The company’s network consists of a single ActiveDirectory domain named nutex.com.
You are in the process of creating a failover cluster for SQL Server 2008. You install SQL Server 2008 on threecomputers named SQL1.nutex.com, SQL2.nutex.com, and
SQL3.nutex.com. You create a three-node failovercluster instance named SQLFC.nutex.com. You want to configure encryption for the failover cluster. What should you do?
Which statement should you execute to achieve this?
You are the database administrator for your company. You have set up database mirroring to increase theavailability of your database.
You have a primary SQL Server 2008 instance named Primary1 and a mirroringdatabase instance named Secondary1.
You want to configure the database servers for high availability. To do this, you have decided to add a witnessserver to your mirroring configuration.
You have a SQL Server instance named DbInstance1 that will beconfigured as the witness server. This instance may also act as a secondary server in some events.
You must create an endpoint named MirrorEndpoint on this instance. Which statement should you execute to achieve this?
What should you do?
You are the database administrator for your company. You are administering the Sql1 SQL server that containsthe Prod1 database.
The Prod1 database is configured to use the Full Recovery model and implements a backup strategy to provideminimum downtime if a failure occurs.
You want to implement database mirroring to maximize the performance ofthis database. The mirror database Prod2 is maintained on the Sql2 server.
The following conditions must be met:
? The database should be made available to the users even if the mirrored server becomes unavailable.
? Service should be forced on the mirrored server if the principal server fails.
What should you do?
Which system stored procedure should you use?
You are the database administrator of your company. You have configured merge replication on an instance of SQL Server 2008.
You configure the Publisher and Distributor for error reporting and monitoring purposes.
You create a publicationwith the default retention period. Users want to be able to subscribe to the publication for a longer period of time.
You want to modify the expiration period for the subscription to the publication.
Which system stored procedure should you use?
Which version of SQL Server 2008 should you use to achieve this objective?
You are the database administrator of your company. You want to configure an eight-node failover cluster for SQLServer 2008 in your network.
Which version of SQL Server 2008 should you use to achieve this objective?
Which actions should you perform to initialize the secondary database from the primary database?
You are the database administrator for your company. You are maintaining the SQL Server instance named Sql1 on the Sqlserver1 server. The Sql1 instance stores the Prod1 database. The Prod1 database is configured to use the full recovery model.
You are required to configure a secondary database for Prod1 to provide high availability of the database. You are required to initialize the secondary database from a full database backup of the Prod1 database and restore the logs from the online primary server to the secondary server. You do not want to bring the secondary database online immediately.
Which actions should you perform to initialize the secondary database from the primary database? (Choose two. Each correct answer represents part of the solution.)
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 2005 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?
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?