Google Related Exams
Professional-Data-Engineer Exam
The exam covers:
Designing data processing systems
Building and operationalizing data pipelines
Managing data solutions
Ensuring solution quality
Leveraging machine learning models
The Google Professional Data Engineer and Associate Cloud Engineer exams differ mainly in focus, difficulty level, and job roles.
You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics. Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then, the scope of the project has expanded. The database must now store 100 times more patientrecords. You can no longer run the reports, because they either take too long or they encounter errors with insufficient compute resources. How should you adjust the database design?
You have a petabyte of analytics data and need to design a storage and processing platform for it. You must be able to perform data warehouse-style analytics on the data in Google Cloud and expose the dataset as files for batch analysis tools in other cloud providers. What should you do?
You are designing a system that requires an ACID-compliant database. You must ensure that the system requires minimal human intervention in case of a failure. What should you do?