70-470 discount pack(21 to 30) for IT specialist: Aug 2021 Edition
70-470 will be the assessment code for Microsoft test and this also certification has become the reputable exams in which accorded from your merchant "Microsoft". This Microsoft 70-470 certification goes because the entry level certification and also solitary test option for obtaining Microsoft certification. Microsoft 70-470 test will be the initially step for achieving the Microsoft. It can help your applicants to be able to confirm ale Microsoft technological innovation. Microsoft 70-470 is regarded one of the greatest setting up qualified certification it is possible to pursue. Therefore, having resolved to check for Microsoft youre on the suitable program a prosperous qualified development.
2021 Aug 70-470 exam fees
Q21. DRAG DROP - (Topic 9)
You install SQL Server Integration Services (SSIS) and develop an SSIS project to load a data warehouse. The project defines 10 parameters that have different values for the development, test and production environments. Some packages have additional parameters defined.
You plan to deploy the SSIS packages to one server. The server will also host the production data warehouse.
You need to deploy and configure the packages.
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 8)
You execute the SalesbyCategory report and receive the following error message: "Members, tuples, or sets must use the same hierarchies in the function."
You need to ensure that the query executes successfully.
Which two actions should you perform? Each correct answer presents part of the solution.
A. Move the Product clause from line 08 to line 10.
B. Move the Date and Product clauses on line 11 to axis 0.
C. Move the Date clause from line 10 to line 08.
D. Move the Measures clause on line 02 to axis 1.
Answer: C
Q23. - (Topic 9)
You are creating a product dimension table and a SQL Server Integration Services (SSIS) package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.
A. Add a Slowly Changing Dimension transformation to the package.
B. Enable Change Data Capture for the table.
C. Create an inferred member column in the table.
D. From the Slowly Changing Dimension Wizard, set the name column to Type 3.
E. Create an end date column in the table.
F. Create a start date column in the table.
Answer: A,E,F
Topic 10, Mix Questions Set B
Q24. - (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
Q25. DRAG DROP - (Topic 3)
You need to extend the schema design to store the product dimension data.
Which design should you use?
To answer, drag the appropriate table or tables to the correct location or locations in the answer area. (Fill from left to right. Answer choices may be used once, more than once, or not all.)
Answer:
Most up-to-date 70-470 training:
Q26. - (Topic 9)
You are designing a subscription strategy for a SQL Server Reporting Services (SSRS) report.
You have an application that populates a table with user-specific subscription schedules and report formats.
You need to ensure that users can receive reports by email according to their preferences. Email messages will be sent via an internal mail server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a standard SSRS subscription for each record in the table.
B. Create a data-driven SSRS subscription for each record in the schedule table.
C. Create a standard SSRS subscription for each subscription schedule.
D. Create one data-driven SSRS subscription. Schedule the subscription to frequently retrieve user preferences.
Answer: D
Explanation:
Ref: http://technet.microsoft.com/en-us/library/ms187066(v=sql.105).aspx
Q27. - (Topic 5)
You need to restrict access to data in the tables in the data warehouse.
What should you do?
A. Configure column-level permissions.
B. Configure database roles.
C. Create views and grant permissions to the views.
D. Configure application roles.
Answer: C
Q28. - (Topic 10)
You are developing a SQL Server PowerPivot workbook that sources data from a SQL Azure database. The PowerPivot model includes a single table named FactSales that consists of four columns named Year, Country, Product, and Revenue. The model includes the following two measures.
. Sales:=SUM(FactSales[Revenue;)
. Sales %:=;Sales] / CALCULATE([Sales], ALL(FactSales))
In Microsoft Excel 2010 you create the following PivotTable report.
Users report that the Sales % measure computes an incorrect ratio. The measure should meet a requirement to compute a ratio over all visible sales values defined by the query filters. The Grand Total value for the Sales % measure should equal 100%.
You need to fix the Sales % measure to meet the requirement.
Which Data Analysis Expressions (DAX) expression should you use?
A. = [Sales] / CALCULATE([Sales])
B. = [sales] / [Sales](ALLSELECTED(FactSales))
C. = [sales] / CALCULATE([Sales], VALUES(FactSales[Year]), VALUES(FactSales[Country]))
D. = [sales] / [Sales](ALLEXCEPT(FactSales, FactSales[Year]))
Answer: B
Q29. DRAG DROP - (Topic 10)
You are developing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database and a SQL Server Analysis Services (SSAS) cube. The cube contains a date dimension and other dimensions. The report design includes two report parameters named StartDate and FinishDate as shown in the following diagram.
The Data Type property of the parameters is set to Date/Time.
You need to create the dataset based on the SSAS cube. You also need to ensure that the dataset is filtered by the existing report parameters.
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. - (Topic 10)
... .
You work in the Business Intelligence (BI) department of a multinational company.
The company has requested a new corporate BI solution that meets the following requirements:
The solution must use SQL Server Analysis Services (SSAS).
The model must incrementally add 10 million fact rows per month.
The model must be translated to English, French, or Spanish based on users'
locale.
The model must be able to contain the most recent 36 months of data.
You need to select the appropriate model type and partitioning strategy to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a multidimensional model with one partition for all of the data.
B. Create a multidimensional model with one partition for each month.
C. Create a tabular model with one partition for all of the data.
D. Create a tabular model with one partition for each month.
Answer: C
see more http://www.2passeasy.com/exam/70-470/