070-470 무료 덤프문제 온라인 액세스

You need to slice data by the CouponUsed, OnSale, and Closeout columns.
What should you do?

• A.Create one junk dimension.
• B.Create one role-playing dimension.
• C.Create one degenerate dimension.
• D.Create one linked dimension for each column.

DRAG DROP
You are administering a SQL Server Analysis Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant read access to the financial cube for all users in the group USA\PowerUsers.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

정답:

You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table.
You need to implement a time dimension.
What should you do?

• A.Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
• B.Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.
• C.Add an existing SSAS database time dimension as a cube dimension.
• D.Create a time dimension by using the Define time intelligence option in the Business Intelligence Wizard.

You are working with multiple tabular models deployed on a single SQL Server Analysis Services (SSAS) instance.
You need to ascertain the memory consumed by each object in the SSAS instance.
What should you do?

• A.Use the Usage Based Optimization wizard to design appropriate aggregations.
• B.Use the Performance Counter group named Processing.
• C.Use SQL Server Profiler to review session events for active sessions.
• D.Use the $System.discover_object_memory_usage dynamic management view.

You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.

You have the following requirements:
- Ensure that queries of the data model correctly display average student age by class and average class level by student. - Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the
BEST answer.)

• A.Create a tabular project and define measures.
• B.Create a multidimensional project and define measures and a many-to-many dimensional relationship.
• C.Create a tabular project and define calculated columns.
• D.Create a multidimensional project and define measures and a reference relationship.