Professional Data Engineer exam

You work for a manufacturing plant that batches application log files together into a single log file once a day at 2:00 AM. You have written a Google Cloud Dataflow job to process that log file. You need to make sure the log file in processed once per day as...

You create an important report for your large team in Google Data Studio 360. The report uses Google BigQuery as its data source. You notice that visualizations are not showing data that is less than 1 hour old. What should you do?A . Disable caching by editing the report settings.B...

Given the record streams MJTelco is interested in ingesting per day, they are concerned about the cost of Google BigQuery increasing. MJTelco asks you to provide a design solution. They require a single large data table called tracking_table. Additionally, they want to minimize the cost of daily queries while performing...

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...

Which of these statements about BigQuery caching is true?A . By default, a query's results are not cached.B . BigQuery caches query results for 48 hours.C . Query results are cached even if you specify a destination table.D . There is no charge for a query that retrieves its results...

Your company is performing data preprocessing for a learning algorithm in Google Cloud Dataflow. Numerous data logs are being are being generated during this step, and the team wants to analyze them. Due to the dynamic nature of the campaign, the data is growing exponentially every hour. The data scientists...

Which of the following statements about the Wide & Deep Learning model are true? (Select 2 answers.)A . The wide model is used for memorization, while the deep model is used for generalization.B . A good use for the wide and deep model is a recommender system.C . The wide...

Your startup has never implemented a formal security policy. Currently, everyone in the company has access to the datasets stored in Google BigQuery. Teams have freedom to use the service as they see fit, and they have not documented their use cases. You have been asked to secure the data...

You need to compose visualizations for operations teams with the following requirements: Which approach meets the requirements?A . Load the data into Google Sheets, use formulas to calculate a metric, and use filters/sorting to show only suboptimal links in a table.B . Load the data into Google BigQuery tables, write...

Which of the following statements about Legacy SQL and Standard SQL is not true?A . Standard SQL is the preferred query language for BigQuery.B . If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQD . One difference...