Data Dictionary — Learn free

Self-check

Questions 1–10 of 10

1. Under which discipline does a Data Dictionary fall?
Question 1A. Master Data ManagementB. Data Quality ManagementC. Metadata ManagementD. Application ArchitectureE. Network Security
2. Why is a Data Dictionary described as one of the most important items for a system's impact analysis?
Question 2A. It gives a clear picture of all the elements in the databaseB. It stores the business strategyC. It replaces the need for testingD. It automatically fixes broken queriesE. It encrypts all sensitive fields
3. Without a Data Dictionary in place, how much longer are future implementations said to take?
Question 3A. About 10% longerB. Twice to three times longerC. Ten times longerD. No longer at allE. Half as long
4. Which of the following is NOT listed as information a Data Dictionary stores?
Question 4A. Field name, description, data type and lengthB. Indexes, primary and foreign keysC. Relationships between tables, schemas and databasesD. Number of records in each tableE. Marketing campaign results
5. What is an Active Data Dictionary?
Question 5A. A manually maintained spreadsheet of tablesB. A dictionary stored in a separate reporting databaseC. A dictionary managed within the same database so changes are captured automaticallyD. A dictionary that is updated once a yearE. A dictionary that stores only business terms
6. What is a Passive Data Dictionary?
Question 6A. One that automatically updates when the schema changesB. One embedded in the database engineC. One that only records row countsD. One maintained in a separate database or as a manually maintained fileE. One that is read-only for all users
7. How many types of Data Dictionary are described?
Question 7A. OneB. TwoC. ThreeD. FourE. Five
8. Who normally interacts with a Data Dictionary?
Question 8A. Technical folksB. Marketing managersC. External customersD. Regulators onlyE. Board members
9. Which of these semi and unstructured data sources is named as raising the need for a Data Dictionary?
Question 9A. Relational tables onlyB. Video, audio, logs, emails, PDFs and social mediaC. Spreadsheets onlyD. Printed reportsE. Data warehouse fact tables
10. Alongside the Data Glossary, what risk is a Data Dictionary described as the next step towards mitigating?
Question 10A. Server downtimeB. Role explosionC. Cartesian joinsD. A potential Data SwampE. Vendor lock-in