[Sep-2021] Professional-Data-Engineer Pre-Exam Practice Tests | Exam Questions and Answers for Google Cloud Certified Study Guide
Google Certified Professional Data Engineer Exam Certification Sample Questions
NEW QUESTION 99
You want to process payment transactions in a point-of-sale application that will run on Google Cloud Platform.
Your user base could grow exponentially, but you do not want to manage infrastructure scaling.
Which Google database service should you use?
- A. Cloud Datastore
- B. Cloud Bigtable
- C. BigQuery
- D. Cloud SQL
Answer: D
NEW QUESTION 100
Which is the preferred method to use to avoid hotspotting in time series data in Bigtable?
- A. Field promotion
- B. Hashing
- C. Salting
- D. Randomization
Answer: A
Explanation:
By default, prefer field promotion. Field promotion avoids hotspotting in almost all cases, and it tends to make it easier to design a row key that facilitates queries.
Reference: https://cloud.google.com/bigtable/docs/schema-design-time-
series#ensure_that_your_row_key_avoids_hotspotting
NEW QUESTION 101
When you store data in Cloud Bigtable, what is the recommended minimum amount of stored data?
- A. 1 GB
- B. 1 TB
- C. 500 GB
- D. 500 TB
Answer: B
Explanation:
Cloud Bigtable is not a relational database. It does not support SQL queries, joins, or multi- row transactions. It is not a good solution for less than 1 TB of data.
Reference:
https://cloud.google.com/bigtable/docs/overview#title_short_and_other_storage_options
NEW QUESTION 102
How would you query specific partitions in a BigQuery table?
- A. Use the EXTRACT(DAY) clause
- B. Use the __PARTITIONTIME pseudo-column in the WHERE clause
- C. Use the DAY column in the WHERE clause
- D. Use DATE BETWEEN in the WHERE clause
Answer: B
Explanation:
Partitioned tables include a pseudo column named _PARTITIONTIME that contains a date-based timestamp for data loaded into the table. To limit a query to particular partitions (such as Jan 1st and 2nd of
2017), use a clause similar to this:
WHERE _PARTITIONTIME BETWEEN TIMESTAMP('2017-01-01') AND TIMESTAMP('2017-01-02') Reference: https://cloud.google.com/bigquery/docs/partitioned-tables#the_partitiontime_pseudo_column
NEW QUESTION 103
You are deploying a new storage system for your mobile application, which is a media streaming service.
You decide the best fit is Google Cloud Datastore. You have entities with multiple properties, some of which can take on multiple values. For example, in the entity 'Movie'the property 'actors'and the property 'tags' have multiple values but the property 'date released' does not. A typical query would ask for all movies with actor=<actorname>ordered by date_releasedor all movies with tag=Comedyordered by date_released. How should you avoid a combinatorial explosion in the number of indexes?
- A. Manually configure the index in your index config as follows:

- B. Set the following in your entity options: exclude_from_indexes = 'actors, tags'
- C. Set the following in your entity options: exclude_from_indexes = 'date_published'
- D. Manually configure the index in your index config as follows:

