Online Access Free 070-466 Exam Questions

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.Remove the duplicate data from the DimGeography table.
• B.Remove the State-Province attribute.
• C.Delete the Geography hierarchy.
• D.Relate the State-Province and Country attributes directly to the City attribute.

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.Select
• B.Process
• C.Read Definition
• D.Explorer
• E.Browser
• F.Read

You are developing a tabular Business Intelligence Semantic Model (BISM) database based on a SQL Server database.
In the data source, the FactInternetSales table is partitioned by month. Data from the current month has been updated and new data has been inserted in the FactInternetSales table, in the DimProduct table, and in the DimCustomer table.
In the model, the FactInternetSales table is also partitioned by month.
You need to ensure that the model has the most recent data while minimizing the processing time.
What should you do?

• A.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Defrag processing option. Then process the database with the Process Recalc processing option.
• B.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Recalc processing option.
• C.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Full processing option.
• D.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Clear processing option. Then process the database with the Process Data processing option.
• E.Process the latest FactInternetSales model table partition, the DimProduct table, and the DimCustomer table with the Process Data processing option. Then process the database with the Process Defrag processing option.

You are developing a SQL Server Analysis Services (SSAS) tabular database.
To maximize performance, the queries must be resolved by using cache unless otherwise specified in the connection string.
You need to configure the appropriate query mode.
Which query mode should you select?

• A.DirectQuery with In-Memory
• B.In-Memory
• C.In-Memory with DirectQuery
• D.DirectQuery

HOTSPOT
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.

Correct Answer: