100% Microsoft 70-432 Guaranteed Success With Testing Engine

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

1. You administer a SQL Server 2008 instance. You use an internal application based on SQL Server 2008. The application uses Analysis Services and Reporting Services. Company security policy requires that the surface area for all the deployed components of SQL Server 2008 be configured.
You need to implement the security policy and devise a method to evaluate the security policy against other database servers.
What should you do?

A) Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.
B) Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.
C) Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured
D) Create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to rim the script against a server group that includes the database servers that need to be configured

2. You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements:
- Enable FILESTREAM for file I/O streaming access.
- Allow remote client computers to have streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
What should you do?

A) Modify the Volume Shadow Copy settings.
B) Configure the SQL Server Full Text service.
C) Modify the Background Intelligent Transfer Service settings.
D) Configure the SQL Server service.

3. You administer a SQL Server 2008 instance. The instance contains various SQL Server Agent jobs that use seven shared schedules to run each job on each day of the week. You need to ensure that a job named Job5 no longer runs on Thursdays. What should you do?

A) Disable the schedule for Thursday.
B) Add a new Job5 schedule for Thursday and disable it.
C) Remove the schedule for Thursday from Job5.
D) Delete the schedule for Thursday.

4. You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns
The most common queries are listed below Transact-SQL statements. --QUERY 1SELECT [Name], [ProductLine], [ListPrice], [Class], [Style] FROM [Production]. [Product]WHERE [ProductLine] = 'T' --QUERY 2SELECT * FROM [Production]. [Product] ORDER BY [Name]
When you are minimizing the space required for the indexes.
You should select the best indexes to maintain the most common searched to the Production. Product tableWhich is the correct answer?

A) You should develop a clustered index on the ProductLine, ListPrice, Class and Style columns.
B) You should develop a clustered index on the Name column.
C) You should develop a nonclustered index on the Name column.
D) You should develop a nonclustered index on the ProductLine, ListPrice columns.

5. Yon maintain a SQL Server 2008 instance that contains a database named Finance.
The backup strategy for the Finance database specifies the following requirements:
- Full database backup to a file named finance.bak is performed at 08:00 hours daily. - A transaction log backup to a file named finance_HHMM.trn is performed every 15 minutes starting at 08:15 horns.
The Finance database is being used in single-user mode.
At 08:40 hours, a user reports that some important data was accidentally deleted by a
query that was executed at 08:23 horns.
You need to restore the database to its original state.
Which Transact-SQL statement(s) should you use?

A) Option A
B) Option D
C) Option C
D) Option B

Solutions: