PROFESSIONAL-DATA-ENGINEER · Question #138
PROFESSIONAL-DATA-ENGINEER Question #138: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #138. The question stem and answer options stay visible for context.
Question
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 data. 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.)
Options
- ACreate a new view over events using standard SQL
- BCreate a new partitioned table using a standard SQL query
- CCreate a new view over events_partitioned using standard SQL
- DCreate a service account for the ODBC connection to use for authentication
- ECreate a Google Cloud Identity and Access Management (Cloud IAM) role for the ODBC connection and shared "events"
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.