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…

Question

Options

• AYou should utilize the ProcessDefault command.
• BYou should utilize the ProcessClear command.
• CYou should utilize the ProcessIndexes command.
• DYou should utilize the ProcessDefault and the ProcessClear commands.

• A
  11% (4)
• B
  3% (1)
• C
  8% (3)
• D
  78% (28)

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

No community discussion yet for this question.