You work in the Business Intelligence (BI) department of a multinational company. The company has requested a new corporate BI solution that meets the following requirements: - The solution must use SQL Server Analysis Services (SSAS). - The model must increment by of add 10 million fact rows per month. - The model must be translated to English, French, or Spanish based on users' locale. - The model must be able to contain the most recent 36 months of data. You need to select the appropriate model type and partitioning strategy to meet the requirements. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

Question

Accepted Answer

B. Create a multidimensional model with one partition for each month. The multidimensional model is required because SSAS multidimensional natively supports metadata translations that render captions in English, French, or Spanish based on the user's locale - a feature not fully supported in tabular models. Creating one partition per month allows incremental processing of only the newest 10 million rows each month rather than reprocessing the entire 360 million row dataset, significantly reducing processing time and resource usage.

Answer

A. Create a multidimensional model with one partition for all of the data. A single partition for all data requires full reprocessing of the entire dataset each month, which is inefficient for a model adding 10 million rows per month across 36 months.

Answer

C. Create a tabular model with one partition for all of the data. SSAS tabular models lack native metadata translation support for multiple locales, so this option cannot satisfy the English/French/Spanish requirement; a single partition also forces full reprocessing each month.

Answer

D. Create a tabular model with one partition for each month. While monthly partitioning is correct, SSAS tabular models do not provide native multilingual metadata translation support based on user locale, making this model type unsuitable for the translation requirement.

You work in the Business Intelligence (BI) department of a multinational company. The company has requested a new corporate BI solution that meets the following requirements: - The solution must use S

Question

Options

How the community answered

Why each option

Topics

Community Discussion