Which statement best distinguishes business intelligence (BI) from data analytics?
Bi Foundations
Question · Easy
Star schema: a city pop love song to a fact table
Short
In the PADM framework taught in the Google BI Certificate, what does each letter stand for?
A business stakeholder asks for a dashboard showing 'how we are doing.' What should a BI professional do first?
Tech Exam Prep Podcast
Listen on Spotify
Podcast
Which of the following is a leading indicator rather than a lagging indicator?
Question · Medium
In an OKR (Objectives and Key Results) framework, what is the role of a Key Result?
Which role is primarily responsible for designing and building the data warehouse and ingestion pipelines that a BI professional consumes?
A retail company wants to track average order value (AOV) on a real-time dashboard for store managers. Which is the best KPI definition?
What is the primary purpose of data governance in a BI organization?
A BI team discovers a dashboard exposes individual customer names alongside their health-related purchases. Which ethical principle is most directly violated?
During the Plan phase of PADM, which artifact is most important to produce?
Which of the following best describes a BI 'iterative' development approach?
What is the difference between an OKR and a KPI?
A BI professional is told that 'monthly active users' is the company's North Star metric. What does that imply?
A SaaS company tracks both 'trial signups' and 'paid conversions'. Which pairing is correct?
In requirements gathering, which question is LEAST useful for a BI professional?
What is the role of a 'data steward' in data governance?
A regulator requires that all customer data be retained for exactly 7 years and then deleted. Which governance concept is this?
Which BI professional skill is most directly demonstrated by translating 'help me reduce churn' into measurable KPIs and a clear data model?
What is the purpose of conducting a 'data inventory' during the Acquire phase of PADM?
Why is informed consent particularly important when BI dashboards include data collected from users?
Which statement about OLTP vs OLAP systems is correct?
Data Models Pipelines
What is the defining characteristic of a star schema?
How does a snowflake schema differ from a star schema?
What is a fact table?
Which is an example of a dimension table?
What is the 'grain' of a fact table?
A customer changes addresses and you need to keep both the old and new address with the date each was active. Which SCD type is most appropriate?
What does SCD Type 1 do when a dimension attribute changes?
What is the key difference between ETL and ELT?
Which Google Cloud product is primarily used as the data warehouse layer for BI?
What is the role of Cloud Composer in a Google Cloud BI stack?
What is a primary key?
What is a foreign key?
A table is in 3NF if it is in 2NF and which additional condition holds?
Question · Hard
Why is it common to denormalize dimension tables in an analytics warehouse?
Which type of fact table records one row per business event, such as a single sale?
Which describes a periodic snapshot fact table?
What is the purpose of a surrogate key in a dimension table?
What is a data mart?
What is the key difference between a data lake and a data warehouse?
What is a data lakehouse?
In medallion architecture, what is typically stored in the 'bronze' layer?
Which tool is most often used in modern stacks to perform SQL-based transformations in the warehouse (the 'T' in ELT)?
Which tool is commonly used as a managed ingestion connector to land SaaS data into a warehouse?
What is data lineage?
Which best describes data observability?
Loading more…