Answer: A
NEW QUESTION 104
Your company is migrating their 30-node Apache Hadoop cluster to the cloud. They want to re-use
Hadoop jobs they have already created and minimize the management of the cluster as much as possible.
They also want to be able to persist data beyond the life of the cluster. What should you do?
- A. Create a Cloud Dataproc cluster that uses the Google Cloud Storage connector.
- B. Create a Hadoop cluster on Google Compute Engine that uses persistent disks.
- C. Create a Google Cloud Dataflow job to process the data.
- D. Create a Hadoop cluster on Google Compute Engine that uses Local SSD disks.
- E. Create a Google Cloud Dataproc cluster that uses persistent disks for HDFS.
Answer: C
NEW QUESTION 105
You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application's interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?
- A. Create a service account and grant dataset access to that account. Use the service account's private key to access the dataset
- B. Create a dummy user and grant dataset access to that user. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset
- C. Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request
- D. Create groups for your users and give those groups access to the dataset
Answer: A
NEW QUESTION 106
What are two of the benefits of using denormalized data structures in BigQuery?
- A. Reduces the amount of data processed, reduces the amount of storage required
- B. Increases query speed, makes queries simpler
- C. Reduces the amount of data processed, increases query speed
- D. Reduces the amount of storage required, increases query speed
Answer: B
Explanation:
Denormalization increases query speed for tables with billions of rows because BigQuery's performance degrades when doing JOINs on large tables, but with a denormalized data structure, you don't have to use JOINs, since all of the data has been combined into one table. Denormalization also makes queries simpler because you do not have to use JOIN clauses.
Denormalization increases the amount of data processed and the amount of storage required because it creates redundant data.
Reference:
https://cloud.google.com/solutions/bigquery-data-warehouse#denormalizing_data
NEW QUESTION 107
Case Study: 1 - Flowlogistic
Company Overview
Flowlogistic is a leading logistics and supply chain provider. They help businesses throughout the world manage their resources and transport them to their final destination. The company has grown rapidly, expanding their offerings to include rail, truck, aircraft, and oceanic shipping.
Company Background
The company started as a regional trucking company, and then expanded into other logistics market.
Because they have not updated their infrastructure, managing and tracking orders and shipments has become a bottleneck. To improve operations, Flowlogistic developed proprietary technology for tracking shipments in real time at the parcel level. However, they are unable to deploy it because their technology stack, based on Apache Kafka, cannot support the processing volume. In addition, Flowlogistic wants to further analyze their orders and shipments to determine how best to deploy their resources.
Solution Concept
Flowlogistic wants to implement two concepts using the cloud:
Use their proprietary technology in a real-time inventory-tracking system that indicates the location of their loads Perform analytics on all their orders and shipment logs, which contain both structured and unstructured data, to determine how best to deploy resources, which markets to expand info. They also want to use predictive analytics to learn earlier when a shipment will be delayed.
Existing Technical Environment
Flowlogistic architecture resides in a single data center:
Databases
8 physical servers in 2 clusters
SQL Server - user data, inventory, static data
3 physical servers
Cassandra - metadata, tracking messages
10 Kafka servers - tracking message aggregation and batch insert
Application servers - customer front end, middleware for order/customs 60 virtual machines across 20 physical servers Tomcat - Java services Nginx - static content Batch servers Storage appliances iSCSI for virtual machine (VM) hosts Fibre Channel storage area network (FC SAN) ?SQL server storage Network-attached storage (NAS) image storage, logs, backups Apache Hadoop /Spark servers Core Data Lake Data analysis workloads
20 miscellaneous servers
Jenkins, monitoring, bastion hosts,
Business Requirements
Build a reliable and reproducible environment with scaled panty of production. Aggregate data in a centralized Data Lake for analysis Use historical data to perform predictive analytics on future shipments Accurately track every shipment worldwide using proprietary technology Improve business agility and speed of innovation through rapid provisioning of new resources Analyze and optimize architecture for performance in the cloud Migrate fully to the cloud if all other requirements are met Technical Requirements Handle both streaming and batch data Migrate existing Hadoop workloads Ensure architecture is scalable and elastic to meet the changing demands of the company.
Use managed services whenever possible
Encrypt data flight and at rest
Connect a VPN between the production data center and cloud environment SEO Statement We have grown so quickly that our inability to upgrade our infrastructure is really hampering further growth and efficiency. We are efficient at moving shipments around the world, but we are inefficient at moving data around.
We need to organize our information so we can more easily understand where our customers are and what they are shipping.
CTO Statement
IT has never been a priority for us, so as our data has grown, we have not invested enough in our technology. I have a good staff to manage IT, but they are so busy managing our infrastructure that I cannot get them to do the things that really matter, such as organizing our data, building the analytics, and figuring out how to implement the CFO' s tracking technology.
CFO Statement
Part of our competitive advantage is that we penalize ourselves for late shipments and deliveries. Knowing where out shipments are at all times has a direct correlation to our bottom line and profitability.
Additionally, I don't want to commit capital to building out a server environment.
Flowlogistic wants to use Google BigQuery as their primary analysis system, but they still have Apache Hadoop and Spark workloads that they cannot move to BigQuery. Flowlogistic does not know how to store the data that is common to both workloads. What should they do?
- A. Store the common data in BigQuery and expose authorized views.
- B. Store the common data encoded as Avro in Google Cloud Storage.
- C. Store he common data in the HDFS storage for a Google Cloud Dataproc cluster.
- D. Store the common data in BigQuery as partitioned tables.
Answer: A
NEW QUESTION 108
Your company is streaming real-time sensor data from their factory floor into Bigtable and they have
noticed extremely poor performance. How should the row key be redesigned to improve Bigtable
performance on queries that populate real-time dashboards?
- A. Use a row key of the form <timestamp>#<sensorid>.
- B. Use a row key of the form >#<sensorid>#<timestamp>.
- C. Use a row key of the form <timestamp>.
- D. Use a row key of the form <sensorid>.
Answer: C
NEW QUESTION 109
You're training a model to predict housing prices based on an available dataset with real estate properties.
Your plan is to train a fully connected neural net, and you've discovered that the dataset contains latitude and longtitude of the property. Real estate professionals have told you that the location of the property is highly influential on price, so you'd like to engineer a feature that incorporates this physical dependency.
What should you do?
- A. Create a feature cross of latitude and longtitude, bucketize at the minute level and use L1 regularization during optimization.
- B. Create a feature cross of latitude and longtitude, bucketize it at the minute level and use L2 regularization during optimization.
- C. Create a numeric column from a feature cross of latitude and longtitude.
- D. Provide latitude and longtitude as input vectors to your neural net.
Answer: C
Explanation:
Explanation
Reference https://cloud.google.com/bigquery/docs/gis-data
NEW QUESTION 110
Which of the following statements is NOT true regarding Bigtable access roles?
- A. You can configure access control only at the project level.
- B. To give a user access to only one table in a project, grant the user the Bigtable Editor role for that table.
- C. To give a user access to only one table in a project, you must configure access through your application.
- D. Using IAM roles, you cannot give a user access to only one table in a project, rather than all tables in a project.
Answer: B
Explanation:
Explanation
For Cloud Bigtable, you can configure access control at the project level. For example, you can grant the ability to:
Read from, but not write to, any table within the project.
Read from and write to any table within the project, but not manage instances.
Read from and write to any table within the project, and manage instances.
Reference: https://cloud.google.com/bigtable/docs/access-control
NEW QUESTION 111
Your company is running their first dynamic campaign, serving different offers by analyzing real-time data during the holiday season. The data scientists are collecting terabytes of data that rapidly grows every hour during their 30-day campaign. They are using Google Cloud Dataflow to preprocess the data and collect the feature (signals) data that is needed for the machine learning model in Google Cloud Bigtable. The team is observing suboptimal performance with reads and writes of their initial load of 10 TB of data. They want to improve this performance while minimizing cost. What should they do?
- A. Redesign the schema to use a single row key to identify values that need to be updated frequently in the cluster.
- B. Redesign the schema to use row keys based on numeric IDs that increase sequentially per user viewing the offers.
- C. The performance issue should be resolved over time as the site of the BigDate cluster is increased.
- D. Redefine the schema by evenly distributing reads and writes across the row space of the table.
Answer: D
NEW QUESTION 112
You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query - -dry_run you learn that the query triggers a full scan of the table, even though the filter on timestamp and ID select a tiny fraction of the overall data. You want to reduce the amount of data scanned by BigQuery with minimal changes to existing SQL queries. What should you do?
- A. Recreate the table with a partitioning column and clustering column.
- B. Use the LIMIT keyword to reduce the number of rows returned.
- C. Create a separate table for each ID.
- D. Use the bq query - -maximum_bytes_billed flag to restrict the number of bytes billed.
Answer: B
NEW QUESTION 113
What are two of the benefits of using denormalized data structures in BigQuery?
- A. Reduces the amount of data processed, reduces the amount of storage required
- B. Increases query speed, makes queries simpler
- C. Reduces the amount of data processed, increases query speed
- D. Reduces the amount of storage required, increases query speed
Answer: B
Explanation:
Denormalization increases query speed for tables with billions of rows because BigQuery's performance degrades when doing JOINs on large tables, but with a denormalized data structure, you don't have to use JOINs, since all of the data has been combined into one table. Denormalization also makes queries simpler because you do not have to use JOIN clauses. Denormalization increases the amount of data processed and the amount of storage required because it creates redundant data.
Reference:
https://cloud.google.com/solutions/bigquery-data-warehouse#denormalizing_data
NEW QUESTION 114
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 Datastore
- B. BigQuery
- C. Cloud Bigtable
- D. Cloud SQL
Answer: B
NEW QUESTION 115
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. One difference between the two query languages is how you specify fully-qualified table names (i.e.
table names that include their associated project name). - C. If you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
- D. You need to set a query language for each dataset and the default is Standard SQL.
Answer: D
Explanation:
You do not set a query language for each dataset. It is set each time you run a query and the default query language is Legacy SQL.
Standard SQL has been the preferred query language since BigQuery 2.0 was released. In legacy SQL, to query a table with a project-qualified name, you use a colon, :, as a separator. In standard SQL, you use a period, ., instead.
Due to the differences in syntax between the two query languages (such as with project-qualified table names), if you write a query in Legacy SQL, it might generate an error if you try to run it with Standard SQL.
Reference:
https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy-sql
NEW QUESTION 116
Which of these is not a supported method of putting data into a partitioned table?
- A. If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.
- B. Create a partitioned table and stream new records to it every day.
- C. Use ORDER BY to put a table's rows into chronological order and then change the table's type to
"Partitioned". - D. Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".
Answer: C
Explanation:
You cannot change an existing table into a partitioned table. You must create a partitioned table from scratch. Then you can either stream data into it every day and the data will automatically be put in the right partition, or you can load data into a specific partition by using "$YYYYMMDD" at the end of the table name.
Reference: https://cloud.google.com/bigquery/docs/partitioned-tables
NEW QUESTION 117
You need to copy millions of sensitive patient records from a relational database to BigQuery. The total size of the database is 10 TB. You need to design a solution that is secure and time-efficient. What should you do?
- A. Export the records from the database as an Avro file. Upload the file to GCS using gsutil, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
- B. Export the records from the database as an Avro file. Create a public URL for the Avro file, and then use Storage Transfer Service to move the file to Cloud Storage. Load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
- C. Export the records from the database as an Avro file. Copy the file onto a Transfer Appliance and send it to Google, and then load the Avro file into BigQuery using the BigQuery web UI in the GCP Console.
- D. Export the records from the database into a CSV file. Create a public URL for the CSV file, and then use Storage Transfer Service to move the file to Cloud Storage. Load the CSV file into BigQuery using the BigQuery web UI in the GCP Console.
Answer: A
Explanation:
Google recommends that enterprises use Transfer Appliance in cases where it would take them over a week to upload data to the cloud via the internet, or when an enterprise needs to migrate over 60 TB of data.
NEW QUESTION 118
Case Study 1 - Flowlogistic
Company Overview
Flowlogistic is a leading logistics and supply chain provider. They help businesses throughout the world manage their resources and transport them to their final destination. The company has grown rapidly, expanding their offerings to include rail, truck, aircraft, and oceanic shipping.
Company Background
The company started as a regional trucking company, and then expanded into other logistics market.
Because they have not updated their infrastructure, managing and tracking orders and shipments has become a bottleneck. To improve operations, Flowlogistic developed proprietary technology for tracking shipments in real time at the parcel level. However, they are unable to deploy it because their technology stack, based on Apache Kafka, cannot support the processing volume. In addition, Flowlogistic wants to further analyze their orders and shipments to determine how best to deploy their resources.
Solution Concept
Flowlogistic wants to implement two concepts using the cloud:
* Use their proprietary technology in a real-time inventory-tracking system that indicates the location of their loads
* Perform analytics on all their orders and shipment logs, which contain both structured and unstructured data, to determine how best to deploy resources, which markets to expand info. They also want to use predictive analytics to learn earlier when a shipment will be delayed.
Existing Technical Environment
Flowlogistic architecture resides in a single data center:
* Databases
8 physical servers in 2 clusters
- SQL Server - user data, inventory, static data
3 physical servers
- Cassandra - metadata, tracking messages
10 Kafka servers - tracking message aggregation and batch insert
* Application servers - customer front end, middleware for order/customs
60 virtual machines across 20 physical servers
- Tomcat - Java services
- Nginx - static content
- Batch servers
* Storage appliances
- iSCSI for virtual machine (VM) hosts
- Fibre Channel storage area network (FC SAN) - SQL server storage
- Network-attached storage (NAS) image storage, logs, backups
* 10 Apache Hadoop /Spark servers
- Core Data Lake
- Data analysis workloads
* 20 miscellaneous servers
- Jenkins, monitoring, bastion hosts,
Business Requirements
* Build a reliable and reproducible environment with scaled panty of production.
* Aggregate data in a centralized Data Lake for analysis
* Use historical data to perform predictive analytics on future shipments
* Accurately track every shipment worldwide using proprietary technology
* Improve business agility and speed of innovation through rapid provisioning of new resources
* Analyze and optimize architecture for performance in the cloud
* Migrate fully to the cloud if all other requirements are met
Technical Requirements
* Handle both streaming and batch data
* Migrate existing Hadoop workloads
* Ensure architecture is scalable and elastic to meet the changing demands of the company.
* Use managed services whenever possible
* Encrypt data flight and at rest
* Connect a VPN between the production data center and cloud environment SEO Statement We have grown so quickly that our inability to upgrade our infrastructure is really hampering further growth and efficiency. We are efficient at moving shipments around the world, but we are inefficient at moving data around.
We need to organize our information so we can more easily understand where our customers are and what they are shipping.
CTO Statement
IT has never been a priority for us, so as our data has grown, we have not invested enough in our technology. I have a good staff to manage IT, but they are so busy managing our infrastructure that I cannot get them to do the things that really matter, such as organizing our data, building the analytics, and figuring out how to implement the CFO' s tracking technology.
CFO Statement
Part of our competitive advantage is that we penalize ourselves for late shipments and deliveries. Knowing where out shipments are at all times has a direct correlation to our bottom line and profitability. Additionally, I don't want to commit capital to building out a server environment.
Flowlogistic is rolling out their real-time inventory tracking system. The tracking devices will all send package-tracking messages, which will now go to a single Google Cloud Pub/Sub topic instead of the Apache Kafka cluster. A subscriber application will then process the messages for real-time reporting and store them in Google BigQuery for historical analysis. You want to ensure the package data can be analyzed over time.
Which approach should you take?
- A. Attach the timestamp on each message in the Cloud Pub/Sub subscriber application as they are received.
- B. Attach the timestamp and Package ID on the outbound message from each publisher device as they are sent to Clod Pub/Sub.
- C. Use the NOW () function in BigQuery to record the event's time.
- D. Use the automatically generated timestamp from Cloud Pub/Sub to order the data.
Answer: B
NEW QUESTION 119
You are implementing several batch jobs that must be executed on a schedule. These jobs have many interdependent steps that must be executed in a specific order. Portions of the jobs involve executing shell scripts, running Hadoop jobs, and running queries in BigQuery. The jobs are expected to run for many minutes up to several hours. If the steps fail, they must be retried a fixed number of times. Which service should you use to manage the execution of these jobs?
- A. Cloud Scheduler
- B. Cloud Functions
- C. Cloud Composer
- D. Cloud Dataflow
Answer: C
NEW QUESTION 120
Your company is running their first dynamic campaign, serving different offers by analyzing real-time data during the holiday season. The data scientists are collecting terabytes of data that rapidly grows every hour during their 30-day campaign. They are using Google Cloud Dataflow to preprocess the data and collect the feature (signals) data that is needed for the machine learning model in Google Cloud Bigtable.
The team is observing suboptimal performance with reads and writes of their initial load of 10 TB of data.
They want to improve this performance while minimizing cost. What should they do?
- A. Redesign the schema to use a single row key to identify values that need to be updated frequently in the cluster.
- B. Redesign the schema to use row keys based on numeric IDs that increase sequentially per user viewing the offers.
- C. The performance issue should be resolved over time as the site of the BigDate cluster is increased.
- D. Redefine the schema by evenly distributing reads and writes across the row space of the table.
Answer: D
NEW QUESTION 121
You are a retailer that wants to integrate your online sales capabilities with different in-home assistants, such as Google Home. You need to interpret customer voice commands and issue an order to the backend systems. Which solutions should you choose?
- A. Dialogflow Enterprise Edition
- B. Cloud Natural Language API
- C. Cloud Speech-to-Text API
- D. Cloud AutoML Natural Language
Answer: A
Explanation:
Dialogflow is used to do voice analytics on human computer interaction.
NEW QUESTION 122
Which SQL keyword can be used to reduce the number of columns processed by BigQuery?
- A. BETWEEN
- B. LIMIT
- C. WHERE
- D. SELECT
Answer: D
Explanation:
Explanation
SELECT allows you to query specific columns rather than the whole table.
LIMIT, BETWEEN, and WHERE clauses will not reduce the number of columns processed by BigQuery.
Reference:
https://cloud.google.com/bigquery/launch-checklist#architecture_design_and_development_checklist
NEW QUESTION 123
You need to create a new transaction table in Cloud Spanner that stores product sales data. You are deciding what to use as a primary key. From a performance perspective, which strategy should you choose?
- A. A random universally unique identifier number (version 4 UUID)
- B. The current epoch time
- C. The original order identification number from the sales system, which is a monotonically increasing integer
- D. A concatenation of the product name and the current epoch time
Answer: A
Explanation:
https://cloud.google.com/spanner/docs/schema-and-data-model#choosing_a_primary_key
NEW QUESTION 124
......
Google Exam Practice Test To Gain Brilliante Result: https://www.dumptorrent.com/Professional-Data-Engineer-braindumps-torrent.html
Tested Material Used To Professional-Data-Engineer: https://drive.google.com/open?id=1Ja8WsbRhgQ0SPQ1iDQAYEsH73YyhzHej