PrepAway - Latest Free Exam Questions & Answers

Category: 70-466 (v.2)

Exam 70-466: Implementing Data Models and Reports with Microsoft SQL Server 2012 (update March 5th, 2015)

You need to implement a solution that meets the requirements

You are developing a SQL Server Analysis Services (SSAS) tabular project. The model
includes a table named Sales. The Sales table includes a single date column.
The Sales table must meet the following requirements:
Queries must be able to return all rows.
Must be able to support four different processing schedules for different date ranges.
Date ranges must not include any overlapping data.
You need to implement a solution that meets the requirements.
What should you do?

How should you write the calculation?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A column named City must be added to the table named Customer. The column will be used
in the definition of a hierarchy. The City column exists in the Geography table that is related
to the Customer table.
You need to add the City column to the Customer table.
How should you write the calculation?

Which processing mode should you use?

You are managing a SQL Server Analysis Services (SSAS) tabular database.
The database must meet the following requirements:
The processing must load data into partitions or tables.
The processing must not rebuild hierarchies or relationships.
The processing must not recalculate calculated columns.
You need to implement a processing strategy for the database to meet the requirements.
Which processing mode should you use?

You need to implement a solution that meets the needs of the sales team while minimizing development and admin

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used
by the finance, sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use. The sales team
does not need any information other than sales-related resources in the tabular model. The
finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing
development and administrative effort.

What should you do?

You need to use the least amount of development effort to achieve this goal

You are developing a SQL Server Analysis Services (SSAS) tabular project.
In the data warehouse, a table named Sales Persons and Territories 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 need to use the least amount of development effort to
achieve this goal.
What should you do? (More than one answer choice may achieve the goal. Select the BEST
answer.)

Which four actions should you perform in sequence?

DRAG DROP
You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server.
While processing a very large tabular model, you receive an out-of-memory error. You
identify that the amount of physical memory in the server is insufficient. Additional physical
memory cannot be installed in the server.
You need to configure the server to allow paging to disk by using the operating system page
file (pagefile.sys).
Which four 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.)


Page 1 of 1812345...10...Last »