Top Far out 70-470 free question Reviews!

70-470 Exam

2021 Dec 70-470 free download

Q101. - (Topic 10)

You are developing a SQL Server Analysis Services (SSAS) cube for the accounts department.

You create a measure group named Exchange Rate that consists of measures pertaining to currency exchange rates. One of the measures in this group is named Average Rate and it will be used to report the average currency exchange rate over time.

Currently the AggregationFunction property for the Average Rate measure is set to Sum.

You need to ensure that Average Rate measure reports the average of the currency exchange rate over time.

Which value should you select for the AggregationFunction property for the Average Rate measure? To answer, select the appropriate setting in the answer area.

A. AverageOfChildren

B. ByAccount

C. Count

D. DistinctCount

E. FirstChild

F. FirstNonEmpty

G. LastChild

H. LastNonEmpty

I. Max

J. Min

K. None

L. Sum

Answer: A

Explanation: AverageOfChildren Specifies average of leaf descendants in time. Average does not count an empty value as

Q102. - (Topic 10)

You manage a SQL Server Reporting Services (SSRS) instance.

An application must pass credentials to the local security authority for Reporting Services.

You need to configure Reporting Services to issue a challenge/response when a

connection is made without credentials.

Which authentication type should you configure in the RSReportServer.config file?

A. RSWindowsNTLM

B. RSWindowsBasic

C. RSWindowsKerberos

D. RSWindowsNegotiate

Answer: B

Q103. - (Topic 3)

You need to define the trend calculation for the sales performance KPI.

Which KPI trend MDX expression should you use?

A. CASE WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN -1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE 1 END

B. IIF([Sales Variance %3 < ([Sales Variance %], [Date].[Calendar].PrevMember), 1, 0)

C. IIF([Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember), 0, 1)

D. CASE WHEN [Sales Variance %] < ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 1 WHEN [Sales Variance %] = ([Sales Variance %], [Date].[Calendar].PrevMember) THEN 0 ELSE -1 END

Answer: A

Q104. - (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 tabular model.

Which role permission should you use?

A. Browser

B. ReadDefinition

C. Read

D. Process

E. Explorer

F. Select

Answer: C

Q105. DRAG DROP - (Topic 10)

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project file includes two cubes named Finance and Operations. The project also includes a dimension named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date dimension has been added to both cubes.

You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects.

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:

Replace 70-470 exam answers:

Q106. - (Topic 10)

You install SQL Server Reporting Services (SSRS). You need to back up a copy of the symmetric key. Which command should you run?

A. rskeymgmt -d

B. rskeymgmt -i.

C. rskeymgmt -e -f %temp%\rs.key -p Password1

D. rskeymgmt -a -f %temp%\rs.key -p Password1

Answer: C

210. - (Topic 10)

...

A multinational retailer has retail locations on several continents. A single SQL Server Reporting Services (SSRS) instance is used for global reporting.

A SQL Server Analysis Services (SSAS) instance for each continent hosts a multidimensional database named RevenueData. Each RevenueData database stores data only for the continent in which it resides. All of the SSAS instances are configured identically. The cube names and objects are identical. Reports must meet the following requirements:

A report parameter named ServerName must be defined in each report.

When running a report, users must be prompted to select a server instance.

The report data source must use the Microsoft SQL Server Analysis Services data

source type.

You need to create a data source to meet the requirements.

How should you define the expression that is assigned to the connection string property of the data source?

A. ="Server=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"

B. ="Data Source=" &Parameters!ServerName.Value& ";Initial Catalog=RevenueData"

C. ="Server=" & Parameters!ServerName.Value

D. ="Data Source=@ServerName;Initial Catalog=RevenueData"

E. ="Server=@ServerName;Initial Catalog=RevenueData"

Answer: B

Q107. - (Topic 3)

You need to create the Sales Reporting shared SSRS data source. Which SSRS data connection type should you use?

A. OData

B. Microsoft SQL Server

C. ODBC

D. OLE DB

Answer: B

Q108. - (Topic 9)

A group of report writers develop reports. The report writers currently use Report Builder

1.0 and report models. The report writers are not trained on SQL Server query writing. Their report assignments come from various departments within the organization.

The company is upgrading to SQL Server 2012 with SQL Server Reporting Services (SSRS) in native mode. After the upgrade, reports will retrieve data from a large new data warehouse that will reside on an instance of the SQL Server 2012 Database Engine. Reports for each department will retrieve data from only a subset of the data warehouse tables.

You are designing the data access strategy. You have the following requirements:

. Ensure that report writers can create only reports that display data which they have database permissions to view. . Minimize the effort required to update connection strings for all reports developed by the report writers. . Minimize the number of fields visible in a specific report for report writers who work for multiple departments.

You need to design the data access strategy.

What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create report models by using SQL Server Data Tools (SSDT). Include data sources and data source views for each department's data requirements. Configure each data source to use integrated security.

B. Create one shared data source that uses integrated security. Create an embedded dataset for each report.

C. Create one shared data source that uses integrated security. Create one shared dataset that includes all tables required by the report writers.

D. Create one shared data source that uses integrated security. Create a shared dataset for each department's data requirements.

Answer: D

Q109. - (Topic 10)

You are developing a multidimensional project that includes a dimension named Organization. The dimension is based on the DimOrganization table in the data warehouse. The following diagram illustrates the table design.

The Organization dimension includes a parent-child hierarchy named Organizations.

The dimension includes the following dimension attributes:

Organization, which is a key attribute

Organizations, which defines the parent-child hierarchy

Currency Code, which is a regular attribute

When users browse the dimension, three hierarchies are visible to them.

You need to ensure that the Organization hierarchy is not visible to users.

...

What should you do?

A. Set the AttributeHierarchyDisplayFolder property to Null for the Organization attribute.

B. Delete the Organization attribute.

C. Set the AttributeHierarchyEnabled property to False for the Organization attribute.

D. Set the AttributeHierarchyVisible property to False for the Organization attribute.

Answer: D

Q110. - (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