ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-466 All Questions

View all questions & answers for the 70-466 exam
Go to Exam

Exam 70-466 topic 1 question 5 discussion

Actual exam question from Microsoft's 70-466
Question #: 5
Topic #: 1
[All 70-466 Questions]

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?

  • A. Process Clear
  • B. Process Data
  • C. Process Add
  • D. Process Full
  • E. Process Default
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
Process Add: This processing mode is available for Dimensions, Measure Groups and Partitions. When this processing mode is applied to Dimensions, it adds new members into the dimensions from the underlying database and updates the descriptions of the attributes. When this processing mode is applied to Measure
Groups and Partitions, it adds the incremental fact data into the cube and processes only the affected partitions.
Incorrect Answers:
B: Process Data: This processing mode is available for Dimensions, Measure Groups, Partitions, and Cubes. This processing mode is used to process the data without actually building or creating the aggregations and indexes.
References:
https://www.mssqltips.com/sqlservertip/2756/ssas-interview-questions-on-deployment-processing-querying-and-accessing/
by excelll at Nov. 8, 2019, 7:50 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
jepsilon
4 years, 9 months ago
Correct Answer is B https://docs.microsoft.com/en-us/analysis-services/tabular-models/process-database-table-or-partition-analysis-services?view=asallproducts-allversions
upvoted 1 times
...
excelll
5 years, 6 months ago
shouldnt this be B based on the description in the solution? you dont want to recalculate anything
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago