Free Preparation Discussions
MENU
Google Professional Data Engineer Exam - Topic 2 Question 93 Discussion
Topic #: 2
When creating a new Cloud Dataproc cluster with the projects.regions.clusters.create operation, these four values are required: project, region, name, and ____.
To improve the performance of querying a large BigQuery table with filters on countryname and username, clustering the table by these fields is the most effective approach. Here's why option C is the best choice:
Clustering in BigQuery:
Clustering organizes data based on the values in specified columns. This can significantly improve query performance by reducing the amount of data scanned during query execution.
Clustering by countryname and username means that data is physically sorted and stored together based on these fields, allowing BigQuery to quickly locate and read only the relevant data for queries using these filters.
Filter Efficiency:
With the table clustered by countryname and username, queries that filter on these columns can benefit from efficient data retrieval, reducing the amount of data processed and speeding up query execution.
This directly addresses the performance issue of the dashboard queries that apply filters on these fields.
Steps to Implement:
Redesign the Table:
Create a new table with clustering on countryname and username:
CREATE TABLE project.dataset.new_table
CLUSTER BY countryname, username AS
SELECT * FROM project.dataset.customer_order;
Migrate Data:
Transfer the existing data from the original table to the new clustered table.
Update Queries:
Modify the dashboard queries to reference the new clustered table.
BigQuery Clustering Documentation
Optimizing Query Performance
Virgie
4 months agoJoye
4 months agoDolores
4 months agoChrista
5 months agoJennie
5 months agoFiliberto
5 months agoZona
5 months agoAnnamae
5 months agoCharlie
6 months agoArlean
6 months agoLeah
6 months agoEden
6 months agoWendell
6 months agoVeta
6 months agoPolly
10 months agoNobuko
9 months agoJennie
9 months agoCassie
9 months agoTiera
9 months agoBettina
10 months agoSimona
10 months agoDyan
10 months agoDomonique
11 months agoErnest
9 months agoTasia
10 months agoDenny
10 months agoSusana
11 months agoLavonne
10 months agoCyril
10 months agoMila
10 months agoMakeda
11 months agoAleta
10 months agoEric
11 months agoEstrella
11 months agoHerschel
11 months agoClorinda
11 months agoGabriele
10 months agoHoward
11 months agoLouis
12 months agoDexter
12 months agoEric
12 months ago