Multidimensional eXpression(MDX) — Learn free

Self-check

Questions 1–10 of 10

1. What is MDX?
Question 1A. The query language for relational databases used by OLTP systemsB. The query language for OLAP databases, used to extract multi-dimensional data from OLAP CubesC. A data transfer protocol for the cloudD. A file format for semi-structured dataE. A machine learning framework
2. Who invented MDX, and when?
Question 2A. Oracle engineers in 1987B. IBM engineers in 2007C. SQL Server engineers in 1997D. Google engineers in 2010E. Hadoop contributors in 2005
3. What is SQL primarily used for, in contrast to MDX?
Question 3A. Querying OLAP CubesB. Querying relational databases, primarily in OLTP systems, though also in warehouses, lakes and vaultsC. Writing spreadsheet formulasD. Training machine learning modelsE. Encrypting data
4. What is MDX syntax said to resemble?
Question 4A. An XLS (spreadsheet) formulaB. Python codeC. A JSON documentD. A shell scriptE. An XML schema
5. Why is MDX hardly used nowadays, despite being decades old?
Question 5A. Because OLAP Cubes no longer existB. Because it was never released commerciallyC. Because of the ease of use of the SQL languageD. Because it only works on mainframesE. Because it is too expensive to license
6. In MDX data types, what is a Scalar?
Question 6A. A number or a stringB. A dimension such as timeC. A level such as year or monthD. One or more members of a hierarchyE. A column in a cube
7. In MDX, what is a Hierarchy?
Question 7A. A single date valueB. A numeric measureC. A set of tuplesD. Something like a dimension, for example year, month, week and day within a time dimensionE. A relational table
8. In MDX, what is a Member?
Question 8A. The level of a hierarchy, such as year or monthB. A collection of tuplesC. A string constantD. The name of a cubeE. A member of a hierarchy, such as an exact date, week or month
9. How do Tuples and Sets relate in MDX?
Question 9A. A Tuple contains one or more SetsB. A Set is a numeric measure and a Tuple is a stringC. They are the same thingD. A Set contains one or more Tuples, and a Tuple contains one or more members of a hierarchyE. A Tuple is a table and a Set is a column
10. Which of the following is NOT one of the MDX data types listed?
Question 10A. ScalarB. HierarchyC. LevelD. TupleE. Vector