Developing SQL Data Models — Question 27

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?

Answer options

• A. Ensure that DirectQuery is enabled for the model.
• B. Ensure that DirectQuery is disabled for the model.
• C. Ensure that the Transactional Deployment property is set to True.
• D. Ensure that the Transactional Deployment property is set to False.
• E. Process the model in Process Full mode.
• F. Process the model in Process Data mode.
• G. Process the model in Process Defrag mode.

Correct answer: E

Explanation

The correct answer is E, as processing the model in Process Full mode will ensure that all data is refreshed and updated to reflect the new vacation packages, including the additional features. The other options either do not apply to updating the data model correctly or would not achieve the necessary comprehensive update required for the new cruise ship vacation packages.