100% Microsoft 070-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 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 ALL ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
B) ALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH (DATA_COMPRESSION = ROW);
C) ALTER INDEX Index1 ON VeryLarge REORGANIZE WITH (LOB_ COMPACTION = ON);
D) ALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);

2. You manage a SQL Server 2008 instance. You plan to maintain a management data warehouse that collects performance data by using the data collector.
You need to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules.
What data collection process should you implement?

A) 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.
B) Create a scheduled non-cached data collection.
C) Create a cached data collection.
D) Create an on-demand non-cached data collection.

3. You maintain a SQL Server 2008 instance that contains a database named Finance.
Minimally logged operations are performed on the Finance database.
You need to verify that the database can be restored to a specific point in time.
What should you do?

A) Verify that the database uses the bulk-logged recovery model.
B) Verify that the database uses the full recovery model.
C) Verify that the database uses the checksum page verify option.
D) Verify that the database uses the simple recovery model.

4. 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 both instances to use SQL Server 2008.
C) Configure the new application to use the SQL Server 2008 default instance.
D) Configure the new application to use a SQL Server 2008 named instance.

5. You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a database table called Saling. The Saling table also includes sales information from other stores to enable customer returns to any of the 15 retail stores. You could refresh the data in the main office to every retail store every hour. You should use trigger called trg_Coupon to produce sales coupons based on customer sales and buying patterns. Through using the fewest number of steps, you should set replication between the server in every retail store and a middle server in the mainoffice. in real time. You should not have the Replication. Which is the correct answer?

A) Snapshot replication should be utilized. You should set the trg_Coupon trigger on the server in every store to utilize the NOT FOR REPLICATION option.
B) You should utilize merge replication. You should set the trg_Coupon trigger on the server in each retail store to use the NOT FOR REPLICATION option.
C) You should utilize transactions log between the server in each retail store and the central server in the main office.
D) You should build multiple merge publications, one at every store and one in the main office.

Solutions: