最新的Microsoft 070-470免費考試真題

問題1

HOTSPOT
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.

正確答案:

問題2

You need to configure the partition storage settings to support the reporting requirements.
Which partition storage setting should you use?

A. High-latency MOLAP

B. Low-latency MOLAP

C. DirectQuery

D. Regular

E. LazyAggregations

F. In-Memory

正確答案: B

問題3

DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have
access to the original password that was used to create the SSIS catalog. A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
The production server that hosts the SSISDB database fails.
Sensitive data that is encrypted in the SSISDB database must not be lost.
You need to restore the production SSIS catalog to the disaster recovery server.
Which three steps 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.

正確答案:

問題4

DRAG DROP
You are the administrator of a SQL Server Integration Services (SSIS) catalog. You have access to the original password that was used to create the SSIS catalog.
A full database backup of the SSISDB database on the production server is made each day. The server used for disaster recovery has an operational SSIS catalog.
Information that is encrypted in the SSISDB database must not be lost.
You need to document the disaster recovery solution that restores the production SSIS catalog to the disaster recovery server.
Which three steps should you document in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

正確答案:

問題5

DRAG DROP
You are developing a SQL Server Analysis Services (SSAS) cube.
You need to reuse a measure group from a different database.
In SQL Server Data Tools (SSDT), 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.)

正確答案:

問題6

You are developing a BI Semantic Model (BISM) based on a simple and small dataset sourced from SQL Server. The data size and complexity of the data relationships will not change. The model will be used to produce reports in Power View.
You need to use an appropriate project type.
Which project types should you use? (Each answer presents a complete solution. Choose all that apply.)

A. a tabular project that uses the In-Memory query mode

B. a PowerPivot workbook that is deployed to Microsoft SharePoint Server 2010

C. a tabular project that uses the DirectQuery query mode

D. a multidimensional project that uses the ROLAP storage mode

E. a multidimensional project that uses the MOLAP storage mode

正確答案: A,C,E

說明：（僅 Fast2test 成員可見）

問題7

You need to deploy a solution for the planned self-service reports that will be used by the sales department managers.
What is the best solution you should deploy? More than one answer choice may achieve
the goal. Select the BEST answer.

A. A measure

B. A calculated column

C. A KPI

D. A filter

正確答案: C

問題8

DRAG DROP
You are using Multidimensional Expressions (MDX) to query a SQL Server Analysis Services (SSAS) cube.
You need to compute the aggregate value of the 10 most-ordered produces in the Product Categories hierarchy. The Product level is the lowest in the hierarchy.
Which functions should you use to complete the MDX query? (To answer, drag the appropriate functions from the list of functions to the correct locations in the answer area.)

正確答案:

問題9

You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Employee Security defines a relationship between a salesperson's name, logon ID, and assigned sales territory.
You need to ensure that each salesperson has access to data from only the sales territory assigned to that salesperson. You also need to minimize the development effort.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create a new Active Directory Domain Services (AD DS) security group and add each salesperson as a member. Then create a new role with Read permission. Add the group as a member to the new role.

B. Create a separate tabular project for each sales territory. Grant each salesperson access to the corresponding tabular model of the assigned sales territory.

C. Create a new role with Read permission and then add each salesperson's logon as a member to the role.

D. Add the Employee Security table to the model, define the relationships, and then implement dynamic security by using row filters. Grant each salesperson access to the model.

正確答案: D

問題10

You need to implement the product dimension.
What should you do?

A. In the data warehouse, create a product dimension from a view that joins the Product and ProductColor tables in the financial database and contains product name and product color attributes.

B. In the cube, create a named query that joins the Product and ProductColor tables in the financial database.

C. In the data warehouse, create a product dimension table that contains product name and product color.

D. In the data warehouse, create a dimension table that contains product name and a dimension table that contains product color.

正確答案: C

最新的Microsoft Recertification for MCSE: Business Intelligence - 070-470免費考試真題

聯系我們

站內鏈接

最新更新