Semantic Layer — Learn free

Self-check

Questions 1–10 of 10

1. From which language does the word "semantic" originate, and what does the root word mean?
Question 1A. Latin, meaning givenB. Ancient Greek, meaning significantC. French, meaning meaningD. German, meaning signE. Arabic, meaning truth
2. For what sole purpose is a semantic layer built in the data world?
Question 2A. Compressing data storageB. Encrypting data in transitC. Supporting business usersD. Scheduling batch jobsE. Replacing the data warehouse
3. Where does a semantic layer sit in relation to the physical data structures?
Question 3A. Inside each source systemB. Below the database storage engineC. Within the network layerD. As a representation layer on top of databases, schemas, tables and columnsE. In the operating system
4. What must be done first before exposing databases, schemas, tables and columns in BI tools for drag and drop?
Question 4A. Assign business names to all of themB. Convert them to unstructured dataC. Delete unused columnsD. Encrypt all columnsE. Move them to a data lake
5. A column named Date could actually contain Date_Of_Birth, Transaction Date or Financial_Year_End_Date. What does this example illustrate?
Question 5A. The need for database normalisationB. A redundancy anomalyC. A point-to-point integration problemD. The need for a heat mapE. Why converting column, table, schema and database names to business understanding is the semantic process
6. How does the semantic layer help when a person's date of birth has different value to life insurance versus medical insurance?
Question 6A. It stores two copies of the columnB. It clarifies the meaning so both parties have a common understanding of its valueC. It hides the column from one of the partiesD. It converts the date to a different format for eachE. It removes the column altogether
7. Why did creating semantic layers become difficult after the rise of big data?
Question 7A. Because BI tools stopped supporting semantic layersB. Because IT stopped maintaining themC. Because big data includes semi-structured and unstructured data, unlike structured sources where we already knew what was comingD. Because business users no longer needed dashboardsE. Because the Greek root word changed meaning
8. What is a Universal Semantic Layer (USL)?
Question 8A. A separate semantic layer created for each business unitB. A semantic layer that only IT can viewC. A layer that replaces BI tools entirelyD. A generic layer supporting all business units and departments so everyone can refer to one USLE. A semantic layer limited to structured data
9. What does a Universal Semantic Layer require in order to be built properly?
Question 9A. Proper Metadata Management including a Data Dictionary and Data GlossaryB. A point-to-point integration between all applicationsC. Removal of all BI toolsD. De-normalised source tablesE. A separate data warehouse per department
10. Who creates and maintains the Semantic Layer?
Question 10A. Business usersB. External regulatorsC. Machine learning modelsD. End customersE. IT folks