Online Access Free 70-470 Practice Test

DRAG DROP
You are making changes to a cube named Sales.
You must increase the value of the measure named Sales Amount by 10%. The increase must be applied only to the children of the member named East in the dimension named Customer.
You need to complete the Multidimensional Expressions (MDX) statement in the calculations section of the Sales cube.
Which statement fragments should you use? (To answer, drag the appropriate statement component to the correct location or locations in the answer area. Use only components that apply.)

Correct Answer:

--- --
You are designing a fact table in a SQL Server database.
The fact table must meet the following requirements:
Include a columnstore index.
Allow users to choose up to 10 dimension tables and up to five facts at one time.
Maximize performance of queries that aggregate measures by using any of the 10
dimensions.
Support billions of rows.
Use the most efficient design strategy.
You need to design the fact table to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns.
• B.Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns.
• C.Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the dimensional key columns.
• D.Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns.

HOTSPOT
A company maintains separate environments for development, test, and production. The company uses the project deployment model for SQL Server Integration Services (SSIS) deployments.
You create an SSIS project to perform a daily refresh of the data warehouse and data models. The project has five packages.
You need to configure the project to ensure that the development, test, and production teams can run each package without manually adding server-specific information.
Which program should you use?
To answer, select the appropriate program in the answer area.

Correct Answer:

You need to create the Package Activity report.
What should you do?

• A.Use the SSIS log provider for SQL Server. Then create an SSRS report that uses the sysssislog table.
• B.Create a log table and use SSIS event handlers to write to the log table. Then create an SSRS report that uses the log table.
• C.Create a log table and build a custom log provider to write to the log table. Then create an SSRS report that uses the log table.
• D.Create an SSRS report that uses thecatalog.executions and catalog.execution_data_statistics views.

You are deploying an update to a SQL Server Analysis Services (SSAS) cube to a production environment.
The production database has been configured with security roles.
You need to preserve the existing security roles in the production database. Database roles and their user accounts from the development environment must not be deployed to the production server.
Which deployment method should you use?

• A.Deploy the project from SQL Server Data Tools to the production server.
• B.Use the SQL Server Analysis Services Deployment Wizard.
• C.Backup and restore the database.
• D.Use the SQL Server Analysis Services Migration Wizard.