Exam Multiple Choice part (covers all topics): 25 points
1. Which of the following statements is/are true about databases?
Statement 1: A primary key is a field or a combination of fields that uniquely identifies
each record in a table.
Statement 2: A table can have only one primary key and its values are not allowed to
be NULL.
Statement 3: The purpose of the foreign key is to identify a particular row of a
referenced table
A. Only statement 1 is true
B. Only statement 2 is true
C. Only statement 1 and 2 are true
D. Only statement 1 and 3 are true
E. All statements are true
2. Which of the following statements is/are true about data warehouse design?
Statement 1: A typical example of the data mart approach is the bus architecture and
a typical example of the enterprise data warehouse approach is the hub-and-spoke
architecture.
Statement 2: The typical data modeling perspective taken in the data mart approach
is related to dimensional star and snowflake modeling and the typical data modeling
perspective taken in the enterprise data warehouse approach is entity-relational
modeling
A. Only statement 1 is true
B. Only statement 2 is true
C. Both statements are true
D. Both statements are false
3. Which of the following statements is/are true about data lake design?
Statement 1: A data lake in terms of processing is schema-on-read, when the cleaned
data is read into the data lake before it is used for analysis
Statement 2: a data lake is just a replication of the transaction data, now used for
analysis.
A. Only statement 1 is true
B. Only statement 2 is true
C. Both statements are true
D. Both statements are false
4. All of the statements related to data warehouses are true except:
A. The typical user of a data lake is a data scientist
B. The user of a data warehouse are both data scientists and business
professionals
C. A federated data warehouse keeps the exist XXXX
D. A federated data warehouse combines an enterprise data warehouse
approach and a dependent data marts
-1-
, 5. Which of the following statements is/are true about Extraction, Transforming, Load
(ETL)?
Statement 1. An advantage of an integral load is XXXX simplified, there is no need for
complex ETL software XXXX simple.
Statement 2. The advantage of delta load is less qu XXXX disadvantage is complex ETL
software to process XXXX.
A. Only statement 1 is true
B. Only statement 2 is true
C. Both statements are true
D. Both statements are false
6. Which of the following statements is/are true about XXXX
Statement 1. A data warehouse is non-volatile, which XXXX must be loaded as a
snapshot of the operational data XXXX with new snapshots in order to reflect changes
in th XXXX
Statement 2. The dimensional modelling technique XXXX collection of dimensionally
modelled independent XXXX
Statement 3. The use of meaningless surrogate keys XXXX general improve the query
performance and decrease XXXX
A. Only statement 1 is true
B. Only statement 2 is true
C. Only statement 1 and 2 are true
D. Only statement 1 and 3 are true
E. All statements are true
7. Which of the following statements XXXX
Statement 1. Semi-additive measures XXXX
Statement 2. Slice and unslice queries are inv XXXX hierarchies and measures to
perform aggregative XXXX
Statement 3. A dimension table has in general XXXX valued meaningless surrogate
keys, 2) descriptive XXXX 4) not too many rows.
A. Only statement 1 is true
B. Only statement 2 is true
C. Only statement 1 and 2 are true
D. Only statement 1 and 3 are true
E. All statements are true
-2-
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller leuvehaven2019. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $5.94. You're not tied to anything after your purchase.