GCP Professional Data Engineer Certification Exam
100% Verified
TPT Ltd. has decided to migrate its on-premise data infrastructure to the cloud,
particularly to assure high availability in cloud services while reducing high costs
associated with storing data on-premise. The infrastructure uses HDFS to store data
which can then be processed and transformed by Apache Hive and Spark. While the
company wants to migrate the infrastructure, it wants the DevOps team to keep
administering the infrastructure in the cloud. Which of the following approach should be
recommended in this case?
Use Dataproc to process the data. Store data in Google Storage.
TPT Ltd. is a video-on-demand company plans to generate subtitles for its content on
the web. With over 20,000 hours of content to be subtitled, their current subtitle team
cannot match up with the every-growing video hours that the content team keep adding
to the website library. Since recruiting manpower for this task will be pretty expensive
and may take a long time, the company is looking for a solution to automate this
process. Select the most appropriate option from the following which can help in
automating video subtitles.
Cloud Speech-to-Text.
Which keyword is used in BigQuery standard SQL when selecting from multiple tables
with wildcard by their suffices?
_TABLE_SUFFIX
TPT Ltd. is a dairy products company. The company monitors its employees' activities
and detects any intruders using their sensors, which are installed around different
areas in their farms. They use an Apache Kafka cluster to gather the events coming
from sensors. The Kafka cluster is becoming a bottleneck, causing lag in receiving
sensor events. It turns out that the sensors are sending more frequent events.
Moreover, the company is expanding more and more farms and installing different
sensors, which is putting extra load on the cluster. Which of the following options best
addresses this problem?
Ingest and stream sensor events using pub/sub.
, TPT Ltd. offers an online learning platform where it will automatically create captions in
text format for all videos that it hosts. The learning platform offers about 2,500 courses
on business, finance, cooking, development, and science. Also, the platform offers
content in different languages, such as French, German, Turkish, and Thai. This
probably can be very challenging for a single team to caption all the available courses.
In this regard, the company is looking for an approach to meet the requirement and
handle the job appropriately. Which of the following Google Cloud products would be
appropriate for this use case? Cloud Speech-to-Text.
TPT Ltd. wants to move its data center from on-premise servers to the cloud. It has been
estimated that the company has around 2 Petabytes of data to be moved. The security
team is extremely concerned about the data that needs to be migrated securely.
Additionally, the project manager has set a timeline of 6 months for completing all the
migration. Choose the best possible approach that must be used to perform this task.
Appliance Transfer Service.
Rick has a dataflow pipeline that reads a CSV file daily at 6 AM. He applies the cleansing
and transformation needed on it and then loads it to BigQuery. But due to incomplete
data or human error, the CSV file might be modified within the day because of which he
has to re-run the data flow pipeline manually. Which of the following options should he
use to fix the issue by automatically re-running the pipeline in case the file has been
modified?
Use Cloud Composer to rerun dataflow and reprocess the file. Create a custom sensor
to detect file condition if changed.
TPT Ltd. a coach line bus service company wants to forecast how many passengers
they expect to book for tickets on their buses for the upcoming months. This helps the
company understand various factors like how many buses need to be in service for
maintenance, how much fuel is required, and how many drivers need to be available.
Since 1968, the company has records of all booked tickets and allows private sharing of
this data for the prediction process. Mike has been asked to build the machine learning
model for TPT Ltd. Which of the following technique he must use to predict no. of
passengers?
Regression.
100% Verified
TPT Ltd. has decided to migrate its on-premise data infrastructure to the cloud,
particularly to assure high availability in cloud services while reducing high costs
associated with storing data on-premise. The infrastructure uses HDFS to store data
which can then be processed and transformed by Apache Hive and Spark. While the
company wants to migrate the infrastructure, it wants the DevOps team to keep
administering the infrastructure in the cloud. Which of the following approach should be
recommended in this case?
Use Dataproc to process the data. Store data in Google Storage.
TPT Ltd. is a video-on-demand company plans to generate subtitles for its content on
the web. With over 20,000 hours of content to be subtitled, their current subtitle team
cannot match up with the every-growing video hours that the content team keep adding
to the website library. Since recruiting manpower for this task will be pretty expensive
and may take a long time, the company is looking for a solution to automate this
process. Select the most appropriate option from the following which can help in
automating video subtitles.
Cloud Speech-to-Text.
Which keyword is used in BigQuery standard SQL when selecting from multiple tables
with wildcard by their suffices?
_TABLE_SUFFIX
TPT Ltd. is a dairy products company. The company monitors its employees' activities
and detects any intruders using their sensors, which are installed around different
areas in their farms. They use an Apache Kafka cluster to gather the events coming
from sensors. The Kafka cluster is becoming a bottleneck, causing lag in receiving
sensor events. It turns out that the sensors are sending more frequent events.
Moreover, the company is expanding more and more farms and installing different
sensors, which is putting extra load on the cluster. Which of the following options best
addresses this problem?
Ingest and stream sensor events using pub/sub.
, TPT Ltd. offers an online learning platform where it will automatically create captions in
text format for all videos that it hosts. The learning platform offers about 2,500 courses
on business, finance, cooking, development, and science. Also, the platform offers
content in different languages, such as French, German, Turkish, and Thai. This
probably can be very challenging for a single team to caption all the available courses.
In this regard, the company is looking for an approach to meet the requirement and
handle the job appropriately. Which of the following Google Cloud products would be
appropriate for this use case? Cloud Speech-to-Text.
TPT Ltd. wants to move its data center from on-premise servers to the cloud. It has been
estimated that the company has around 2 Petabytes of data to be moved. The security
team is extremely concerned about the data that needs to be migrated securely.
Additionally, the project manager has set a timeline of 6 months for completing all the
migration. Choose the best possible approach that must be used to perform this task.
Appliance Transfer Service.
Rick has a dataflow pipeline that reads a CSV file daily at 6 AM. He applies the cleansing
and transformation needed on it and then loads it to BigQuery. But due to incomplete
data or human error, the CSV file might be modified within the day because of which he
has to re-run the data flow pipeline manually. Which of the following options should he
use to fix the issue by automatically re-running the pipeline in case the file has been
modified?
Use Cloud Composer to rerun dataflow and reprocess the file. Create a custom sensor
to detect file condition if changed.
TPT Ltd. a coach line bus service company wants to forecast how many passengers
they expect to book for tickets on their buses for the upcoming months. This helps the
company understand various factors like how many buses need to be in service for
maintenance, how much fuel is required, and how many drivers need to be available.
Since 1968, the company has records of all booked tickets and allows private sharing of
this data for the prediction process. Mike has been asked to build the machine learning
model for TPT Ltd. Which of the following technique he must use to predict no. of
passengers?
Regression.
