Microsoft
70-460 · Question #38
70-460 Question #38: Real Exam Question with Answer & Explanation
The correct answer is A. Define the surrogate key as an INT data type.. See the full explanation below for the reasoning.
Question
You are modifying a star schema data mart that feeds order data from a Microsoft Azure SQL Database database into a SQL Server Analysis Services (SSAS) cube. The data mart contains two large tables that include flags and indicators for some orders. There are 100 different flag columns, each with 10 different indicator values. Some flags reuse indicators. The tables both have a granularity that matches the fact table. You have the following requirements: - Allow users to slice data by all flags and indicators. - Modify the date dimension table to include a surrogate key of a numeric data type and add the surrogate key to the fact table. - Use the most efficient design strategy for cube processing and queries. You need to modify the schema. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ADefine the surrogate key as an INT data type.
- BDefine the surrogate key as an INT data type.
- CDefine the surrogate key as a BIGINT data type.
- DDefine the surrogate key as a BIGINT data type.
Community Discussion
No community discussion yet for this question.