70-467 試験問題を無料オンラインアクセス

You need to implement a strategy for efficiently storing sales order data in the data warehouse.
What should you do?

• A.Create monthly partitions in the factOrders table.
• B.Create daily partitions in the factOrders table.
• C.Separate the factOrders table into multiple tables, one for each day that has orders, and use a local partitioned view.
• D.Separate the factOrders table into multiple tables, one for each month that has orders, and use a local partitioned view.

You are designing a strategy for an enterprise reporting solution that uses SQL Server Reporting Services (SSRS).
Many of the SSRS reports will use common utilities and functions, including the following:
* Report utility functions and business logic in code
* Standardized report formatting properties such as fonts and colors for report branding Formatting may change and new functions may be added as the reporting solution evolves.
You need to create a strategy for deploying the formatting and code across the entire enterprise reporting solution. You must also ensure that reports can be easily updated to reflect formatting and function changes.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Store the formatting properties and code in database objects. Use stored procedures to populate a default value for report parameters and map each parameter to a corresponding formatting property.
• B.Build a web service that retrieves formatting properties and runs code. Call the web service through a report dataset.
• C.Create a report as a template. Apply standardized formatting to the template. Store code in the Code section of the template.
• D.Create an assembly that contains formatting properties and code. Deploy the assembly on the Reporting Server and reference the assembly from each report.

You have an SSAS database that contains Sales Data. The database has a dimension named Customer.
The SSAS database will be accessed by sales representative.
You need to create a role and assign an MDX Expression to the Allowed member set property of the Customer dimension to allow sales representative to browse only members of the Customer dimension that are located in their sales regions.
Which MDX expression should you use?
A)

B)

C)

D)

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

You need to choose the appropriate key to use when designing a dimension table based on the Customer table.
What should you do?

• A.Use the CustomerName column as the key.
• B.Use the CustomerNumber column as the key.
• C.Use a natural key.
• D.Use a surrogate key.
• E.Concatenate the CustomerName and CustomerNumber columns and use the concatenated string as the key.

You are designing a self-service reporting solution based on SQL Server Analysis Services (SSAS) tabular data models. The reporting solution must allow users to perform the following tasks:
* Easily create reports.
* Create report queries by dragging and dropping fields.
* Create presentation-quality reports with minimal effort
You need to choose a reporting tool that meets the requirements.
Which reporting tool should you choose? More than one answer choice may achieve the goal. Select the BEST answer.

• A.Report Designer
• B.PerformancePoint Services
• C.Report Builder
• D.Power View