Professional-Data-Engineer Exam Dumps | You work for a large fast food restaurant chain with over 400,000 employees. You store employee information

<< Prev Question Next Question >>

Question 7/29

You work for a large fast food restaurant chain with over 400,000 employees. You store employee information in Google BigQuery in a Userstable consisting of a FirstNamefield and a LastNamefield. 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 FullNamefield consisting of the value of the FirstNamefield concatenated with a space, followed by the value of the LastNamefield for each employee. How can you make that data available while minimizing cost?

A. Add a new column called FullNameto the Users table. Run an UPDATEstatement that updates the FullNamecolumn for each user with the concatenation of the FirstNameand LastNamevalues.

B. Use 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 the proper values for FirstName, LastNameand FullName. Run a BigQuery load job to load the new CSV file into BigQuery.

C. Create a Google Cloud Dataflow job that queries BigQuery for the entire Userstable, concatenates the FirstNamevalue and LastNamevalue for each user, and loads the proper values for FirstName, LastName, and FullNameinto a new table in BigQuery.

D. Create a view in BigQuery that concatenates the FirstNameand LastNamefield values to produce the FullName.

Question 7/29

LEAVE A REPLY

Download PDF File