A media company uses Tableau to visualize real-time ad impressions stored in BigQuery. The dashboard queries are simple aggregations over the last hour, but users report that the dashboard feels slow, with response times of 3–5 seconds. The team wants sub-second response times without changing the dashboard queries. What should they do?

Increase the slot capacity of the BigQuery reservation.

Enable BigQuery BI Engine on the project and connect Tableau through the BigQuery BI Engine API.

Create a materialized view for each dashboard query.

Move the data to Cloud SQL and connect Tableau to Cloud SQL.

A company uses Tableau Desktop to connect to BigQuery. The data analyst has the BigQuery Data Viewer role on the dataset, but when they try to connect, they get an error that they do not have permission to run queries. What is the most likely cause?

The dataset is not shared with the analyst's Google account.

The analyst's Tableau Desktop is not configured with the correct OAuth client ID.

The analyst lacks the BigQuery Job User role at the project level.

The analyst is connecting to the wrong BigQuery project.

When configuring a Looker connection to BigQuery, which network setting is required to allow Looker to reach BigQuery?

Set up a VPN tunnel to Google Cloud

Configure a firewall rule to allow inbound traffic on port 443

Enable BigQuery API and ensure outbound internet access

A data analyst notices that a BigQuery query that joins two large tables is slow. The query filters on a date column in one table and joins on a common key. The tables are partitioned by date and clustered on the join key. What is the most likely cause of the slow performance?

The query is using a LEFT JOIN instead of an INNER JOIN.

The query is using a subquery instead of a CTE.

The query is not filtering on the partition column in the second table.

The join key is not the same data type in both tables.

Google CloudProfessional Data Engineer

Domain 4Objective 1

4.1 Preparing Data for Visualization PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 4)

Part of the Preparing and using data for analysis domain, which accounts for ~15% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~8–12 in this domain), expect 3–4 from this objective — we provide 24 practice questions to prepare you well beyond it. (estimate)

24questions here

5free pages

7concepts

~15%of the exam

Questions 16–20

16application · medium
A media company uses Tableau to visualize real-time ad impressions stored in BigQuery. The dashboard queries are simple aggregations over the last hour, but users report that the dashboard feels slow, with response times of 3–5 seconds. The team wants sub-second response times without changing the dashboard queries. What should they do?
Select an answer first
17application · medium
A company uses Tableau Desktop to connect to BigQuery. The data analyst has the BigQuery Data Viewer role on the dataset, but when they try to connect, they get an error that they do not have permission to run queries. What is the most likely cause?
Select an answer first
18foundation · easy
When configuring a Looker connection to BigQuery, which network setting is required to allow Looker to reach BigQuery?
Select an answer first
19foundation · easy
Which IAM role provides read-only access to BigQuery data, suitable for a data analyst who needs to run queries but not modify data?
Select an answer first
20application · medium
A data analyst notices that a BigQuery query that joins two large tables is slow. The query filters on a date column in one table and joins on a common key. The tables are partitioned by date and clustered on the join key. What is the most likely cause of the slow performance?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

4.1 Preparing Data for Visualization PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 4)

Questions 16–20

A company uses Tableau Desktop to connect to BigQuery. The data analyst has the BigQuery Data Viewer role on the dataset, but when they try to connect, they get an error that they do not have permission to run queries. What is the most likely cause?

When configuring a Looker connection to BigQuery, which network setting is required to allow Looker to reach BigQuery?

Which IAM role provides read-only access to BigQuery data, suitable for a data analyst who needs to run queries but not modify data?

A data analyst notices that a BigQuery query that joins two large tables is slow. The query filters on a date column in one table and joins on a common key. The tables are partitioned by date and clustered on the join key. What is the most likely cause of the slow performance?

Keep studying — Preparing and using data for analysis