we provide Exact Microsoft 70-470 practice which are the best for clearing 70-470 test, and to get certified by Microsoft Recertification for MCSE: Business Intelligence. The 70-470 Questions & Answers covers all the knowledge points of the real 70-470 exam. Crack your Microsoft 70-470 Exam with latest dumps, guaranteed!
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Microsoft 70-470 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 70-470 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/70-470-exam-dumps.html
Q21. - (Topic 9)
You are developing the database schema for a SQL Server Analysis Services (SSAS) BI Semantic Model (BISM). The BISM will be based on the schema displayed in the following graphic.
You have the following requirements:
. Ensure that queries of the data model correctly display average student age by
class.
. Ensure that the solution supports role-based security and partitions.
. Minimize development effort.
You need to design the data model.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a multidimensional project and define measures and a many-to-many dimensional relationship. Create partitions in SQL Server Management Studio (SSMS).
B. Create a multidimensional project and define measures and a reference relationship. Create partitions in SQL Server Data Tools (SSDT).
C. Create a tabular project and define measures. Create partitions in SQL Server Data Tools (SSDT).
D. Create a tabular project and define calculated columns. Create partitions in SQL Server Management Studio (SSMS).
Answer: A
Q22. - (Topic 10)
You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the dimension's Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Add the ByAccount attribute to the account dimension.
B. Use SQL Server Data Tools to change the AggregateFunction property value of the Amount measure to ByAccount.
C. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing AggregateFunction property value of the Amount measure to ByAccount and then use the application.
D. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing AggregateFunction property value of the Amount measure to FirstNonEmpty and then use the application.
Answer: B
Q23. - (Topic 9)
You are modifying a star schema data mart that feeds order data from a SQL Azure database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table.
You have the following requirements:
. Allow users to slice data by all flags and indicators. . Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. . Use the most efficient design strategy for cube processing and queries.
You need to modify the schema.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Define the surrogate key as an INT data type. Combine the distinct flag/indicator combinations into a single dimension.
B. Define the surrogate key as an INT data type. Create a single fact dimension in each table for its flags and indicators.
C. Define the surrogate key as a BIGINT data type. Combine the distinct flag/indicator combinations into a single dimension.
D. Define the surrogate key as a BIGINT data type. Create a single fact dimension in each table for its flags and indicators.
Answer: A
161. DRAG DROP - (Topic 9)
You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of the package.
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:
Q24. HOTSPOT - (Topic 10)
You are developing a SQL Server Analysis Services (SSAS) cube.
You are writing the following Multidimensional Expressions (MDX) statement for use by a calculated measure. The measure computes the sales amount for the same time period of the previous year. (Line numbers are included for reference only.)
You need to complete the MDX statement.
Which MDX function should you use in line 03? To answer, select the appropriate MDX function in the functions list.
Answer:
Q25. - (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
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 10)
You develop a SQL Server Analysis Services (SSAS) tabular project. The tabular model loads data from a SQL Server 2012 relational database each day.
You define a connection.
You need to ensure that the connection minimizes the attack surface area of the server.
How should you define the impersonation information for the connection? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Use the credentials of the SQL Server Analysis Services (SSAS) service account. Grant least privilege to this account in the source database.
B. Use your domain credentials. Grant least privilege to your account in the source database.
C. Create and use a new Windows domain account. Grant least privilege to this account in the source database.
D. Use SQL Server authentication.
Answer: C
Q28. - (Topic 7)
You need to develop the tabular project to support the date analysis requirements.
What should you do?
A.
.
Create one date table named Date.
.
Create an active relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
.
Create an inactive relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
B.
.
Create two date tables, one named Order Date and one named Ship Date.
.
Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
.
Create an inactive relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
C.
.
Create one date table named Date.
.
Create an active relationship between the DateKey column of the Date table and the ShipDateKey column of the Sales table.
.
Create an inactive relationship between the DateKey column of the Date table and the OrderDateKey column of the Sales table.
D.
.
Create two date tables, one named Order Date and one named Ship Date.
.
Create an active relationship between the DateKey column of the Order Date table and the OrderDateKey column of the Sales table.
.
Create an active relationship between the DateKey column of the Ship Date table and the ShipDateKey column of the Sales table.
Answer: C
Q29. HOTSPOT - (Topic 10)
You create a new report in SQL Server Data Tools (SSDT). The report queries a Windows Azure SQL Database database table.
In a report table showing sales by countries and cities, you need to enable users to hide or show cities by clicking the name of a country.
Which property page of the city text box should you use? (To answer, select the appropriate tab in the answer area.)
Answer:
281. - (Topic 10)
You manage a SQL Server Reporting Services (SSRS) instance. The ReportingServicesService.exe.config file has been modified to enable logging. Some users report that they cannot access the server.
You need to ascertain the IP addresses of the client computers that are accessing the server.
What should you do?
A. View the Report Server service trace log.
B. View the ExecutionLog view in the Report Server database.
C. View the Report Server HTTP log.
D. View the Windows System event log.
Answer: C
Q30. - (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.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Create a standard subscription for each record in the table.
B. Create a data-driven subscription for each record in the schedule table.
C. Create one data-driven subscription. Schedule the subscription to frequently retrieve user preferences.
D. Create a standard subscription for each subscription schedule.
Answer: C
