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 have a data pipeline with a Dataflow job that aggregates and writes time series metrics to Bigtable. You notice that data is slow to update in Bigtable. This data feeds a dashboard used by thousands of users across the organization. You need to support additional concurrent users and reduce the amount of time required to write the data. What should you do?
Choose 2 answers
Flowlogistic’s CEO wants to gain rapid insight into their customer base so his sales team can be better informed in the field. This team is not very technical, so they’ve purchased a visualization tool to simplify the creation of BigQuery reports. However, they’ve been overwhelmed by all thedata in the table, and are spending a lot of money on queries trying to find the data they need. You want to solve their problem in the most cost-effective way. What should you do?
What are two methods that can be used to denormalize tables in BigQuery?