Microsoft 70-467 Exam Questions

You need to configure Library1 to support the planned self-service reports.

What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.

You are designing an extract, transform, load (ETL) process for loading data from a SQL Azure database into a large fact table in a data warehouse each day with the prior day's sales data.

The ETL process for the fact table must meet the following requirements:

Load new data in the shortest possible time.

Remove data that is more than 36 months old.

Minimize record locking.

Minimize impact on the transaction log.

You need to design an ETL process that meets the requirements.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A SQL Server Analysis Services (SSAS) cube contains a large measure group. The fact table supporting the measure group is loaded with new data throughout the day.

You have the following requirements:

Ensure that the cube displays current data as quickly as possible.

Maximize availability of the cube.

Maximize query performance for all aggregation levels.

You need to choose a partitioning strategy that meets the requirements.

Which partitioning strategy should you choose? (More than one answer choice may achieve the goal. Select the BEST answer.)

You are designing a partitioning strategy for a large fact table in a Manufacturing data warehouse.

Tens of millions of new inventory fact records are loaded into the data warehouse weekly, outside of business hours. Most queries against the database are generated by reports and by cube processing. Data is frequently queried at the day level and occasionally at the month level.

An existing cube dimension that has 30 attribute hierarchies is performing very poorly. You have the following requirements:

Implement drill-down browsing.

Reduce the number of attribute hierarchies but ensure that the information contained within them is available to users on demand.

Optimize performance.

You need to redesign the cube dimension to meet the requirements.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)