Google Certified Professional Data Engineer - Professional-Data-Engineer 模擬練習
Which of these numbers are adjusted by a neural network as it learns from a training dataset (select 2 answers)?
正解: A,C
解説: (PassTest メンバーにのみ表示されます)
Your company has data assets across multiple Cloud Storage buckets and BigQuery datasets containing raw and processed data. The requirement is to establish a unified data governance framework that allows for centralized metadata discovery, data quality monitoring, and consistent security policy application across these various data stores without physically moving or duplicating the data. You need to implement a solution to achieve this federated governance.
What should you do?
What should you do?
正解: D
解説: (PassTest メンバーにのみ表示されます)
Which of these is NOT a way to customize the software on Dataproc cluster instances?
正解: C
解説: (PassTest メンバーにのみ表示されます)
A web server sends click events to a Pub/Sub topic as messages. The web server includes an eventTimestamp attribute in the messages, which is the time when the click occurred. You have a Dataflow streaming job that reads from this Pub/Sub topic through a subscription, applies some transformations, and writes the result to another Pub/Sub topic for use by the advertising department. The advertising department needs to receive each message within 30 seconds of the corresponding click occurrence, but they report receiving the messages late. Your Dataflow job's system lag is about 5 seconds, and the data freshness is about 40 seconds. Inspecting a few messages show no more than 1 second lag between their eventTimestamp and publishTime.
What is the problem and what should you do?
What is the problem and what should you do?
正解: C
You are part of a healthcare organization where data is organized and managed by respective data owners in various storage services. As a result of this decentralized ecosystem, discovering and managing data has become difficult. You need to quickly identify and implement a cost- optimized solution to assist your organization with the following:
- Data management and discovery
- Data lineage tracking
- Data quality validation
How should you build the solution?
- Data management and discovery
- Data lineage tracking
- Data quality validation
How should you build the solution?
正解: C
You are using BigQuery and Data Studio to design a customer-facing dashboard that displays large quantities of aggregated data. You expect a high volume of concurrent users. You need to optimize the dashboard to provide quick visualizations with minimal latency. What should you do?
正解: B
解説: (PassTest メンバーにのみ表示されます)
You are building a new application that you need to collect data from in a scalable way. Data arrives continuously from the application throughout the day, and you expect to generate approximately 150 GB of JSON data per day by the end of the year. Your requirements are:
- Decoupling producer from consumer
- Space and cost-efficient storage of the raw ingested data, which is
to be stored indefinitely
- Near real-time SQL query
- Maintain at least 2 years of historical data, which will be queried
with SQL
Which pipeline should you use to meet these requirements?
- Decoupling producer from consumer
- Space and cost-efficient storage of the raw ingested data, which is
to be stored indefinitely
- Near real-time SQL query
- Maintain at least 2 years of historical data, which will be queried
with SQL
Which pipeline should you use to meet these requirements?
正解: D
You have several different file type data sources, such as Apache Parquet and CSV. You want to store the data in Cloud Storage. You need to set up an object sink for your data that allows you to use your own encryption keys. You want to use a GUI-based solution. What should you do?
正解: B