70-470 Exam
Finding Down to date 70-470 torrent
Want to know Pass4sure 70-470 Exam practice test features? Want to lear more about Microsoft Recertification for MCSE: Business Intelligence certification experience? Study Accurate Microsoft 70-470 answers to Improve 70-470 questions at Pass4sure. Gat a success with an absolute guarantee to pass Microsoft 70-470 (Recertification for MCSE: Business Intelligence) test on your first attempt.
Q81. - (Topic 10)
You are modifying a SQL Server Analysis Services (SSAS) cube.
Users of the cube report that the precision for the SalesAmount measure is four digits.
You need to ensure that the SalesAmount measure stores values to two digits of precision.
What should you do?
A. Add a named query in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new query.
B. Use the MeasureExpression measure property to change the precision of SalesAmount to two digits.
C. Add a named calculation in the data source view that casts the data source column to two digits of precision. Bind the SalesAmount measure to the new column.
D. Use the FormatString measure property to format SalesAmount as Currency.
E. Use the FormatString measure property to format SalesAmount as #,##0.00;-#,##0.00.
Answer: C
Q82. - (Topic 1)
You need to identify the reports that produce the errors that Marc is receiving.
What should you do?
A. Write a query by using the Subscriptions table in the report server database.
B. Use the Windows Event Viewer to search the Application log for errors.
C. Write a query by using the ExecutionLog3 view in the report server database.
D. Search the ReportServerService_<timestamp>.log file for errors.
Answer: C
Q83. DRAG DROP - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to add a calculated column to a table in the model.
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:
Q84. - (Topic 5)
You need to implement the aggregation designs for the cube.
What should you do?
A. Use the CREATE CACHE statement.
B. Use the Aggregation Design Wizard.
C. Create relational indexes on the source tables.
D. Use the Usage-Based Optimization Wizard.
Answer: B
Q85. - (Topic 9)
You are designing an extract, transform, load (ETL) process for loading data from a SQL
....
Azure database into a large fact table in a data warehouse each day with the prior day's sales data.
The ETL process for the fact table must meet the following requirements:
Load new data in the shortest possible time.
Remove data that is more than 36 months old.
Minimize record locking.
Minimize impact on the transaction log.
You need to design an ETL process that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Partition the fact table by date. Insert new data directly into the fact table and delete old data directly from the fact table.
B. Partition the fact table by customer. Use partition switching both to remove old data and to load new data into each partition.
C. Partition the fact table by date. Use partition switching and staging tables both to remove old data and to load new data.
D. Partition the fact table by date. Use partition switching and a staging table to remove old data. Insert new data directly into the fact table.
Answer: C
Q86. - (Topic 9)
The IT department is currently upgrading all SQL Server Integration Services (SSIS) packages to SSIS 2012.
The final version of a complex SSIS 2005 package has been overwritten. Four prior versions of the package exist. Each of the prior versions contains a different part of the final solution. You have backups of all associated project files.
You need to create an updated package as quickly and accurately as possible.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use an XML editing tool to merge the compatible changes of the package versions by comparing the package refID fields. Upgrade the merged version.
B. Upgrade the four package versions. Use an XML editing tool to merge the compatible changes of the package versions by comparing the package refID fields.
C. Use the DataSet.Merge method to merge the compatible changes of the package versions by using the Lineage IDs. Upgrade the merged version.
D. Upgrade the four package versions. Use SSIS Designer to visually compare the package versions, determine the compatible changes, and copy the compatible tasks into a single package.
Answer: B
166. DRAG DROP - (Topic 9)
You are designing a business intelligence (BI) solution for a hotel booking system. Each hotel booking may have more than one guest.
The BI solution contains a fact table named Booking, a factless fact table named Booking_Guest and a dimension named Guest.
Booking contains an entry for each booking. Booking_Guest contains an entry for each guest in each booking. Guest contains an entry for each guest.
You need to define the many-to-many relationship in SQL Server Analysis Services (SSAS) for the hotel booking system.
Which four 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:
Q87. - (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:
. Ensure that the deployment model supports changing the content of connection strings by using parameters at execution time. . Ensure that the deployment model automatically starts from calls to the
catalog.start_execution stored procedure in the SSISDB database.
. Maximize performance at execution time.
. Minimize development effort.
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 package deployment model. Use a SQL Server package configuration with a common filter. Change the contents of the SSIS Configurations table at runtime.
B. Use a project 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.
C. Use a package deployment model. Save each SSIS package to a file share that can be accessed from all environments.
D. Use a project deployment model. Modify connection manager properties to use project parameters. Ensure that the SSISDB database is created.
Answer: D
Q88. HOTSPOT - (Topic 9)
You have an OLAP cube named Cube1. Cube1 has two partitions named partition1 and partition2.
You need to configure the storage mode for each cube partition.
The solution must meet the following requirements:
. Users must be able to retrieve aggregate data from partition1 as quickly as
possible.
. The processing time for partition1 and partition2 must be minimized.
. The least possible amount of storage must be used for partition2.
What should you do? To answer, select the appropriate storage mode for each partition in the answer area.
Answer:
Q89. - (Topic 3)
You need to grant appropriate permissions to the SSISOwners SQL Server login. What should you do?
A. Map the login to the SSISDB database. Assign the user to the ssis_admin role.
B. Map the login to the msdb database. Assign the user to the db_owner role.
C. Map the login to the msdb database. Assign the user to the db_ssisadmin role.
D. Map the login to the SSISDB database. Assign the user to the db_ssisadmin role.
E. Map the login to the SSISDB database. Assign the user to the db_owner role.
F. Map the login to the msdb database. Assign the user to the ssis_admin role.
Answer: D
Q90. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube. The cube contains several dimensions, a local measure group, and a linked measure group. Both measure groups use MOLAP partitions.
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis.
What should you do before the partition can be write-enabled?
A. Implement the cube as a local cube.
B. Implement the linked measure group as a local measure group.
C. Ensure that the measure group measures only use semiadditive aggregation functions.
D. Ensure that the measure group measures only use nonadditive aggregation functions
Answer: B