70-470 Exam
What Does 70-470 test question Mean?
Act now and download your Microsoft 70-470 test today! Do not waste time for the worthless Microsoft 70-470 tutorials. Download Renewal Microsoft Recertification for MCSE: Business Intelligence exam with real questions and answers and begin to learn Microsoft 70-470 with a classic professional.
Q51. - (Topic 2)
You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?
A. DirectQuery
B. In-Memory
C. MOLAP
D. Low-latency MOLAP
E. Scheduled MOLAP
F. High-latency MOLAP
Answer: D
Q52. - (Topic 2)
You need to modify the Sales Regions hierarchy to meet the reporting requirements.
Which S5A5 feature should you use?
A. Calculation
B. Translation
C. Action
D. Perspective
Answer: B
Q53. - (Topic 10)
You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a SQL Azure database in the report.
What should you do?
A. Create a SQL Azure dataset that uses the existing data source.
B. Create a SQL Azure data source and then add a dataset that uses the new data source.
C. Create a SQL Server data source and then add a dataset that uses the new data source.
D. Generate an Atom-compliant data feed for the report.
Answer: B
Q54. DRAG DROP - (Topic 7)
You are creating the Australian postal code query.
Which arguments should you use to complete the query?
To answer, drag the appropriate arguments to the correct location or locations in the
answer area. (Use only arguments that apply.)
Answer:
Q55. DRAG DROP - (Topic 9)
Several reports are based on the same SQL Server Analysis Services (SSAS) cube. Each report has several datasets defined with complex Multidimensional Expressions (MDX) queries. The company maintains separate development, test and production environments.
The reports are running slowly. You plan to analyze report performance. You have the following requirements:
. Monitor query statistics on the production server with as little server overhead as possible.
. Gather, replay, and analyze statistics on the test server with as little administrative
effort as possible.
. Identify the longest-running queries on both servers.
. Document statistics on disk reads on both servers.
You need to gather statistics and meet the requirements.
Which features should you use?
To answer, drag the appropriate feature or features to the correct location or locations in the answer area. (Use only features that apply.)
Answer:
Q56. - (Topic 10)
...
You are designing a SQL Server Reporting Services (SSRS) report to display vineyard names and their year-to-date (YTD) grape yield. Grape yield values are classified in three bands:
High Yield
Medium Yield
Low Yield
You add a table to the report. Then you define two columns based on the fields named VineyardName and YTDGrapeYield.
You need to set the color of the vineyard text to red, yellow, or blue, depending on the value of the YTD grape yield values.
What should you do?
A. Add an indicator to the table.
B. Use an expression for the Style property of the vineyard text box.
C. Use an expression for the Font property of the vineyard text box.
D. Use an expression for the TextDecoration property of the vineyard text box.
E. Use an expression for the Color property of the vineyard text box.
Answer: E
Q57. - (Topic 8)
You need to implement the SalesCommission model to support the planned reports and queries.
What should you do?
A. Create a date table that contains only one row for each date on which a sale is recorded.
B. Use the existing transaction date column in the sales table for date calculations.
C. Create a date table that contains a row for every date since data started being recorded.
D. Create a new calculated date column in the sales table for date calculations.
Answer: C
Q58. - (Topic 10)
You are troubleshooting query performance for a SQL Server Analysis Services (SSAS) cube.
A user reports that a Multidimensional Expressions (MDX) query is very slow.
You need to identify the MDX query statement in a trace by using SQL Server Profiler.
Which event class should you use?
A. Progress Report Begin
B. Query Begin
C. Execute MDX Script Begin
D. Calculate Non Empty Begin
E. Get Data From Aggregation
F. Query Subcube
Answer: B
Q59. - (Topic 9)
You have a data warehouse named DW1.
An OLAP cube named Cube1 uses DW1 as its data source. Cube1 uses the MOLAP
storage mode.
You create a SQL Server Integration Services (SSIS) package that updates DW1, and then processes Cube1. The package executes each day at 06:00.
You need to configure the storage settings of Cube1. The solution must ensure that aggregation processing is reduced as much as possible during cube querying.
What is the best storage setting you should you use for Cube1? More than one answer choice may achieve the goal. Select the BEST answer.
A. Medium-latency MOLAP
B. Scheduled MOLAP
C. Low-latency MOLAP
D. Automatic MOLAP
Answer: D
Q60. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used in the definition of a hierarchy. The City column exists in the Geography table that is related to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?
A. City:=RELATED(Geography[City])
B. =RELATEDTABLE(Geography)
C. =RELATED(Geography[City])
D. City:=Geography[City]
E. City:=RELATEDTABLE(Geography)
F. =Geography[City]
Answer: C