Free Microsoft 070-470 Exam Dumps Questions & Answers


Exam Code/Number:	070-470Join the discussion
Exam Name:	Recertification for MCSE: Business Intelligence
Certification:	Microsoft
Free Question Number:	316
Publish Date:	Sep 25, 2026
# of views:	2828
Rating 100%

Page: 1 / 64
Total 316 questions

Question 1

DRAG DROP
You are administering a SQL Server Analysts Services (SSAS) database on a server. The database hosts a financial cube based on a SQL Azure database.
You need to grant write access to the financial cube for all users in the group USA\PowerUsers.
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.)

Question 2

A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query facts by using a hierarchy named Geography from a dimension named Geography.
The DimGeography table in the data source view is used as the source of the Geography dimension. The table has the following structure.

---
The Geography dimension has three attribute hierarchies:
City
State-Province
Country
The attributes have the following relationships defined: City > State-Province > Country. Each attribute has a key and a name sourced from the related key and name columns in the DimGeography table.
During processing, you receive the following error message: "Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimGeography', Column: 'StateProvinceKey', Value: '23'. The attribute is 'State-Province'."
You verify that the data is accurate.
You need to ensure that the dimension Processes successfully.
What should you do?

A.Delete the Geography hierarchy.
B.Relate the State-Province and Country attributes directly to the City attribute.
C.Remove the duplicate data from the DimGeography table.
D.Remove the State-Province attribute.

Question 3

You are designing a SQL Server Reporting Services (SSRS) report.
The report defines a single SQL Server data source and dataset.
You need to include additional data sourced from a SQL Azure database in the report.
What should you do?

A.Generate an Atom-compliant data feed for the report.
B.Create a SQL Azure dataset that uses the existing data source.
C.Create a SQL Server data source and then add a dataset that uses the new data source.
D.Create a SQL Azure data source and then add a dataset that uses the new data source.

Question 4

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

A.In-Memory
B.DirectQuery
C.LazyAggregations
D.Regular
E.Low-latency MOLAP
F.High-latency MOLAP

Question 5

DRAG DROP
You are developing a SQL Server Analysis Services (SAS) multidimensional project that is configured to source data from a SQL Azure database.
You plan to use multiple servers to process different partitions simultaneously. You create and configure a new data source.
You need to create a new partition and configure SQL Server Analysis Services (SSAS) to use a remote server to process data contained within the partition.
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.)