Free Google Professional Data Engineer Actual Exam Questions - Question 4 Discussion
Question No. 4
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?
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?
Select one option, then reveal solution.
US
RA
Ravi A.
2026-02-18
A/B? I’m thinking B adds unnecessary storage and update costs for something that can be done on the fly with a view, so A feels more cost-effective unless the app just can’t use views at all.
0
AZ
Ash Z.
2026-01-18
Adding a FullName column like in B feels unnecessary since it duplicates data and increases storage costs. A view in A keeps data normalized and avoids extra storage charges.
0
AZ
Ash Z.
2026-01-15
Probably A. Views don’t store extra data, so it’s cheaper than adding a column or running jobs like in B, C, or D. B looks tempting but updating 400,000 rows might cost more.
0