Explanation:The preceding syntax demonstrates creating a local, persisted version of the Adventure Works cube that contains only the Reseller Sales Amount measure, the Reseller dimension, and the Date dimension. 9. Which of the following is MDX Data Definition Statement ?
A. CREATE ACTION
B. DROP CUBE
C. CREATE CUBE
D. None of the mentioned
Answer:A
Explanation:The preceding syntax demonstrates creating a local, persisted version of the Adventure Works cube that contains only the Reseller Sales Amount measure, the Reseller dimension, and the Date dimension. 9. Which of the following is MDX Data Definition Statement ?
A. CREATE ACTION B. DROP CUBE C. CREATE CUBE D. None of the mentioned
Explanation:creates an action that can be associated with a cube, dimension, hierarchy, or subordinate object. 10. Valid syntax for REFRESH CUBE statement is :