MENU
Your organization has been collecting and analyzing data in Google BigQuery for 6 months. The majority of the data analyzed is placed in a time-partitioned table named events_partitioned. To reduce the cost of queries, your organization created a view called events, which queries only the last 14 days of dat
a. The view is described in legacy SQL. Next month, existing applications will be connecting to BigQuery to read the events data via an ODBC connection. You need to ensure the applications can connect. Which two actions should you take? (Choose two.)
Suggested Answer: A, E
Get Premium Professional Data Engineer Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
26 comments · newest first
HA
Haydee
6 months ago
C is good, but D is crucial for authentication.
HI
Hildegarde
6 months ago
But what about C? It could work too.
BR
Brianne
6 months ago
I agree, A makes sense for standard SQL.
PA
Patti
6 months ago
I think A and D are the best options.
SH
Sherrell
6 months ago
I think E) might be overkill for just reading data.
JU
Juan
6 months ago
D) is also important for secure connections!
CR
Cristina
7 months ago
Wait, why do we need a new view? Isn't legacy SQL still supported?
IL
Ilene
7 months ago
Totally agree, standard SQL is the way to go!
GR
Gretchen
7 months ago
A) and C) are the best options here.
LA
Laquanda
7 months ago
Haha, good one Alice! BigQuery wizards are in high demand these days.
MA
Mabel
7 months ago
I'm surprised they didn't include an option to hire a BigQuery wizard to do all this for you. That would be my choice!
OW
Owen
8 months ago
D is a must. You can't connect to BigQuery without proper authentication.
AN
Angelyn
8 months ago
I agree with Adelle. The legacy SQL view won't work with the ODBC connection, so a new standard SQL view is needed.
AD
Adelle
8 months ago
C and D are the correct answers. The view should be created using standard SQL to ensure compatibility with the ODBC connection.
CA
Carissa
8 months ago
I’m a bit confused about the IAM roles. Do we really need to create a specific role for the ODBC connection, or can we just use existing permissions?
PH
Phuong
9 months ago
This question seems similar to one we practiced about views and permissions. I think we might need to create a new view over the partitioned table too.
LA
Lamonica
9 months ago
I'm not entirely sure, but I feel like creating a service account for the ODBC connection is important for authentication.
SH
Sherill
9 months ago
I remember something about legacy SQL and standard SQL compatibility issues. I think we might need to create a new view using standard SQL.
ME
Meaghan
9 months ago
I'm leaning towards creating a new standard SQL view over events. That way, the ODBC connection can use the same logical view as the existing applications, but with the updated SQL syntax.
TY
Ty
9 months ago
Definitely need to set up the service account and IAM role for the ODBC connection. That will ensure the proper authentication and access controls are in place.
LE
Leonora
10 months ago
I think creating a new view over events_partitioned using standard SQL is the way to go. That way, the ODBC connection can access the full dataset, not just the last 14 days.
TO
Toshia
10 months ago
Creating a new partitioned table using standard SQL seems like a good idea to ensure the ODBC connection can access the data. I'll need to research the best way to partition the table to match the existing data.
RE
Reyes
10 months ago
I'm a bit confused about the difference between the legacy SQL view and the standard SQL view. I'll need to review the syntax and requirements for each to determine the best approach.
SH
Shayne
4 months ago
Don't forget about the IAM role too! It's crucial for access.
MI
Mirta
4 months ago
Yeah, but we also need to set up the service account for ODBC.
JE
Jenise
5 months ago
I think creating a new view over events using standard SQL makes sense.