Online Access Free Professional-Data-Engineer Exam Questions

You are designing a Dataflow pipeline for a batch processing job. You want to mitigate multiple zonal failures at job submission time. What should you do?

• A.Submit duplicate pipelines in two different zones by using the --zone flag.
• B.Specify a worker region by using the --region flag.
• C.Set the pipeline staging location as a regional Cloud Storage bucket.
• D.Create an Eventarc trigger to resubmit the job in case of zonal failure when submitting the job.

You are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat. Here is some of the information you need to store:
- The user profile: What the user likes and doesn't like to eat
- The user account information: Name, address, preferred meal times
- The order information: When orders are made, from where, to whom
The database will be used to store all the transactional data of the product. You want to optimize the data schema. Which Google Cloud Platform product should you use?

• A.Cloud SQL
• B.Cloud Bigtable
• C.BigQuery
• D.Cloud Datastore

You are working on a sensitive project involving private user data. You have set up a project on Google Cloud Platform to house your work internally. An external consultant is going to assist with coding a complex transformation in a Google Cloud Dataflow pipeline for your project. How should you maintain users' privacy?

• A.Grant the consultant the Viewer role on the project.
• B.Create a service account and allow the consultant to log on with it.
• C.Grant the consultant the Cloud Dataflow Developer role on the project.
• D.Create an anonymized sample of the data for the consultant to work with in a different project.

Your company handles data processing for a number of different clients. Each client prefers to use their own suite of analytics tools, with some allowing direct query access via Google BigQuery. You need to secure the data so that clients cannot see each other's data. You want to ensure appropriate access to the data. Which three steps should you take? (Choose three.)

• A.Put each client's BigQuery dataset into a different table.
• B.Load data into different partitions.
• C.Load data into a different dataset for each client.
• D.Only allow a service account to access the datasets.
• E.Use the appropriate identity and access management (IAM) roles for each client's users.
• F.Restrict a client's dataset to approved users.

You are architecting a data transformation solution for BigQuery. Your developers are proficient with SQL and want to use the ELT development technique. In addition, your developers need an intuitive coding environment and the ability to manage SQL as code. You need to identify a solution for your developers to build these pipelines. What should you do?

• A.Use Dataflow jobs to read data from Pub/Sub, transform the data, and load the data to BigQuery.
• B.Use Dataform to build, manage, and schedule SQL pipelines.
• C.Use Cloud Composer to load data and run SQL pipelines by using the BigQuery job operators.
• D.Use Data Fusion to build and execute ETL pipelines.