Study with 070-432 Actual Test Questions

You are mastering the company database called TesterDB; the database includes a database that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full backup.
In order to cut the net bandwidth utilization when maintenance every night.
Which is the correct answer?

• A. You should set the database to utilize the bulk-logged recovery model.
• B. You should disable log shipping after the nightly maintenance.
• C. You should add the time during transaction log backups.
• D. You should reproduce only those indexes that ask it every night.

You need to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance.
You need to ensure that both database instances are available for their respective certified third-party applications.
You need to achieve this goal by complying with the following constraints:
- Minimal database administrative effort.
- The existing application environments remain unchanged
What should you do?

• A. Install SQL Server 2008 as the default instance, and configure the new application to use the default instance.
• B. Upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
• C. Install SQL Server 2008 as a named instance, and configure the new application to use the new instance.
• D. Upgrade the SQL Server 2005 application to use SQL Server 2008.

Yon manage several SQL Server 2008 instances.
You plan to collect performance data periodically on all instances by using the data collector. All collected data must be stored in the same database hosted on a single instance.
You need to collect and load performance data in the management data warehouse every 6 hours.
Which data collection process should you implement?

• A. Create a cached data collection.
• B. Create an on-demand non-cached data collection.
• C. Create a scheduled non-cached data collection.
• D. Create two different SQL Agent jobs that are scheduled at the same time. One job creates a data collection and the other job uploads the data collection.

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

You administer a SQL Server 2008 instance that contains a database named Sales.
A SQL Server login named SalesAppLogin maps to a database user named SalesAppUser in the Sales database.
You need to ensure that the database user can perform only the following tasks:
- Execute all stored procedures that currently exist in the Sales database. - Execute all stored procedures that will be created in the Sales database.
What should you do?

• A. Grant the appropriate database-level permissions to SalesAppUser.
• B. Add SalesAppUser to the appropriate fixed database roles.
• C. Grant the appropriate server-level permissions to SalesAppLogin.
• D. Grant the appropriate object-level permissions to SalesAppUser.