Google
PROFESSIONAL-DATA-ENGINEER · Question #46
PROFESSIONAL-DATA-ENGINEER Question #46: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #46. The question stem and answer options stay visible for context.
Submitted by kim_seoul· Mar 30, 2026
Question
You work for a large fast food restaurant chain with over 400,000 employees. You store employee information in Google BigQuery in a Users table consisting of a FirstName field and a LastName field. A member of IT is building an application and asks you to modify the schema and data in BigQuery so the application can query a FullName field consisting of the value of the FirstName field concatenated with a space, followed by the value of the LastName field for each employee. How can you make that data available while minimizing cost?
Options
- ACreate a view in BigQuery that concatenates the FirstName and LastName field values to produce the FullName.
- BAdd a new column called FullName to the Users table. Run an UPDATE statement that updates the FullName column for each user with the concatenation of
- CCreate a Google Cloud Dataflow job that queries BigQuery for the entire Users table, concatenates the FirstName value and LastName value for each user,
- DUse BigQuery to export the data for the table to a CSV file. Create a Google Cloud Dataproc job to process the CSV file and output a new CSV file containing
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.