PrepAway - Latest Free Exam Questions & Answers

Which is the correct answer?

You are managing a SQL Server 2008 Analysis Services (SSAS) database which includes a
Sale dimension that includes the Category and Subcategory properties for Company.com.

There is a rigid relationship type for properties.
The data source for the Sale dimension alters the relationship between the Type and Sub
Type values.
You should make sure that you could run an XML to operate the dimension to reflect the
change normally for Analysis (XMLA).
Which is the correct answer?

PrepAway - Latest Free Exam Questions & Answers

A.
You should utilize the ProcessDefault command.

B.
You should utilize the ProcessClear command.

C.
You should utilize the ProcessIndexes command.

D.
You should utilize the ProcessDefault and the ProcessClear commands.

Explanation:
Process Default Performs the minimum number of tasks required to fully initialize a mining
object. For example, if you change a model and send Process Default to the structure, the
server will process that model only. Process Full Drops the object stores and rebuilds the
model. Metadata changes, such as adding a new column to a mining structure, require
Process Full. Process Structure Reads and caches the training data in the structure. Does
not affect the mining models inside the structure. Process Clear Structure Drops the cached
data without affecting the mining models inside the structure. Disables drillthrough features.
Consider Process Clear Structure if you need to dispose of the sourcedata used to train the
models to reduce the disk footprint. Unprocess Deletes data from the mining object. When
this command is sent to a structure, it deletes the cached training data in the structure and
the model patterns


Leave a Reply