70-470 Exam
Far out 70-470 rapidshare Guide
Refined of 70-470 actual exam materials and item pool for Microsoft certification for examinee, Real Success Guaranteed with Updated 70-470 pdf dumps vce Materials. 100% PASS Recertification for MCSE: Business Intelligence exam Today!
Q91. DRAG DROP - (Topic 9)
You are configuring an Excel Services service application in a Microsoft SharePoint farm.
Users will deploy Excel workbooks to SharePoint libraries that allow interaction with PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.
You need to ensure that users can refresh the PivotTables from within Excel Services without a warning message appearing.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the answer area. (Use only terms that apply.)
Answer:
Q92. HOTSPOT - (Topic 9)
You are designing aggregations for a SQL Server Analysis Services (SSAS) cube.
You need to ensure that every aggregation includes the Category attribute.
Which option should you select? To answer, select the appropriate option button in the
answer area.
Answer:
Q93. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
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.)
Answer:
Q94. - (Topic 10)
You are administrating a SQL Server Analysis Services (SSAS) tabular database.
You need to create a new role that allows its members to query data and to refresh data in the model.
Which permission should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Read and Process
B. Explore and Manage
C. Browse And Manage
D. Administrator
Answer: A
Q95. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)
Answer:
Q96. - (Topic 9)
You are modifying a SQL Server Reporting Services (SSRS) report for a SQL Server Analysis Services (SSAS) cube. The report defines a report parameter of data type Date/Time with which users can filter the report by a single date. The parameter value cannot be directly used to filter the Multidimensional Expressions (MDX) query for the dataset.
You need to ensure that the report displays data filtered by the user-entered value. You must achieve this goal by using the least amount of development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Edit the dataset query parameter. Change the Value property of the report parameter to an expression that uses the same format as the date dimension member key value.
B. Edit the dataset query parameter. Change the Name property of the dataset query parameter so that it points to a name value for each date dimension member.
C. Edit the dataset query parameter. Create a subcube subquery that uses the StrToSet MDX function and accepts the report parameter value.
D. Change the dataset query to Transact-SQL (T-SQL). Use the OPENROWSET function to query the cube. Output the cube results to the T-SQL query and use a Convert function to change the report parameter value into the same format as the date dimension member.
Answer: A
Q97. - (Topic 10)
You are developing a SQL Server PowerPivot workbook that sources data from a SQL Azure database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product, and Revenue. The model includes the following two measures.
. Sales:=SUM(FactSales[Revenue;)
. Sales %:=;Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.
Users report that the Sales % measure computes an incorrect ratio. The measure should meet a requirement to compute a ratio over all visible sales values defined by the query filters. The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?
A. = [Sales] / CALCULATE([Sales])
B. = [sales] / [Sales](ALLSELECTED(FactSales))
C. = [sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country]))
D. = [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))
Answer: B
Q98. - (Topic 10)
...
A large manufacturing company has manufacturing plants in many states. Each state has a dedicated SQL Server instance that stores its manufacturing data. Each SQL Server instance is configured identically and all instances have identical database structures.
You are developing a daily report that summarizes information on manufacturing activity.
The report has the following requirements:
It must have a state name as one of the report parameters.
It must provide a daily summary of manufacturing activity of a selected state.
It must require minimal development and maintenance effort.
You need to develop the report to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a shared data source that defines an expression-based connection string based on the state parameter.
B. Build a centralized data repository, schedule a regular Extract, Transform, and Load (ETL) process on all manufacturing data, and then use the repository to generate the report.
C. Use a report-specific data source that defines an expression-based connection string based on the state parameter.
D. Build one report for each state and instruct users to execute reports as needed.
Answer: C
Q99. - (Topic 9)
You administer a SQL Server Reporting Services (SSRS) instance in native mode.
You need to assign a predefined role that meets the following requirements:
. Members of the role must be able to update shared data sources.
. Members of the role must not be able to consume reports or manage
subscriptions.
. The role must provide only the minimum permissions required.
Which role should you assign? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. The Content Manager role
B. The Read and Process role
C. The Publisher role
D. The Browser role
Answer: C
Q100. DRAG DROP - (Topic 9)
You administer a SQL Server Reporting Services (SSRS) infrastructure. Data alerts are provisioned.
You need to monitor the number of report data feed processing events during every automated execution.
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.)
Answer: