You need to create data semantic models in SQL Server Analysis Services. There are some recommended best practices for data modeling that one should follow. Which of the following practices are considered as the best practices that you would mind while creating data semantic models? (Select three options)

Answer options:

A.Never create a dimension model snowflake as well as a star while ingesting data from various sources.
B.Create a dimension model snowflake or/and star, even if you need to ingest data from various sources.
C.Only include the integer surrogate keys or value encoding in the model and exclude all the natural keys from the dimension tables.
D.Only include the natural keys in the model and exclude the integer surrogate keys or value encoding.
E.Decrease cardinality to reduce the uniqueness of the values and allow much better compression.
F.Increase the cardinality to reduce the uniqueness of the values and allow much better compression.

Correct Answers: B, C and E 
The below image describes the best practices that can be considered while creating data semantic models in, Azure Analysis Services, SQL Server Analysis Services, or Power BI: 

Option A is incorrect. It is recommended to create a dimension model even if you need to ingest data from various sources.
Option B is correct. You need to create a dimension model snowflake or/and star, even if you need to ingest data from various sources.
Option C is correct. The best practices ask to only include the integer surrogate keys or value encoding in the model and exclude all the natural keys from the dimension tables.
Option D is incorrect. The best practices ask to only include the integer surrogate keys or value encoding in the model and exclude all the natural keys from the dimension tables.
Option E is correct. You should decrease the cardinality to reduce the uniqueness of the values and allow much better compression.
Option F is incorrect. Decreasing the cardinality will help in reducing the uniqueness of the values and allowing much better compression.
Reference: 
To know more about Data models, please visit the below-given link: 

https://azure.microsoft.com/en-in/blog/data-models-within-azure-analysis-services-and-power-bi/