Which statement will you issue to achieve the stated objectives?
You are the database administrator for your company. You maintain a production database named Products onyour company’s server. There are approximately 35 objects in the Products database. Your Products database has crashed due to a hardware failure. You were able to copy the .mdf and .ldf files ofthis database from the hard disks onto a different server. You have attached these files to a new server instanceand named the new database Products2 . You want to perform the following actions:
? Check the integrity of all objects in the newly created database.
? Minimize the time required to perform the integrity check.
? Repair errors without the risk of data loss.
? Suppress any informational messages displayed while performing the integrity check.
However, repairing errors without the risk of data loss is more important than reducing the time to perform theoperation or suppressing informational messages.
Which statement will you issue to achieve the stated objectives?
Which restrictions apply while creating a snapshot of the Sales1 database?
You are the database administrator for your company. You are administering two SQL Server databases, Sales1 and Sales2 , on your company’s server. According to changes in your company policy, you should create and maintain snapshots of the Sales1 databaseto provide a backup and recovery solution for the database.
Which restrictions apply while creating a snapshot of the Sales1 database?
Which two conditions must be met for this statement to execute successfully?
You are responsible for managing a SQL Server 2008 instance. You want to create a new database named Salesdb that supports FILESTREAM data.
You execute the following Transact-SQL statement to create the newdatabase:
CREATE DATABASE Salesdb ON
PRIMARY (NAME = Salesdb1,
FILENAME = ‘c:FileDataSalesdbData.mdf’),
FILEGROUP FStreamFileGroup1 CONTAINS FILESTREAM (NAME = Salesdb2,
FILENAME = ‘c:FileDataFstream’)
LOG ON (NAME = SalesdbLog,
FILENAME = ‘c:FileDataSalesdbLog.ldf’);
Which two conditions must be met for this statement to execute successfully? (Choose two.)
Which Transact-SQL statement should you run?
You are the database administrator of your company. The network contains a SQL Server 2008 computer thatstores several databases.
You want to identify all databases that have torn pages.
Which Transact-SQL statement should you run?
Which backup schedule should you implement?
You administer a SQL Server 2008 database named Products . The Products database contains four filegroups,named Products1 , Products2 , Products3 , and Products4.
The database is used for online transactionprocessing (OLTP) with a high volume of transactions. Data is evenly distributed across the four filegroups.
The customer demographic information is contained in the Products1 filegroup, and its nonclustered indexes arelocated in the Products3 filegroup.
No other tables or indexes span multiple filegroups. You are designing a backup schedule for the Products database. Transaction log backups are performed every30 minutes.
All other backups must occur in the evening. While implementing a backup plan, you discover thatonly half of the database can be backed up each night.
You want to provide the maximum protection to theenvironment. Which backup schedule should you implement?
Which Transact-SQL statement should you use?
You are responsible for managing an instance of SQL Server 2008.
The SQL server contains a database named Custdb that is configured with the full recovery model.
Your company has a partner company named nutex.com .
The partner company also maintains its customer data on an instance of SQL Server 2008. You import thecustomer data from the partner company into the Custdb database.
After the import, users report that Custdb is performing slowly.
You investigate and discover that the transactionlog for the Custdb database has increased in size dramatically, and currently occupies most of the free space onthe hard disk.
You want to reclaim as much free space as possible. Which Transact-SQL statement should you use?
Which statement should you execute to achieve the objective?
You are a database administrator for an insurance firm and manage the SQL Server 2008 databases in thecompany. The company stores all customer data in a database named
Customers that resides on the SQLserver named Sql_1 . You notice that there are several allocation and consistency errors in the Cust_details table in the Customers
database. You want to repair these errors as quickly as possible. Which statement should you execute to achieve the objective?
Which Transact-SQL statement should you execute?
You have been hired as the database administrator of your company. You are responsible for managing aninstance of SQL Server 2008 that contains a database named
Corpdb . There are several database snapshots created for the Corpdb database. You want to identify the names of thesparse files that are created for the Corpdb
database. Which Transact-SQL statement should you execute?
What will you do to accomplish the objective?
You are a database administrator for a toy manufacturing company named NetFx.
The company stores all itsproduct-related data in a database named Netfx_data that resides on a SQL Server 2008 server named Server1 .
A table named Product_details exists in the database and contains the details of all the products manufacturedby the company.
The table contains a brief description of each product in the Prod_desc column that is definedas varchar(300) .
Users query the Product_details table by using SQL statements like the following:
SELECT Prod_name, Prod_id, Prod_desc
FROM Product_details
WHERE CONTAINS (Prod_desc, ‘ " Blue Toy" ‘);
You must ensure optimal performance of this query. What will you do to accomplish the objective?
What should you do?
You are the SQL administrator for your company. You have several SQL Server 2008 computers deployedinternationally. You have configured a SQL Server 2008 computer named SQLReport with SQL Server ReportingServices (SSRS) enabled. You need to configure an archive strategy. SQLReport manages thousands of reports. You need to manage yourreports according to the following requirements:
? All archived reports must be saved to the D:Reports folder.
? For each archived report, one user must be able to access a fully interactive copy of the archived report.
? Delivery of archived reports must be automated.
What should you do? (Choose all that apply. Each correct answer represents part of the complete solution.)