70-470 Exam
70-470 pack（21 to 30） for IT learners: Apr 2021 Edition
Your success in Microsoft 70-470 is our sole target and we develop all our 70-470 braindumps in a way that facilitates the attainment of this target. Not only is our 70-470 study material the best you can find, it is also the most detailed and the most updated. 70-470 Practice Exams for Microsoft 70-470 are written to the highest standards of technical accuracy.
Q21. DRAG DROP - (Topic 9)
You are developing a SQL Server Integration Services (SSIS) package to add a large amount of data to a fact table named factOrders. The factOrders table is partitioned by week and has a clustered index.
You need to load three weeks' data into the factOrders table by using the most efficient method.
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:
Q22. - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) tabular project.
You need to grant the minimum permissions necessary to enable users to query data in a
data model.
Which role permission should you use?
A. Explorer
B. Process
C. Administrator
D. select
E. Browser
F. Read
Answer: F
Q23. - (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
Q24. - (Topic 5)
You need to implement security in the cube to limit the sites visible to each user.
What should you do?
A. Create an SSAS database role in the cube for each user and assign the sites each user can access to his or her database role.
B. Create an SSAS server role for each user and assign the sites each user can access to his or her server role.
C. Create an SSAS database role and define a Multidimensional Expressions (MDX) calculation to implement dynamic dimension security.
D. Create a view on the SalesTransactions table that uses the SecurityFilter and User table data to limit the sites for each user.
Answer: C
Q25. - (Topic 7)
You need to update the Execute SQL task in the OnVariableValueChanged event handler of all SSIS packages.
Which additional variable should be logged?
A. System::ExecutionInstanceGUID
B. System::ServerExecutionID
C. System::VariableID
D. System::SourceID
Answer: C
Q26. DRAG DROP - (Topic 3)
You need to configure the attribute relationship types for the Salesperson dimension.
Which configuration should you use?
To answer, drag the appropriate pair of attributes and attribute relationships from the list to the correct location or locations in the answer area. (Answer choices may be used once, more than once, or not all.)
Answer:
Q27. - (Topic 10)
You are conducting a design review of a multidimensional project.
In the Customer Geography dimension, all non-key attributes relate directly to the key attribute.
The underlying data of the Customer Geography dimension supports relationships between attributes.
You need to increase query and dimension processing performance.
What should you do?
A. For the dimension attributes of the Customer Geography dimension, define appropriate attribute relationships.
B. For the Customer Geography dimension, set the ProcessingPriority property to 1.
C. For the Customer Geography dimension, set the ProcessingMode property to LazyAggregations.
D. For the dimension attributes of the Customer Geography dimension, set the GroupingBehavior property to EncourageGrouping.
Answer: A
Q28. 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:
Q29. DRAG DROP - (Topic 9)
Your network contains a development environment, a staging environment, and a production environment.
You have a SQL Server Integration Services (SSIS) project. All of the packages in the project load data from files in a shared network folder. The packages use indirect XML configurations to set the location of the network folder.
The project is deployed to the three environments. Each environment has a different set of source files and a different network folder for the source files.
Currently, if an environment variable is missing, the package will use the network folder specified in the package, not the folder specified in the XML configuration file.
You need to ensure that each time a package is executed, the network folder location specified in the package is NOT used.
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:
Q30. DRAG DROP - (Topic 7)
You need to implement the requirements for the StageFactSales package.
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: