Google Professional-Data-Engineer 問題集

質問 1：
When you design a Google Cloud Bigtable schema it is recommended that you _________.
A. Avoid schema designs that require atomicity across rows
B. Create schema designs that are based on a relational database design
C. Avoid schema designs that are based on NoSQL concepts
D. Create schema designs that require atomicity across rows
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
You need to store and analyze social media postings in Google BigQuery at a rate of 10,000 messages per minute in near real-time. Initially, design the application to use streaming inserts for individual postings. Your application also performs data aggregations right after the streaming inserts. You discover that the queries after streaming inserts do not exhibit strong consistency, and reports from the queries might miss in-flight dat a. How can you adjust your application design?
A. Convert the streaming insert code to batch load for individual messages.
B. Re-write the application to load accumulated data every 2 minutes.
C. Load the original message to Google Cloud SQL, and export the table every hour to BigQuery via streaming inserts.
D. Estimate the average latency for data availability after streaming inserts, and always run queries after waiting twice as long.
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You need to create a near real-time inventory dashboard that reads the main inventory tables in your BigQuery data warehouse. Historical inventory data is stored as inventory balances by item and location. You have several thousand updates to inventory every hour. You want to maximize performance of the dashboard and ensure that the data is accurate. What should you do?
A. Use the BigQuery streaming the stream changes into a daily inventory movement table. Calculate balances in a view that joins it to the historical inventory balance table. Update the inventory balance table nightly.
B. Leverage BigQuery UPDATE statements to update the inventory balances as they are changing.
C. Use the BigQuery bulk loader to batch load inventory changes into a daily inventory movement table. Calculate balances in a view that joins it to the historical inventory balance table. Update the inventory balance table nightly.
D. Partition the inventory balance table by item to reduce the amount of data scanned with each inventory update.
正解：B

質問 4：
Each analytics team in your organization is running BigQuery jobs in their own projects. You want to enable each team to monitor slot usage within their projects. What should you do?
A. Create a log export for each project, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric
B. Create an aggregated log export at the organization level, capture the BigQuery job execution logs, create a custom metric based on the totalSlotMs, and create a Stackdriver Monitoring dashboard based on the custom metric
C. Create a Stackdriver Monitoring dashboard based on the BigQuery metric query/scanned_bytes
D. Create a Stackdriver Monitoring dashboard based on the BigQuery metric slots/allocated_for_project
正解：B

質問 5：
You need to set access to BigQuery for different departments within your company. Your solution should comply with the following requirements:
Each department should have access only to their data.
Each department will have one or more leads who need to be able to create and update tables and provide them to their team.
Each department has data analysts who need to be able to query but not modify data.
How should you set access to the data in BigQuery?
A. Create a dataset for each department. Assign the department leads the role of OWNER, and assign the data analysts the role of WRITER on their dataset.
B. Create a table for each department. Assign the department leads the role of Owner, and assign the data analysts the role of Editor on the project the table is in.
C. Create a table for each department. Assign the department leads the role of Editor, and assign the data analysts the role of Viewer on the project the table is in.
D. Create a dataset for each department. Assign the department leads the role of WRITER, and assign the data analysts the role of READER on their dataset.
正解：C