QuiztudyPREMIUM
🌍 All Study Guides📰 Blog💡 About
Google Business Intelligence Professional Certificate • STUDY MODE

TEST YOUR KNOWLEDGE: DATA MODELING, SCHEMAS, AND DATABASES

QUESTION 1 OF 4

A business intelligence professional stores large amounts of raw data in its original format within a database system. Then, they can access the data whenever they need it for their BI project. What type of database are they using?

A
Data structure
B
Data lakeCorrect Answer
C
Data ecosystem
D
Data storage
Explanation:

They are using a data lake. A data lake is a database system that stores large amounts of raw data in its original format until it’s needed.

QUESTION 2 OF 4

Which of the following statements correctly describes primary and foreign keys? Select all that apply.

A
A foreign key references a column or a group of columns in which each row uniquely identifies each record in the table.
B
A primary key forms connections because it is a field within a database table that’s a primary key in another table.
C
A primary key references a column or a group of columns in which each row uniquely identifies each record in the table.Correct Answer
D
A foreign key forms connections because it is a field within a database table that is a primary key in another table.Correct Answer
Explanation:

A primary key references a column or a group of columns in which each row uniquely identifies each record in the table. A foreign key forms connections because it is a field within a database table that is a primary key in another table.

QUESTION 3 OF 4

Fill in the blank: A _____ schema is an extension of a star schema, which contains additional dimensions.

A
dimensional
B
snowflakeCorrect Answer
C
geometric
D
responsive
Explanation:

A snowflake schema is an extension of a star schema, which contains additional dimensions.

QUESTION 4 OF 4

What type of database stores relevant data locally for analysis and less relevant data remotely?

A
Combined systems
B
Separated storage and computing systemsCorrect Answer
C
Single-homed databases
D
Distributed databases
Explanation:

Separated storage and computing systems are databases that store relevant data locally for analysis and less relevant data remotely.

Ready to test your recall?

A business intelligence professional stores large amounts of raw data in its original format within a database system. Then, they can access the data whenever they need it for their BI project. What type of database are they using?

A
Data structure
B
Data lake
C
Data ecosystem
D
Data storage

How confident are you in this answer?