Topic 1 Question 43
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?
Create a view in BigQuery that concatenates the FirstName and LastName field values to produce the FullName.
Add 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 the FirstName and LastName values.
Create a Google Cloud Dataflow job that queries BigQuery for the entire Users table, concatenates the FirstName value and LastName value for each user, and loads the proper values for FirstName, LastName, and FullName into a new table in BigQuery.
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, LastName and FullName. Run a BigQuery load job to load the new CSV file into BigQuery.
ユーザの投票
コメント(17)
Answer will be A because when you create View it does not store extra space and its a logical representation, for rest of the option you need to write large code and extra processing for dataflow/dataproc
👍 62[Removed]2020/03/22Correct: B BigQuery has no quota on the DML statements. (Search Google - does bigquery have quota for update). Why not C: This is a one time activity and SQL is the easiest way to program it. DataFlow is way overkill for this. You will need to find an engineer who can develop DataFlow pipelines. Whereas, SQL is so much more widely known and easier. One of the great features about BigQuery is its SQL interface. Even for BigQueryML services.
👍 44BhupiSG2021/03/12- 正解だと思う選択肢: A
A. Create a view in BigQuery that concatenates the FirstName and LastName field values to produce the FullName. This approach allows the IT member to query the FullName field without modifying the existing Users table, and it also doesn't require any additional storage or data processing costs.
B. Adding a new column called FullName to the Users table and running an update statement also will work, but it will require additional storage and cost for the new column and also the cost of running the update statement.
👍 2PolyMoe2023/01/26
シャッフルモード