nerdexam
Microsoft

70-768 · Question #23

70-768 Question #23: Real Exam Question with Answer & Explanation

The correct answer is E. Process the model in Process Full mode.. Process Full processes an Analysis Services object and all the objects that it contains. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is requ

Question

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You administer a Microsoft SQL Server Analysis Services (SSAS) tabular model for a travel agency that specializes in vacation packages. Vacation bookings and packages are stored in a SQL Server database. You use the model as the basis for customer emails that highlight vacation packages that are currently underbooked, or projected to be underbooked. The company plans to incorporate cruise ship vacation packages. Cruise ship vacation packages include new features such as region availability and cruise line specialties that require changes to the tabular model. You must ensure that the tabular model reflects the new vacation packages. You need to configure the tabular data model. What should you do?

Options

  • AEnsure that DirectQuery is enabled for the model.
  • BEnsure that DirectQuery is disabled for the model.
  • CEnsure that the Transactional Deployment property is set to True.
  • DEnsure that the Transactional Deployment property is set to False.
  • EProcess the model in Process Full mode.
  • FProcess the model in Process Data mode.
  • GProcess the model in Process Defrag mode.

Explanation

Process Full processes an Analysis Services object and all the objects that it contains. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed.

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-768 Practice