Microsoft 070-432 real exam prep : TS:MS SQL Server 2008,Implementation and Maintenance

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.
You plan to use data compression to conserve disk space. You compress a table named VeryLarge that has a clustered index named Index1 and a non-clustered index named Index2. Both indexes are partitioned.
You execute the following Transact-SQL statement.
ALTER INDEX Index2 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
You need to ensure that all the indexes of the VeryLarge table are compressed by using row-level compression.
You need to accomplish this goal by using minimum resources.
Which Transact-SQL statement should you execute?

• A. ALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
• B. ALTER INDEX Index1 ON VeryLarge REORGANIZE WITH (LOB_ COMPACTION = ON);
• C. ALTER INDEX ALL ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
• D. ALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH (DATA_COMPRESSION = ROW);

You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives according to the following table:

You discover that the Windows application log is being filled with entries from a SQL Server Audit process named DatabaseAudit. The volume of these events is causing older events to be removed from the log.
You need to ensure that the following requirements are met:
- SQL Server Audit information is stored in the D:\AuditLogs folder.
- No data is currently lost in the Windows application log.
What should you do?

• A. Open the Windows Server Manager.
  Browse to the Diagnostics\Event Viewer\Windows Logs folder.
  Right-click Application Log, and then click Properties
  Enable the Clear Log option.
• B. Open the Windows Server Manager.
  Browse to the Diagnostics\Event Viewer\Windows Logs folder.
  Right-click Application Log, and then click Properties.
  Enable the Do not overwrite events (Clear logs manually) option,
• C. Create a folder named AuditLogs on drive D.
  Run the following Transact-SQL statement:
  ALTER DATABASE Dat3baseAudit
  ADD LOG FILE (NAME = DatabaseAuditLog, FILENAME =
  'D:\AuditLogs\DatabaseAuditLog.Idf)
• D. Create a folder named AuditLogs on drive D.
  Run the following Transact-SQL statement:
  ALTER SERVER AUDIT DatabaseAudit
  TO FILE (FILEPATH = 'D:\AuditLogs')

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database contains a table named OrderDetail. You plan to export all data from this table to a file.
You need to ensure that the following data export requirements are met: A Microsoft Office Open XML document format is used The data export process is saved for reuse.
What should you do?

• A. Run the bulk copy program utility along with an output file and no format file.
• B. Run the bulk copy program utility along with a format file and an output file.
• C. Run the SQL Import and Export Data Wizard and save the output to a file.
• D. Run the SQLCmd utility and save the output to a file.

You administer a SQL Server 2008 cluster in a high security environment.
You plan to configure and use encrypted connections for the clustered virtual SQL Server.
You need to install the certificate that will be used for encryption.
What should you do?

• A. Install the encryption certificate in the cluster quorum drive.
• B. Install the encryption certificate in the cluster group.
• C. Install the encryption certificate on each individual node.
• D. Install the encryption certificate in the SQL Server shared disk.

You administer a SQL Server 200S instance. The instance contains an On-Line Analytical
Processing (OLAP) database along with a dimension table named Customers. The data of the Customers table is updated every hour. The Customers table contains redundant data. You need to conserve the disk space used to store the Customers table. Which compression technology should you use?

• A. Page compression
• B. Row compression
• C. Windows NITS file system compression
• D. Backup compression