70-470 Exam
How Does Pass4sure Microsoft 70-470 exam topics Work?
It is impossible to pass Microsoft 70-470 exam without any help in the short term. Come to Examcollection soon and find the most advanced, correct and guaranteed Microsoft 70-470 practice questions. You will get a surprising result by our Improved Recertification for MCSE: Business Intelligence practice guides.
2021 Dec 70-470 answers
Q61. - (Topic 5)
You need to slice data by the CouponUsed, OnSale, and Closeout columns.
What should you do?
A. Create one linked dimension for each column.
B. Create one degenerate dimension.
C. Create one role-playing dimension.
D. Create one junk dimension.
Answer: D
Q62. DRAG DROP - (Topic 7)
You need to develop the LoadFactSales package to write the error messages to the SSIS catalog log.
Which components should you use?
To answer, drag the appropriate components to the correct location or locations in the answer area. (Use only components that apply.)
Answer:
Q63. HOTSPOT - (Topic 9)
You are using a new installation of SQL Server Reporting Services (SSRS) to create three sales reports that consume data from a stored procedure. The stored procedure is defined in a Windows Azure SQL Database.
All reports must pass USA to the Country parameter of the stored procedure. Users cannot change the Country report parameter value.
You need to configure the report parameter properties.
How should you configure the report parameter properties? To answer, select the appropriate setting or settings in the answer area.
Answer:
Q64. - (Topic 10)
You install SQL Server Reporting Services (SSRS). You need to restore a copy of the symmetric key. Which command should you run?
A. rskeymgmt –d
B. rskeymgmt –a –f %temp%\rs.key –p Password1
C. rskeymgmt –e –f %temp%\rs. key –p Password1
D. rskeymgmt –i
Answer: B
Q65. - (Topic 9)
You are redesigning a SQL Server Analysis Services (SSAS) database that contains a cube named Sales. Before the initial deployment of the cube, partition design was optimized for processing time. The cube currently includes five partitions named FactSalesl through FactSales5. Each partition contains from 1 million to 2 million rows.
The FactSales5 partition contains the current year's information. The other partitions contain information from prior years; one year per partition. Currently, no aggregations are defined on the partitions.
You remove fact rows that are more than five years old from the fact table in the data source and configure query logs on the SSAS server.
Several queries and reports are running very slowly.
You need to optimize the partition structure and design aggregations to improve query performance and minimize administrative overhead.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use the Aggregation Design Wizard to create aggregations for the current partitions.
B. Combine all the partitions into a single partition. Use the Usage-Based Optimization Wizard to create aggregations.
C. Combine all the partitions into a single partition. Use the Aggregation Design Wizard to create aggregations.
D. Use the Usage-Based Optimization Wizard to create aggregations for the current partitions.
Answer: D
Up to date 70-470 practice question:
Q66. - (Topic 6)
You need to ensure that managers can successfully run reports.
What should you do?
A. Implement Kerberos delegation.
B. Configure the SSRS data sources to store Windows credentials.
C. Implement forms-based authentication.
D. Configure the CustomData property in the connection strings.
Answer: A
Q67. HOTSPOT - (Topic 9)
You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.
You need to relate the Category dimension to the Sales measure group.
Which relationship type should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.
Answer:
Q68. - (Topic 6)
You need to configure permissions for the Customers dimension.
What should you do? (Each correct answer presents a complete solution. Choose all that apply.)
A. In SQL Server Management Studio, configure the BusinessUsers role to disallow the reading of all definitions.
B. In SQL Server Data Tools, configure the BusinessUsers role to disallow the reading of the Customers dimension definition.
C. In SQL Server Management Studio, deny the member set for the Customers dimension data by using the Multidimensional Expressions (MDX) expression Filter([BusinessUsers]).
D. In SQL Server Management Studio, configure the BusinessUsers role to disallow the reading of the Customers dimension definition.
Answer: B,D
66. - (Topic 6)
You need to implement the date dimension in the Operations database.
What should you do?
A. Create three database dimensions. Add each database dimension as a cube dimension by setting the Referenced relationship type.
B. Create one database dimension. Add three cube dimensions based on the database dimension. Set the Regular relationship type for each cube dimension.
C. Create three database dimensions. Add each database dimension as a cube dimension by setting the Regular relationship type.
D. Create one database dimension. Add three cube dimensions based on the database dimension. Set the Referenced relationship type for each cube dimension.
Answer: B
Q69. - (Topic 2)
You need to modify the Sales cube to support the planning requirements.
Which SSA5 feature should you use?
A. At KPI
B. A translation
C. A writeback partition
D. A perspective
Answer: C
Q70. - (Topic 9)
You deploy a PowerPivot workbook to a PowerPivot Gallery in a Microsoft SharePoint site. Workbook data comes from two different sources: Source A and Source B.
The workbook contains five tables with a total of 20 million rows from Source A, and three small lookup tables from Source B. Data from Source A is updated throughout the day. Data from Source B is updated at 3:00 P.M.
You have the following requirements:
. Refresh the PowerPivot workbook with updated lookup data as soon as possible. . Minimize load on the source systems and the SharePoint environment during business hours. . Minimize user involvement in the data refresh process.
You enable automatic data refresh for the workbook.
You need to configure a data refresh schedule for the workbook that meets the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Set the default schedule to refresh outside of business hours. Do not manually refresh the workbook.
B. Set the default schedule to refresh outside of business hours. Manually refresh the workbook at 9:00 A.M. every day.
C. Set the default schedule to refresh at 9:00 A.M. every day. Create a separate schedule for Source A's connection to refresh outside of business hours.
D. Set the default schedule to refresh at 3:00 P.M. every day. Do not create individual source schedules.
E. Set the default schedule to refresh at 9:00 A.M. every day. Do not create individual source schedules.
Answer: C