Skip to content

Data Analysis and Presentation Questions

Practice questions for Data Analysis and Presentation topic in Google Cloud Associate Data Practitioner. 52 questions covering this domain.

52 questions12 easy28 medium12 hard
Q1
medium

An analyst wants to forecast future monthly sales from historical time series data by using BigQuery ML. Which model family best fits?

Q2
medium

A data scientist wants to reduce a set of correlated numeric features to fewer dimensions while retaining as much variation as possible. Which BigQuer...

Q3
easy

Which notebook environment is collaborative, managed, and integrated with BigQuery and Vertex AI on Google Cloud?

Q4
easy

Why is BigQuery ML attractive to many analysts?

Q5
medium

A dataset labels customers as likely to churn or not churn. Which BigQuery ML model type is the best fit for this classification task?

Q6
medium

A retailer wants to segment customers into groups without labeled outcomes. Which BigQuery ML model type best fits?

Q7
hard

A company needs unlimited Looker users plus security features such as VPC Service Controls and private connections. Which Looker edition meets those n...

Q8
medium

A machine learning lead wants a central place to organize model versions, assign aliases, and deploy approved models to endpoints, including BigQuery ...

Q9
medium

A company wants a governed semantic model, reusable business logic, and dashboards built on LookML rather than only ad hoc report building. Which tool...

Q10
easy

Which Google Cloud service is the primary place to define and execute SQL queries for large-scale reporting and analysis in this certification scope?

Q11
medium

A team already has a model deployed to a Vertex AI endpoint and wants to call it from BigQuery SQL. What should they create in BigQuery ML?

Q12
hard

A team wants notebook code to use the same Google Cloud access as the signed-in user by default, and they also want recurring notebook runs whose resu...

Q13
hard

A data scientist needs dimensionality reduction in BigQuery ML and is considering PCA and k-means. Which statement is correct?

Q14
easy

A business user wants a no-cost drag-and-drop reporting tool with many connectors and easy dashboard sharing. Which product best matches that need?

Q15
easy

Which Google Cloud BI tool provides a governed semantic modeling layer based on LookML?

Q16
medium

An analyst needs to add row-level filtering so that each region's users see only their region's rows in a BigQuery table. Which feature is the most di...

Q17
medium

An analyst wants to call a Vertex AI text embedding model from BigQuery SQL without exporting data. Which BigQuery construct supports this?

Q18
medium

An analyst wants to share an interactive dashboard with executives and allow them to filter by date and region without granting BigQuery access. Which...

Q19
hard

An analyst wants to run notebooks alongside SQL in a unified BigQuery experience and share results with collaborators inside Google Cloud. Which envir...

Q20
medium

An analyst wants to mask sensitive column values, such as emails, for some users while showing them to others, without duplicating the table. Which Bi...

Sign in to see all 52 questions

Create a free account to browse all questions — completely free during our launch phase.