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.
Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?
You have a BigQuery dataset named "customers". All tables will be tagged by using a Data Catalog tag template named "gdpr". The template contains one mandatory field, "has sensitive data~. with a boolean value. All employees must be able to do a simple search and find tables in the dataset that have either true or false in the "has sensitive data" field. However, only the Human Resources (HR) group should be able to see the data inside the tables for which "hass-ensitive-data" is true. You give the all employees group the bigquery.metadataViewer and bigquery.connectionUser roles on the dataset. You want to minimize configuration overhead. What should you do next?
Your company’s customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations. The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations. What should you do?