Free Microsoft 70-467 Exam Dumps Questions & Answers

You need to recommend a cube architecture for CUBE1. The solution must meet the performance requirements for CUBE1.
Which two partitions should you recommend creating? Each correct answer presents part of the solution.

• A.Partitions based on the values of the customerID column in the fact table
• B.Partitions based on the values of the productID column in the dimension table
• C.Partitions based on the values of the productID column in the fact table
• D.Partitions based on the values of the customerID column in the dimension table

You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report.
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Create a data-driven subscription for each record in the schedule table.
• B.Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences.
• C.Create a standard subscription for each record in the table.
• D.Create a standard subscription for each subscription schedule.

You are configuring the partition storage settings for a SQL Server Analysis Services (SSAS) cube.
The partition storage must meet the following requirements:
* Optimize the storage of source data and aggregations in the cube.
* Use proactive caching.
* Drop cached data that is more than 30 minutes old.
* Update the cache when data changes, with a silence interval of 10 seconds.
You need to select the partition storage setting.
Which setting should you select?
To answer, select the appropriate setting in the answer area.

Correct Answer:

Explanation

http://msdn.microsoft.com/en-us/library/ms175646.aspx
Low Latency MOLAP
Detail data and aggregations are stored in multidimensional format. The server listens for notifications of changes to the data and switches to real-time ROLAP while MOLAP objects are reprocessed in a cache. A silence interval of at least 10 seconds is required before updating the cache. There is an override interval of 10 minutes if the silence interval is not attained. Processing occurs automatically as data changes with a target latency of 30 minutes after the first change.
This setting would typically be used for a data source with frequent updates when query performance is somewhat more important than always providing the most current data. This setting automatically processes MOLAP objects whenever required after the latency interval. Performance is slower while the MOLAP objects are being reprocessed.

You need to design the dimCustomers table.
Which design approach should you use?

• A.Reference dimension
• B.Junk dimension
• C.Conformed dimension
• D.Type 1 slowly changing dimension
• E.Type 2 slowly changing dimension

You need to configure security for the SSRS instance on SSRS01 to connect to SSAS and minimize downtime.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Restart the IIS service.
• B.Register a service principal name for the Analysis Services service.
• C.Register a service principal name for the Report Server service.
• D.Configure SSRS01 to use the Negotiate authentication type.
• E.Configure SSRS01 to use the Custom authentication type.