Online Access Free 070-432 Practice Test

You are mastering the company database. During the development, you find that Transact-SQL query below is running slowly:SELECT VideoTitle, UpcNum, RetailPrice, Release Date FROM Srvideo.VideoTitle WITH (INDEX(0)) WHERE ReleaseDate BETWEEN '20050401' AND '20050510' A clustered index exists on the VideoTitle column.
There is a nonclustered index on the ReleaseDate column which contains the UpcNum and RetailPrice columns. The result of the avg_fragmentation_in_percent is 30 percent, when you search the sys.dm_db_index_physical_stats dynamic management function (DMF) or the VideoTitle table,In order to find this method to solve this problem, which is the correct answer?

• A.You should alter the query hint to force the optimizer to force a unclustered index seek.
• B.You should reproduce the whole indexes on the VideoTitle table.
• C.You should Re-create the index on only the ReleaseDate column.
• D.You should delete the query hint from the query.

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.Primary filegroup backup
• C.Database snapshots
• D.Differential backup

You maintain a SQL Server 2008 instance that contains a database named Finance. A small percentage of data in the database is modified daily.
You need to create a read-only copy of the database for reporting purposes at the beginning of each day by ensuring that minimal disk space is used.
Which strategy should you use?

• A.Use schema-bound views in a read-only database that resides on the same instance.
• B.Use database backup and restore.
• C.Use database snapshots.
• D.Use database backup and restore along with compression.

You are managing a SQL Server 2008 instance which includes a database called Products for Home.com. You should not modify the database frequently everyday. You should make sure that you develop a read-only copy of the database for reporting purposes at the beginning of every day .Which is the correct answer?

• A.You should utilize schema-bound views and XML schema
• B.You should utilize store procedure
• C.You should utilize Transactions Log.
• D.You should utilize database snapshots.

You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?

• A.Run the following statement: EXEC sp_configure 'show advanced options', 1 RECONFIGURE GO EXEC sp_configure 'clr enabled', 1 RECONFIGURE GO
• B.Open Microsoft SQL Server Management Studio and connect to the server.
  Right-click the server and select Facets.
  Choose the Server Configuration facet.
  Configure the AweEnabled property to True.
• C.open Microsoft SQL Server Management Studio and connect to the server.
  Right-click the server and select Properties.
  Browse to the Advanced tab.
  Configure the Filestream Access Level option to Full access enabled.
• D.Open Microsoft SQL Server Management Studio and connect to the server.
  Right-click the server and select Properties.
  Browse to the Advanced tab.
  Configure the CLRIntegration property to True.