Physical Data Modelling (PDM) — Learn free

Self-check

Questions 1–10 of 10

1. What does Physical Data Modelling define?
Question 1A. The concrete implementation of data structures within a specific database platformB. The high-level business view of entitiesC. The natural-language facts of a businessD. The workflow of a loan processE. The enterprise-wide meaning of data
2. How does the physical model differ in nature from conceptual and logical models?
Question 2A. It is more abstractB. It is platform-agnosticC. It is deeply technology-specificD. It omits constraintsE. It focuses on business vocabulary
3. In the physical loan model, which column type is suggested for financial amounts?
Question 3A. BIGSERIALB. TIMESTAMPTZC. NUMERICD. ENUME. CHAR(3)
4. Why are decision status and repayment status defined as enumerated types in the physical model?
Question 4A. To make queries slower but saferB. To allow any free text valueC. To reduce the number of tablesD. To prevent invalid values from entering the systemE. To enable partition pruning
5. How is the one-to-one relationship between a loan and its approval decision enforced at the physical layer?
Question 5A. With a partitionB. With a triggerC. With a partial indexD. With a unique constraint on the decision referenceE. With a CHECK constraint on amount
6. Which partitioning strategy is given as an example for the loan and repayment tables?
Question 6A. Hash partitioning by customer nameB. List partitioning by currencyC. Partitioning by loan officerD. No partitioning is recommendedE. Range partitioning loans by origination date and repayments by due date
7. What is the purpose of a partial index in the physical model example?
Question 7A. To index every column in the tableB. To accelerate high-frequency queries such as retrieving open repayments without inflating the index footprintC. To enforce referential integrityD. To replace the primary keyE. To store audit history
8. Which of the following is NOT named as an operational consideration in Physical Data Modelling?
Question 8A. DEFERRABLE foreign keysB. Update timestamp triggersC. Change data capture strategiesD. Archival strategiesE. Ubiquitous language definitions
9. Which three questions do the Conceptual, Logical and Physical layers respectively answer?
Question 9A. How is it implemented? What exists? How is it structured?B. What entities exist? How are they structured and related? How are they implemented in a system?C. Who does what? How does work flow? What do terms mean?D. What is communicated? Who is connected? Under what conditions?E. What is the vocabulary? What is the network? What is the context?
10. What is described as the essential bridge to understand before moving from core to specialised modelling techniques?
Question 10A. The balance between normalisation and denormalisationB. The choice between cloud and on-premisesC. The difference between OLTP and OLAP hardwareD. The selection of a BI toolE. The choice of programming language