Google Professional-Data-Engineer Exam Questions

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?

Your company has recently grown rapidly and now ingesting data at a significantly higher
rate than it was previously. You manage the daily batch MapReduce analytics jobs in
Apache Hadoop. However, the recent increase in data has meant the batch jobs are falling
behind. You were asked to recommend ways the development team could increase the
responsiveness of the analytics without increasing costs. What should you recommend
they do?

Your company is loading comma-separated values (CSV) files into Google BigQuery. The
data is fully imported successfully; however, the imported data is not matching byte-to-byte
to the source file. What is the most likely cause of this problem?

You work for a large fast food restaurant chain with over 400,000 employees. You store
employee information in Google BigQuery in a Users table consisting of a FirstName field
and a LastName field. A member of IT is building an application and asks you to modify the
schema and data in BigQuery so the application can query a FullName field consisting of
the value of the FirstName field concatenated with a space, followed by the value of the
LastName field for each employee. How can you make that data available while minimizing
cost?

You create a new report for your large team in Google Data Studio 360. The report uses
Google BigQuery as its data source. It is company policy to ensure employees can view
only the data associated with their region, so you create and populate a table for each
region. You need to enforce the regional access policy to the data.
Which two actions should you take? (Choose two.)