Online Access Free 070-470 Practice Test

You are managing a SQL Server Reporting Services (SSRS) instance in native mode. A role named Folder Access Controller is present on the server.
The Folder Access Controller role consists of only the Set security for individual items task. When role members open Report Manager, they cannot view folders.
You need to modify the Folder Access Controller role so that the role members can view folders.
Which task should you add to the Folder Access Controller role?

• A.View models
• B.Manage folders
• C.Manage data sources
• D.View reports

HOTSPOT
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:

DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determine whether any of them are running longer than usual.
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.)

Correct Answer:

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 time intelligence option in the Business Intelligence Wizard.
• B.Use the SQL Server Data Tools Dimension Wizard and generate a time dimension by using the Use an existing table option.
• C.Use the SQL Server Data Tools Dimension Wizard and generate a time table in the data source.
• D.Create a CSV file with time data and use the DMX IMPORT statement to import data from the CSV file.
• E.Add an existing SSAS database time dimension as a cube dimension.
• F.Use the SQL Server Data Tools Dimension Wizard and generate a time table on the server.
• G.Create a time dimension by using the Define dimension intelligence option in the Business Intelligence Wizard.
• H.Create a script by using a sample time dimension from a different multidimensional database. Then create a new dimension in an existing multidimensional database by executing the script.

You need to configure the UserRegions role.
Which Multidimensional Expressions (MDX) function should you use?

• A.USERNAME ( )
• B.LEAD ( )
• C.COUSIN ( )
• D.FIRSTSIBLING ( )
• E.ANCESTOR ( )