Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:

1. Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not installed Microsoft Business Intelligence Development Studio (BIDS).
You should design a package, which has the following features:
The package should be transactional.
The package should be optimized for 10 tables.
The package should be stored safely in the msdb database of a server which is remote.
Which is correct?

A) You should create the package by using the Microsoft SQL Server Import and Export Wizard.
B) You should create the package by using DTS Designer.
C) On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, You should click the Create Package submenu.
D) You should create the package by using the Package Migration Wizard.

2. DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database installed along with the default settings.
You want to migrate a database from a SQL Server 2000 server that is being decommissioned. The application executes a number of Windows command-line calls from stored procedures in the database.
You need to configure SQL Server 2008 R2 to allow command-line calls from this database.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

3. You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance. The recovery model of the Finance database is set to Full.
You deploy a new process that modifies 10.000 records from the Accounts table at 19:00 hours daily.
You need to ensure that any modification to the data can be reverted without the database going offline.
Which strategy should you implement?

A) Transaction log backup
B) Differential backup
C) Database snapshots
D) Primary filegroup backup

4. You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?

A) Use a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.
B) Use the SQL Server 2008 Upgrade Advisor.
C) Use the SQL Server Profiler that captures the SQL:BatchCompleted and Exception event classes.
D) Use a SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes.

5. You are managing a SQL Server 2008 instance which includes some applications for
Home.com.
You set the SQL Server Agent service to implement through utilizing the SerTest\Test account.
You create a job named MailingTester that allows a file to be stored to a log server. The job could not run normally because it could not own proper access to the log server.
You decide to set the service of SQL Server Agent.
You should make sure that you could run the settings such that the SQL Server Agent service owns all access to the log server. Which is the correct answer?

A) You should utilize the type of Domain account
B) You should utilize the type of remote Service account
C) You should utilize the type of remote System account
D) You should utilize the type of Local Service account

Solutions: