Study with 070-432 most valid questions & verified answers

Microsoft 070-432 Exam Overview:

Microsoft 070-432 Exam Syllabus Topics:

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

Question 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 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
B. Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.
C. Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.
D. Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured

Question 2

You plan 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 applications. Your solution must meet the following requirements:
- Minimize administrative effort.
- Prevent changes to the existing application environments.
What should you do?

A. Configure both applications to use SQL Server 2008.
B. Configure the new application to use a SQL Server 2008 named instance.
C. Configure the new application to use the SQL Server 2008 default instance.
D. Configure both instances to use SQL Server 2008.

Question 3

You administer a SQL Server 2008 instance.
A database developer named User1 needs to view the definitions of all database objects in
a database and read data from all user-defined tables, views, and table-valued functions.
You need to set the required permissions for User1.
Which Transact-SQL statements should you execute?

A. Option C
B. Option B
C. Option D
D. Option A

Question 4

You are a database administrator for your company. There are four automated testing
areas for finished items in the company's manufacturing floor. SQL Server 2008 is used to reserve testing results for every testing area. You should create a replication method to make sure that test results flow from the testing areas to the SQL Server quickly. The results of testing will be used on reporting. Which is the correct answer?

A. You should develop a separate transactional publication at each of the testing areas for the test results. Develop push subscriptions on each of the testing areas
B. You should develop a separate transactional publication at each of the testing areas for the test results. Develop a merge subscription on each distributor to the
C. At each of the testing areas for the test results, you should develop a separate snapshot publication. Develop a pull subscription on each distributor to the
D. At each of the testing areas for the test results, you should develop a separate snapshot publication. Develop a merge subscription on each distributor to the

Question 5

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table.
The table has the following definition: Currently, the table is not partitioned and contains no indexes.

You need to partition the table by year.
What should you do?

A. Create a new Filegroup.
Create a new database File.
Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
B. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG
ALL TO (SECONDARY);
C. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
D. Create a new filegroup.
Create a new database file.
Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
Use ALTER INDEX REORGANIZE statement.
E. Use the ALTER TABLEstatement to remove the COLLATEoption.
F. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
G. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= 'PartltionByYear'; @OptionValue= 'true';
H. Remove the clustered index from the table.
I. Create a new partition function.
Create a new partition scheme.
Add a clustered index to place the data onto the partition scheme.
J. Create a new table.
Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.

Solutions: