Want to know Actualtests 70-470 Exam practice test features? Want to lear more about Microsoft Recertification for MCSE: Business Intelligence certification experience? Study Certified Microsoft 70-470 answers to Renew 70-470 questions at Actualtests. Gat a success with an absolute guarantee to pass Microsoft 70-470 (Recertification for MCSE: Business Intelligence) test on your first attempt.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Microsoft 70-470 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-470 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/70-470-exam-dumps.html
Q81. - (Topic 2)
You need to develop the executive reports.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
A. Remove default values from all parameters.
B. Implement dataset query parameters to filter data.
C. Set the data source to use Windows authentication.
D. Set the data source to use stored Windows credentials.
E. Provide default values for all parameters.
F. Implement dataset filters to filter data.
Answer: B,D,E
Explanation: * From scenario:
Deliver executive reports that are parameterized and rendered from report snapshots
BD: The data source that the shared dataset is based on has Prompt or Windows
Integrated credentials.
Q82. - (Topic 9)
You are creating a calculated measure in a sales cube by using a Multidimensional Expressions (MDX) calculation. The cube includes a date dimension. The date dimension has a hierarchy named Calendar that includes Calendar Year, Month, and Day attributes.
The calculated measure must calculate the year-to-date sales for the current slicer. The MDX calculation must work for as many hierarchy levels as possible.
You need to create a calculated measure for the cube that meets the requirements.
Which expression should you use in the calculation designer? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Q83. - (Topic 5)
You need to create the Package Activity report.
What should you do?
A. 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.
B. Use the SSIS log provider for SQL Server. Then create an SSRS report that uses the sysssislog 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.
Answer: D
Q84. - (Topic 3)
You need to configure data refresh for the Manufacturing Performance PowerPivot workbook.
What should you do? (Each correct answer presents part of the solution. Choose ail that apply.)
A. Configure the PowerPivot Data Refresh Timer Job to run every 60 minutes.
B. Restore the PowerPivot workbook to an SSAS instance in tabular mode.
C. Script a process command and configure a SQL Server Agent job to execute the command every 60 minutes.
D. Restore the PowerPivot workbook to an SSAS instance in PowerPivot for SharePoint mode.
Answer: A
Q85. - (Topic 9)
You are designing a SQL Server 2012 Integration Services (SSIS) deployment strategy. You currently have many SQL Server 2008 SSIS packages that require upgrading.
The production environment includes SSIS 2012 and SSIS 2008. The environment includes existing command shell scripts that invoke the dtutil command-line utility.
You need to design a deployment strategy that supports existing deployment strategies and requires the minimum amount of effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a project deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
B. Use a package deployment model. Use the Integration Services Deployment Wizard.
C. Use a package deployment model. Change the command shell scripts to reference the SQL Server 2012 path to dtutil.
D. Use a project deployment model. Use the Integration Services Deployment Wizard.
Answer: C
Q86. - (Topic 9)
A company runs SQL Server Database Engine and SQL Server Reporting Services (SSRS) in native mode. Reports are based on data that is cached in multiple shared datasets. Source data is archived each day at midnight for regulatory compliance purposes. The shared datasets may continue to cache data that should not be used in reports. Shared report schedules are often paused during nightly server maintenance windows.
Reports must not return archived data.
You need to create a fully automated solution to ensure that reports do not deliver archived data.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Write a script that calls the flushcache method to clear individual items from the SSRS cache. Create a SQL Server Agent job that runs rs.exe with the script as an input file, and schedule the job to run every day after the archive process completes.
B. Create a SQL Server Agent job that uses a Transact-SQL (T-SQL) step to truncate the dbo.ExecutionCache table in the ReportServerTempDB database. Schedule the job to run every day after the archive process completes.
C. Create a SQL Server Agent job that restarts the SQL Server Reporting Services service. Schedule the job to run every day after the archive process completes.
D. Create a shared schedule. Configure the datasets to expire on the shared schedule.
Answer: A
Q87. - (Topic 9)
You are defining a named set by using Multidimensional Expressions (MDX) in a sales cube.
The cube includes a Product dimension that contains a Category hierarchy and a Color attribute hierarchy.
You need to return only the blue products in the Category hierarchy.
Which set should you use? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q88. DRAG DROP - (Topic 9)
You are administering a SQL Server Analysts Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant write 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.)
Answer:
Q89. HOTSPOT - (Topic 9)
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular
database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.
Answer:
Q90. - (Topic 10)
You are developing a new SQL Server Reporting Services (SSRS) report in SQL Server
Data Tools (SSDT). This report has a table named Table1 and a textbox named Textbox1.
Table1 is initially visible but the user must be able to choose when to hide it.
You need to develop the report to meet the requirement.
What should you do? (More than one answer choice may achieve the goal. Select the
BEST answer.)
A. Add a parameter to the report so users can choose the display state of Table1.
B. For the properties of Table1, configure the Display can be toggled by this report item option to use Textbox1.
C. Configure Textbox1 to drill through to rerun the report to toggle the display of Table1.
D. For the properties of Table1, configure the Display can be toggled by this report item option to use Table1.
Answer: B
