Que: Which of the following is valid syntax for CREATE GLOBAL CUBE?

a. CREATE GLOBAL CUBE [LocalReseller]Storage ‘C:\LocalAWReseller1.cub’FROM [Adventure Works](MEASURE [Adventure Works].[Reseller Sales Amount],DIMENSION [Adventure Works].[Reseller],DIMENSION [Adventure Works].[DATE])
b. CREATE GLOBAL CUBE [LocalReseller]FROM [Adventure Works](MEASURE [Adventure Works].[Reseller Sales Amount],DIMENSION [Adventure Works].[Reseller],DIMENSION [Adventure Works].[DATE])
c. CREATE GLOBAL CUBE [LocalReseller]Storage ‘C:\LocalAWReseller1.cub'(MEASURE [Adventure Works].[Reseller Sales Amount],DIMENSION [Adventure Works].[Reseller],DIMENSION [Adventure Works].[DATE])
d. All of the mentioned
Answer: CREATE GLOBAL CUBE [LocalReseller]Storage ‘C:\LocalAWReseller1.cub’FROM [Adventure Works](MEASURE [Adventure Works].[Reseller Sales Amount],DIMENSION [Adventure Works].[Reseller],DIMENSION [Adventure Works].[DATE])

Leave a Comment