Preparing and using data for analysis Questions
Practice questions for Preparing and using data for analysis topic in Google Cloud Professional Data Engineer. 30 questions covering this domain.
A publisher enables data egress restrictions on a shared BigQuery dataset. Which subscriber action can be blocked by that restriction?
A team wants to share a filtered subset of source data with another group without exposing the full source dataset directly. Which BigQuery feature is...
What is BI Engine in BigQuery?
Which statement best describes BigQuery materialized views?
Which query characteristic would prevent BI Engine from accelerating a BigQuery query?
When a subscriber accepts a BigQuery data share, what do they receive?
A team wants to create and auto-refresh materialized views under capacity-based pricing. Which editions support creating materialized views according ...
A BigQuery dataset contains a sales table accessed by analysts in many regions. The team wants each analyst to see only the rows for the region they a...
Which BigQuery object stores a saved query that runs each time it is referenced and does not store its own data?
A team wants to define a SQL function that can be reused across many queries and projects, persisted in a dataset, and updated independently of the qu...
A team wants a query to run automatically every hour and write its results into a destination table without managing infrastructure. Which BigQuery fe...
A team wants to mask access to sensitive columns such as email and phone in BigQuery while still allowing approved users to see the values. Which feat...
An analyst wants to create a dashboard that connects directly to BigQuery and lets users explore aggregated metrics without copying data. Which Google...
Which BigQuery feature lets analysts create and train machine learning models directly using SQL without exporting data?
A BigQuery ML model was trained on sales data. The data scientist wants to evaluate the model's performance on a held-out test set using BigQuery ML's...
Which BigQuery feature lets users analyze BigQuery data directly inside a Google Sheets spreadsheet, allowing them to run queries and create pivot tab...
An analyst needs to query a Parquet file stored in Cloud Storage directly from BigQuery without loading it into native storage. Which BigQuery feature...
A data engineering team wants to share a curated subset of a production BigQuery dataset with analysts in a different GCP project without granting the...
A BigQuery table stores order line items as an ARRAY of STRUCTs. An analyst wants to flatten the array so each element appears as a separate row in th...
A data scientist wants to train a linear regression model on a BigQuery sales table to predict revenue from product attributes, using only SQL without...
Sign in to see all 30 questions
Create a free account to browse all questions — completely free during our launch phase.