Online Access Free 70-470 Exam Questions

DRAG DROP
You are designing a dataset for a SQL Server Reporting Services (SSRS) report. The report includes the report items displayed in the following graphic.

The dataset is sourced from a commonly used stored procedure in an inventory data mart hosted in a SQL Azure database.
It returns the status for all products across all storage sites. The report must display data for the storage site that is selected by the Site report parameter. You cannot change the stored procedure code.
You need to filter the dataset to use only data specific to the selected site.
How should you configure the filter?
To answer, drag the appropriate expression or expressions to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)

Correct Answer:

You need to create the hierarchy in the AdhocReports project in time for the next production release cycle.
What should you do?

• A.Use the RELATED() function to consolidate the columns in the DimSalesTerritory table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
• B.Multi-select all of the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
• C.Use the RELATED() function to consolidate the columns in the DimEmployee table, multi-select the columns, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.
• D.Use the RELATEDTABLEQ function to consolidate the tables, multi-select the columns in the hierarchy, right-click the columns, and then click the Create Hierarchy command. Check in the changes before the next release cycle.

DRAG DROP
Your network contains a development environment, a staging environment, and a production environment.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the project load data from files in a shared network folder. The packages use indirect XML configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location specified in the package is NOT used.
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:

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) multidimensional project that is configured to source data from a SQL Azure database.
The largest partition in the cube takes an unacceptably long time to process. The partition must be available for querying as soon as possible after processing commences.
You need to ensure that the partition is available for querying as soon as possible, without using source data to satisfy the query.
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 need to ensure that the corporate logos appear in reports. What should you do?

• A.In SharePoint Central Administration, configure the Report Server service account.
• B.In Reporting Services Configuration Manager, configure the Report Server service account.
• C.In SharePoint Central Administration, configure the unattended execution account.
• D.In Reporting Services Configuration Manager, configure the unattended execution account.