54 questions · Data Analysis And Presentation · All types, answers revealed
You have a large table in BigQuery that is updated constantly. You need to perform a query that is consistent. What should you use?
This lets you query data as it existed at a past time.
Why this answer
Table snapshots allow you to query a consistent version of a table from a specific point in time.
What is the primary function of a Looker Explore?
This is the core purpose of the Explore UI.
Why this answer
An Explore is the user-friendly interface that allows analysts to query and visualize data defined in LookML.
You need to analyze a petabyte-scale dataset in BigQuery. To optimize cost, you must ensure that users only query relevant partitions. How should you enforce this?
This setting directly prevents queries that do not filter by the partitioning column.
Why this answer
Requiring partition filters forces users to include a WHERE clause on the partitioning column, preventing full table scans.
Which of the following describes the purpose of 'BigQuery ML'?
This allows data practitioners to do ML without leaving SQL.
Why this answer
BQML allows users to build and run machine learning models using standard SQL within BigQuery.
You notice your Looker dashboard is showing duplicate data. What is the most likely cause?
This is the classic cause of duplication in Looker.
Why this answer
Fan-outs occur when joining a one-to-many relationship without correctly defining the primary key or using the correct aggregate type.
A user wants to see the top 10 products sold, but also an 'Other' category for the rest. How can you achieve this in a Looker Explore?
This is the standard approach to bucket categories.
Why this answer
A 'Dimension Fill' or using a 'Case' statement in a dimension allows grouping everything else into an 'Other' bucket.
A colleague has shared a Vertex AI Workbench notebook with you. How can you run it?
This allows you to execute the code in your own compute environment.
Why this answer
You can open it in a managed instance and run the cells directly in the browser interface.
A user needs to see the distribution of values in a column in BigQuery. Which visualization approach is most effective for this?
Histograms show frequency distributions of continuous variables.
Why this answer
A histogram is the standard statistical visualization for showing the distribution of numerical data.
In Looker, what is the impact of defining a 'primary_key' in a LookML view?
Primary keys are required for correct join logic and avoiding double-counting.
Why this answer
Defining a primary key is essential for Looker to calculate accurate counts and prevent fan-outs (fan-out avoidance) when joining tables.
When optimizing a Looker model, you want to prevent users from accidentally running very expensive queries. Which parameter should you use in LookML?
This ensures a filter is applied to every query generated by the Explore.
Why this answer
The 'sql_always_where' parameter forces a filter on every query, which is an effective guardrail for cost and performance.
Which BigQuery feature allows you to monitor query usage and identify expensive queries?
This is the source of truth for query performance and cost history.
Why this answer
The 'INFORMATION_SCHEMA.JOBS' view contains metadata about all queries executed in the project.
Which service is the primary tool for managing and running Jupyter notebooks in a managed environment within Google Cloud?
This is the current standard for managed notebooks in Google Cloud.
Why this answer
Vertex AI Workbench is the managed service for running Jupyter notebook instances.
You are analyzing query performance in BigQuery. You notice that your queries are spilling to disk. What is the most likely cause?
Memory-intensive operations on non-optimized data result in disk spills.
Why this answer
Operations like ORDER BY, JOIN, or GROUP BY on large datasets without efficient distribution or filtering often cause spills to disk when memory limits are exceeded.
A data scientist is using Vertex AI Workbench and needs to share a notebook with a team member who only needs read access. What is the most secure way to do this?
This provides read-only access to the file without granting compute permissions.
Why this answer
Storing the notebook in Cloud Storage and using IAM permissions is the standard way to share notebook artifacts.
When creating a dashboard in Looker Studio, which connector type allows you to connect to an arbitrary SQL query?
This allows for complex logic directly in the data source.
Why this answer
The 'Custom Query' option in the BigQuery connector allows users to enter raw SQL.
Which TWO of the following are valid ways to visualize BigQuery data within the Google Cloud ecosystem?
Looker Studio is the native, no-cost visualization tool.
Why this answer
Looker Studio and Looker are the primary visualization tools for BigQuery data.
Which THREE features does Looker offer to support data governance?
Ensures one source of truth for business logic.
Why this answer
Governance is supported by central modeling, user permissions, and audit logs.
Which THREE of these are valid ways to monitor or analyze BigQuery performance?
Shows the execution stages of a query.
Why this answer
Performance analysis is done via metadata views, query plans, and monitoring dashboards.
Which THREE items can be added to a Looker Studio report to enhance interactivity?
Allows filtering by categorical values.
Why this answer
Controls allow users to change data views dynamically.
You are working in a Vertex AI Workbench notebook and want to list the files in your current working directory. What command should you run?
The '!' prefix allows executing shell commands from a notebook cell.
Why this answer
In a Jupyter-based environment, the `ls` command (prefix with % or ! if in a cell) lists files in the current folder.
A BigQuery table has 10 billion rows. You notice a query performing a cross-join is timing out. What should you do?
JOIN ON is significantly more efficient than a cross-join.
Why this answer
Cross-joins on massive datasets are the leading cause of query failure; they should be avoided in favor of JOIN ON or other set-based operations.
Which TWO actions can help reduce the time it takes to build a Jupyter notebook in Vertex AI Workbench?
Larger machines can handle more compute tasks faster.
Why this answer
Optimizing compute and pre-installing environments can speed up development.
In BigQuery, what does the 'Data Preview' tab show?
Previewing data is free and provides a quick look at the content.
Why this answer
The preview shows a sample of the rows in the table without consuming query quota or incurring costs.
In BigQuery, you want to improve query performance for a table that is frequently filtered by a `customer_id` column. What is the recommended strategy?
Clustering improves performance for filtering and grouping queries on the cluster key.
Why this answer
Clustering by `customer_id` organizes the data physically to optimize queries that filter by that specific column.
Which TWO types of data sources can be used to create a dashboard in Looker Studio?
Native Google Cloud integration.
Why this answer
Looker Studio supports many connectors including BigQuery and flat files.
You want to share a BigQuery dataset with a partner who uses a different Google Cloud project. What is the most secure way to grant them access?
This is the least privilege, most secure way to share access.
Why this answer
Using IAM to grant 'BigQuery Data Viewer' on that specific dataset is the standard way to provide secure access.
You need to perform a time-series analysis in BigQuery. Your data contains timestamps at a millisecond level, but you need to aggregate by hour. What is the most performant way to truncate the timestamp?
This function is the standard and most performant way to truncate timestamps.
Why this answer
The TIMESTAMP_TRUNC function is highly optimized for this specific task in BigQuery.
Which TWO of the following SQL techniques in BigQuery are best for optimizing performance on large tables?
Pruning data is the most effective way to reduce cost and runtime.
Why this answer
Filtering and selecting specific columns are the two most important query optimization techniques.
You want to automate the export of a BigQuery table to Cloud Storage on a daily basis. What should you use?
This service supports scheduled jobs for moving data.
Why this answer
BigQuery Data Transfer Service allows for scheduled exports and imports.
When designing a Looker dashboard, you need to display a value that is the average of a specific metric across the entire dashboard. What is the best method?
Single value tiles are perfect for highlighting KPIs and averages.
Why this answer
Single Value visualizations in Looker allow for displaying an aggregated metric clearly.
Your team wants to visualize BigQuery data in Looker Studio. What is the most efficient way to ensure the dashboard reflects fresh data without manual refreshes?
Direct Query sends every request to BigQuery, ensuring data is as fresh as the underlying table.
Why this answer
Looker Studio supports query caching settings, but for live data, using the 'Direct Query' connection method is best.
You are developing a dashboard in Looker. You notice that the 'Explore' menu is missing a specific set of fields. What should you check in the LookML model?
If fields are not exposed in the Explore definition, they cannot be used.
Why this answer
If fields are defined but not included in the Explore via the 'fields' parameter or 'join' syntax, they will not be visible.
You are identifying trends in a large dataset using BigQuery. Which SQL function is best suited to identify the top 5 products sold per region?
This partitions the data by region and ranks sales, making it easy to filter for the top 5.
Why this answer
Window functions, specifically RANK() or DENSE_RANK() combined with PARTITION BY, are designed for this exact use case.
Which THREE factors should you consider when choosing a partitioning strategy for a BigQuery table?
Query patterns should dictate partition design.
Why this answer
Partitioning should be based on common filters, data size, and the query lifecycle.
What is the benefit of using 'Scheduled Reports' in Looker?
This is a key feature for operationalizing insights.
Why this answer
Scheduled reports automatically deliver data to users via email, ensuring stakeholders get insights without logging in.
A user is running a query on a BigQuery table with nested data (JSON). How do you access a field named 'city' inside a record field named 'address'?
The dot operator is used for accessing nested fields.
Why this answer
Standard SQL uses the dot notation (dot-walk) to access fields within a STRUCT.
A marketing manager needs to see daily sales trends in Looker. The underlying data is in BigQuery and is updated every 6 hours. What is the best way to visualize this?
Explores allow for dynamic, accurate time-series visualization.
Why this answer
Creating a Looker Explore enables the manager to create visualizations dynamically while ensuring they always see the latest data from BigQuery.
You are using Vertex AI Workbench and want to ensure your notebook environment persists after the instance is stopped. Where should you save your work?
Persistent disks retain data even when the VM is stopped.
Why this answer
Notebook instances are compute resources; the persistent disk attached to the instance or an external Cloud Storage bucket is required to keep data.
You are building a Looker dashboard and need to calculate the year-over-year growth rate. Which feature should you use to perform this without modifying the underlying SQL?
Table calculations provide flexible, on-the-fly math capabilities.
Why this answer
Table calculations allow for creating new measures based on existing data in the Explore interface without affecting the underlying database model.
When creating a Looker visualization, which chart type is best for showing the relationship between two numerical variables?
Scatter plots display data points representing two variables.
Why this answer
A scatter plot is the standard chart for observing the correlation or relationship between two numeric axes.
You are creating a Looker report with a 'measure' that calculates the total revenue. You notice it is summing correctly but the format is wrong. Where do you change the format?
This is the standard way to apply currency or numeric formats.
Why this answer
The 'value_format_name' or 'value_format' parameter in the LookML view definition is where you control display formatting.
When reviewing a Looker dashboard, which icon do you click to reload the data?
This triggers a re-query of the underlying data.
Why this answer
Looker dashboards have a refresh icon (circular arrow) that reloads the data based on current cache settings.
You are querying a dataset in BigQuery that uses partitioning. Your query doesn't use the partitioning column. What is the consequence?
This is the default and cost-inefficient behavior.
Why this answer
Without the partition filter, BigQuery performs a full table scan, increasing both cost and execution time.
In LookML, which parameter is used to define how a table should join to another?
This helps Looker understand how to aggregate joined data.
Why this answer
The 'relationship' parameter is essential for Looker to join tables correctly without errors.
You have a Looker dashboard that loads slowly. What is the first thing you should check in the 'Looker System Activity' or 'Query History'?
Understanding execution time and the generated SQL is the first step in troubleshooting.
Why this answer
Checking the query history helps identify if the underlying database is slow or if the Looker model is generating inefficient SQL.
You need to export query results from BigQuery to a Google Sheet. What is the easiest way to do this?
This provides a direct, simple integration.
Why this answer
BigQuery has a built-in 'Save Results' option that allows exporting directly to Google Sheets.
You have a query that processes 500GB of data. You want to reduce the cost of this query. What is the most effective approach?
Limiting the data scanned is the primary cost-saving technique in BigQuery.
Why this answer
Filtering by partition columns drastically reduces the amount of data scanned, directly lowering the cost.
You are writing a Python script in Vertex AI Workbench. You want to query BigQuery and load the result into a pandas DataFrame. Which library should you use?
This is the official client library for BigQuery integration with Python.
Why this answer
The `google-cloud-bigquery` library contains the `to_dataframe()` method which is specifically designed for this.
A data analyst is working in a Vertex AI Workbench notebook. They want to connect to a private BigQuery dataset. How should they authenticate?
Google Cloud handles authentication via service account scopes for managed notebooks.
Why this answer
Vertex AI Workbench notebooks automatically handle authentication using the instance's service account.
You are using Vertex AI Workbench. You want to install a new Python library, `seaborn`, for visualization. What is the correct way to install it in the notebook instance?
The '!' prefix allows running shell commands like pip install.
Why this answer
Using the pip magic command in a cell is the standard way to install libraries in a Jupyter environment.
You are building a Looker model and want to create a measure that calculates the count of distinct customers. Which type of measure should you use?
This is the native LookML way to perform distinct counts.
Why this answer
The `count_distinct` type is specifically designed for calculating unique occurrences in LookML.
You have a dashboard in Looker Studio and you want to allow users to dynamically change the date range without editing the report. What should you add?
This component enables interactive filtering of the report's time dimension.
Why this answer
A 'Date range control' allows end users to filter the entire report by a specific timeframe.
You need to change the color palette of your Looker dashboard charts. Where should you make this change?
Theme/palette settings are defined at the dashboard level.
Why this answer
Dashboard color settings are managed within the dashboard theme settings or the individual chart edit menu.
You are writing a complex BigQuery query and need to define a temporary table to use later in the same query. What is the most efficient syntax?
CTEs are standard, readable, and well-optimized by BigQuery.
Why this answer
Common Table Expressions (CTEs) defined with the WITH clause are the cleanest, most readable way to handle temporary logic.
Ready to test yourself?
Try a timed practice session using only Data Analysis And Presentation questions.