70-470 Exam
Top Microsoft 70-470 training tools Choices
Want to know Testking 70-470 Exam practice test features? Want to lear more about Microsoft Recertification for MCSE: Business Intelligence certification experience? Study Refined Microsoft 70-470 answers to Abreast of the times 70-470 questions at Testking. Gat a success with an absolute guarantee to pass Microsoft 70-470 (Recertification for MCSE: Business Intelligence) test on your first attempt.
Q161. - (Topic 10)
You are modifying a SQL Server Analysis Service (SSAS) cube. The cube consist of a single measure group that contains the following measures:
. Total Quantity On Hand
. Average Quantity On Hand
The measure group has a single partition that uses the MOLAP storage mode.
You need to modify the cube design to ensure that the Total Quantity On Hand measure is updated in real-time and that Average Quantity On Hand measure is updated hourly.
What should you do?
A. Create a new measure group for the Total Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
B. Create an XMLA script that will process the cube and then use SQL Server Agent to execute the script continuously.
C. Change the storage mode of the partition to use proactive caching with minimum latency.
D. Create a new measure group for the Average Quantity On Hand measure. Configure the storage mode for the new measure group's partition to ROLAP.
Answer: A
Q162. - (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
Q163. - (Topic 7)
You need to ensure that the Sales Per Capita calculated measure produces correct results.
What should you do?
A. Set the DataType property of the Population column of the FactPopulation data source view table to System.Int64.
B. Set the Source DataType property of the Population measure to Biglnt.
C. Set the data type of the Population column of the FactPopulation data warehouse table to BIGINT.
D. Set the DataType property of the Population measure to Biglnt.
Answer: B
Q164. - (Topic 10)
You are creating a new report in SQL Server Report Builder. You add a SQL Azure data
source. Then you add a dataset that has four fields named Year, Country, Category, and Sales.
You must design a matrix as shown in the following diagram.
The category rows (the first three rows as shown in the diagram) must present total sales amount by category. The country rows (the next six rows as shown in the diagram) must present total sales amount by country. The total row must present the total sales for each year.
You add a matrix to the report. You add a grouping of the Category field on the rows and a grouping of the Year field on the columns.
You need to add the countries on the rows of the matrix.
Which Row Group option should you select when you add the group?
A. Adjacent Below
B. Parent Group
C. Adjacent Above
D. Child Group
Answer: A
Q165. - (Topic 10)
You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?
A. rskeymgmt -d
B. rskeymgmt -i.
C. rskeymgmt -e -f %temp%\rs.key -p Password1
D. rskeymgmt -a -f %temp%\rs.key -p Password1
Answer: C
210. - (Topic 10)
...
A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.
A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RevenueData. Each RevenueData database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical. Reports must meet the following requirements:
A report parameter named ServerName must be defined in each report.
When running a report, users must be prompted to select a server instance.
The report data source must use the Microsoft SQL Server Analysis Services data
source type.
You need to create a data source to meet the requirements.
How should you define the expression that is assigned to the connection string property of the data source?
A. ="Server=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"
B. ="Data Source=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"
C. ="Server=" & Parameters!ServerName.Value
D. ="Data Source=@ServerName;Initial Catalog=RevenueData"
E. ="Server=@ServerName;Initial Catalog=RevenueData"
Answer: B
Q166. DRAG DROP - (Topic 9)
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source table. The fact table and source table are located in a SQL Azure database. The source table has a price field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
. The fact table must populate a column named TotalCost that computes the sum of the price and tax columns. . Before the sum is calculated, any records that have a price of zero must be discarded.
You need to create the SSIS package in SQL Server Data Tools.
In what sequence should you order four of the listed components for the data flow task? (To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.)
Answer:
Q167. - (Topic 9)
You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS project that includes several SSIS packages. Each SSIS package will define the same connection managers and variables.
You have the following requirements:
. The deployment model must support changing the content of connection strings by
using parameters at execution time.
. The deployment model must automatically log events to the SSISDB database.
. Maximize performance at execution time.
You need to design a solution that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use a project deployment model. Modify connection manager properties to use project parameters.
B. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
C. Use a package deployment model. Configure connections in an XML configuration file referenced by an environment variable that corresponds to the SQL Server environment of each SSIS package.
D. Use a project deployment model. Modify connection manager properties to use package parameters.
Answer: A
Explanation:
Ref: http://technet.microsoft.com/en-us/library/hh213290.aspx
Q168. - (Topic 5)
You need to choose the appropriate key to use when designing a dimension table based on the Customer table.
What should you do?
A. Use a surrogate key.
B. Use a natural key.
C. Use the CustomerNumber column as the key.
D. Concatenate the CustomerName and CustomerNumber columns and use the concatenated string as the key.
E. Use the CustomerName column as the key.
Answer: A
Q169. - (Topic 8)
You need to configure Library1 to support the planned self-service reports.
What is the best configuration you should add to Library1? More than one answer choice may achieve the goal. Select the BEST answer.
A. The Report Builder report content type
B. The PowerPivot Gallery Document content type
C. The Report Builder Model content type
D. The Report content type
Answer: A
Q170. DRAG DROP - (Topic 9)
A company has a data warehouse that is rapidly increasing in size.
You plan to improve query performance by partitioning a very large fact table.
You need to identify the columns that are good partitioning candidates and the range that
each partition should include.
Which component should you add to the package?
To answer, drag the appropriate component from the list of items to the answer area.
Answer: