Medallion Architecture — Learn free

Self-check

Questions 1–10 of 10

1. What is the correct order of layers in Medallion Architecture?
Question 1A. Gold, Silver, BronzeB. Silver, Bronze, GoldC. Bronze, Silver, GoldD. Bronze, Gold, SilverE. Raw, Gold, Silver
2. In which kind of tables does Medallion Architecture sit?
Question 2A. Oracle RDBMS tablesB. Delta Lake tablesC. CSV files on a file serverD. OLAP cubesE. In-memory tables
3. Why is the Raw layer normally not considered part of Medallion Architecture?
Question 3A. Because it is stored in the Gold layerB. Because it is deleted after ingestionC. Because it contains only aggregated dataD. Because it is totally raw source data, whereas Bronze, Silver and Gold are Delta Lake tablesE. Because Databricks does not support it
4. Which of the following is NOT a standardisation transformation named for the Bronze layer?
Question 4A. Standardising date formats from different source systemsB. Giving NULL values some valuesC. Fixing data types and column sizesD. Performing CDC to extract delta or incremental dataE. Building data marts around business KPIs
5. How do data models in the Bronze layer compare with the source systems?
Question 5A. They remain the same as the source systemsB. They are converted to a star schemaC. They are converted to Third Normal FormD. They are flattened into a single wide tableE. They are replaced by a semantic layer
6. What happens in the Silver layer of Medallion Architecture?
Question 6A. Raw files are landed from source systemsB. Data is transformed into an Enterprise Data Warehouse, often in the Bill Inmon 3NF modelC. Cubes are built for reportingD. Data is archived to cold storageE. Access control policies are applied
7. Which layer hosts Data Marts or Semantic Layers focused on business KPIs such as Customer Analytics or Product Recommendations?
Question 7A. RawB. BronzeC. SilverD. GoldE. Landing
8. Which traditional layer sequence is Medallion Architecture said to be equivalent to?
Question 8A. Landing, Staging, Data Warehouse/Data Mart, Semantic/Aggregation Layers, CubesB. Extract, Transform, LoadC. Batch, Speed, ServingD. OLTP, ODS, OLAPE. Ingest, Encrypt, Publish
9. What is described as the only real difference Databricks brought with Medallion Architecture?
Question 9A. It introduced batch processingB. It brought everything into the Data Lake, eliminating RDBMSsC. It added a fourth Platinum layerD. It removed the need for data standardisationE. It replaced SQL with Python
10. Where do most organisations prefer to land all source system data?
Question 10A. Directly in the Gold layerB. In the Silver layerC. In the Raw layerD. In an external RDBMSE. In the semantic layer