Microsoft
70-467 · Question #168
70-467 Question #168: Real Exam Question with Answer & Explanation
Sign in or unlock 70-467 to reveal the answer and full explanation for question #168. The question stem and answer options stay visible for context.
Question
You are designing a customer dimension for a multidimensional OLAP (MOLAP) database. The dimension table will contain millions of rows of data. Customer dimension attributes will come from the following two sources: - An enterprise resource planning (ERP) system that contains millions of rows of data. Attributes from this source will be updated daily. - A marketing database that contains thousands of rows of data representing customers' geographic information. Attributes from this source will be updated monthly. Most report queries against the cube use attributes from both sources. Customers in the cube dimension will frequently be filtered by the geographic attributes. You need to design the dimension table and cube dimension to ensure that report queries perform well, and minimize the time required to reprocess cube attributes. What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
Options
- ACreate a dimension table for each source.
- BCreate one dimension table that combines data from both sources.
- CCreate one dimension table that combines data from both sources.
- DCreate a dimension table for each source, and a cube dimension for each source.
Unlock 70-467 to see the answer
You've previewed enough free 70-467 questions. Unlock 70-467 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.