BIDA EXAM 2019 - multiple choice part - not complete

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-