GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
1. Laws in the region where you operate require that A) Store the data in a
files related to all orders made each day are stored Cloud Storage bucket, and
immutably for 365 days. The solution that you recom- specify a retention peri-
mend has to be cost-effective. What should you do? od.
A) Store the data in a Cloud Storage bucket, and spec- Correct. Object retention
ify a retention period. is a built-in option that
lets you configure how
B) Store the data in a Cloud Storage bucket, enable long the files should re-
object versioning, and delete any version greater than main without allowing any
365. changes.
C) Store the data in a Cloud Storage bucket, and en-
able object versioning and delete any version older
than 365 days.
D) Store the data in a Cloud Storage bucket, and set a
lifecycle policy to delete the file after 365 days.
2. Business analysts in your team need to run analysis on bigquery.user and big-
data that was loaded into BigQuery. You need to fol- query.dataViewer
low recommended practices and grant permissions.
What role should you grant the business analysts? Correct. The analysts need
to view the data and run
-bigquery.user and bigquery.dataViewer queries on it, which are
-bigquery.dataOwner granted by these prede-
-bigquery.resourceViewer and bigquery.dataViewer fined roles.
-storage.objectViewer and bigquery.user
3. Cymbal Retail is migrating its private data centers Order a transfer appli-
to Google Cloud. Over many years, hundreds of ter- ance, export the data to it,
abytes of data were accumulated. You currently have and ship it to Google.
a 100 Mbps line and you need to transfer this data reli-
, GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
ably before commencing operations on Google Cloud Correct. For large
in 45 days. What should you do? amounts of data that need
to be transferred within a
-Order a transfer appliance, export the data to it, and month, a transfer appli-
ship it to Google. ance is the right choice.
-Store the data in an HTTPS endpoint, and configure
Storage Transfer Service to copy the data to Cloud
Storage.
-Upload the data to Cloud Storage by using gsutil.
-Zip and upload the data to Cloud Storage buckets by
using the Google Cloud console.
4. You are migrating on-premises data to a data ware- Use the Cloud Data Loss
house on Google Cloud. This data will be made avail- Prevention (DLP) API to
able to business analysts. Local regulations require identify and redact data
that customer information including credit card num- that matches infoTypes
bers, phone numbers, and email IDs be captured, but like credit card num-
not used in analysis. You need to use a reliable, rec- bers, phone numbers,
ommended solution to redact the sensitive data. What and email IDs.
should you do?
Correct. Cloud Data Loss
-Delete all columns with a title similar to "credit card," Prevention helps you dis-
"phone," and "email." cover, classify, and protect
your most sensitive data.
-Create a regular expression to identify and delete There are predefined info-
patterns that resemble credit card numbers, phone Types that you can employ
numbers, and email IDs. to identify and redact spe-
cific data types.
-Use the Cloud Data Loss Prevention (DLP) API to iden-
tify and redact data that matches infoTypes like credit
card numbers, phone numbers, and email IDs.
-Use the Cloud Data Loss Prevention (DLP) API to
, GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
perform date shifting of any entries with credit card
numbers, phone numbers, and email IDs.
5. Cymbal Retail has a team of business analysts who Load the data into Dat-
need to fix and enhance a set of large input data aprep, explore the data,
files. For example, duplicates need to be removed, and edit the transforma-
erroneous rows should be deleted, and missing data tions as needed.
should be added. These steps need to be performed
on all the present set of files and any files receivedCorrect. Dataprep lets you
in the future in a repeatable, automated process. load large amounts of
The business analysts are not adept at programming. data and visually fix it,
What should they do? which would be very con-
venient for those who are
- Create a Dataproc job to perform the data fixes you unfamiliar with program-
need. ming. The data wrangling
steps can be captured as
- Load the data into Google Sheets, explore the data, a series of transformations
and fix the data as needed. that can be reapplied later
to future data.
- Load the data into Dataprep, explore the data, and
edit the transformations as needed.
- Create a Dataflow pipeline with the data fixes you
need.
6. Cymbal Retail has acquired another company in Eu- Create top level folders for
rope. Data access permissions and policies in this new each region, and assign
region differ from those in Cymbal Retail's headquar- policies at the folder lev-
ters, which is in North America. You need to define a el.
consistent set of policies for projects in each region
that follow recommended practices. What should you Correct. Folders are used
do? to group related pro-
jects within an organiza-
, GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
- Create a new organization for all projects in Europe tion. They can also be used
and assign policies in each organization that comply to apply consistent poli-
with regional laws. cies for projects within the
folder.
- Implement a flat hierarchy, and assign policies to
each project according to its region.
- Create top level folders for each region, and assign
policies at the folder level.
- Implement policies at the resource level that comply
with regional laws.
7. You are managing the data for Cymbal Retail, which Implement a data mesh
consists of multiple teams including retail, sales, mar- with Dataplex and have
keting, and legal. These teams are consuming data producers tag data when
from multiple producers including point of sales sys- created.
tems, industry data, orders, and more. Currently,
teams that consume data have to repeatedly ask the Correct. Dataplex is a data
teams that produce it to verify the most up-to-date mesh that also includes
data and to clarify other questions about the data, data cataloging capabili-
such as source and ownership. This process is unre- ty with Data Catalog. Con-
liable and time-consuming and often leads to repeat- sumers of data can search
ed escalations. You need to implement a centralized and discover information
solution that gains a unified view of the organiza- readily without having to
tion's data and improves searchability. What should wait for data producers
you do? to respond, which reduces
the bottlenecks on data
- Implement a data mesh with Dataplex and have analysis.
producers tag data when created.
- Implement a data warehouse by using BigQuery, and
create datasets for each team such as retail, sales,
Study online at https://quizlet.com/_fg3n9i
1. Laws in the region where you operate require that A) Store the data in a
files related to all orders made each day are stored Cloud Storage bucket, and
immutably for 365 days. The solution that you recom- specify a retention peri-
mend has to be cost-effective. What should you do? od.
A) Store the data in a Cloud Storage bucket, and spec- Correct. Object retention
ify a retention period. is a built-in option that
lets you configure how
B) Store the data in a Cloud Storage bucket, enable long the files should re-
object versioning, and delete any version greater than main without allowing any
365. changes.
C) Store the data in a Cloud Storage bucket, and en-
able object versioning and delete any version older
than 365 days.
D) Store the data in a Cloud Storage bucket, and set a
lifecycle policy to delete the file after 365 days.
2. Business analysts in your team need to run analysis on bigquery.user and big-
data that was loaded into BigQuery. You need to fol- query.dataViewer
low recommended practices and grant permissions.
What role should you grant the business analysts? Correct. The analysts need
to view the data and run
-bigquery.user and bigquery.dataViewer queries on it, which are
-bigquery.dataOwner granted by these prede-
-bigquery.resourceViewer and bigquery.dataViewer fined roles.
-storage.objectViewer and bigquery.user
3. Cymbal Retail is migrating its private data centers Order a transfer appli-
to Google Cloud. Over many years, hundreds of ter- ance, export the data to it,
abytes of data were accumulated. You currently have and ship it to Google.
a 100 Mbps line and you need to transfer this data reli-
, GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
ably before commencing operations on Google Cloud Correct. For large
in 45 days. What should you do? amounts of data that need
to be transferred within a
-Order a transfer appliance, export the data to it, and month, a transfer appli-
ship it to Google. ance is the right choice.
-Store the data in an HTTPS endpoint, and configure
Storage Transfer Service to copy the data to Cloud
Storage.
-Upload the data to Cloud Storage by using gsutil.
-Zip and upload the data to Cloud Storage buckets by
using the Google Cloud console.
4. You are migrating on-premises data to a data ware- Use the Cloud Data Loss
house on Google Cloud. This data will be made avail- Prevention (DLP) API to
able to business analysts. Local regulations require identify and redact data
that customer information including credit card num- that matches infoTypes
bers, phone numbers, and email IDs be captured, but like credit card num-
not used in analysis. You need to use a reliable, rec- bers, phone numbers,
ommended solution to redact the sensitive data. What and email IDs.
should you do?
Correct. Cloud Data Loss
-Delete all columns with a title similar to "credit card," Prevention helps you dis-
"phone," and "email." cover, classify, and protect
your most sensitive data.
-Create a regular expression to identify and delete There are predefined info-
patterns that resemble credit card numbers, phone Types that you can employ
numbers, and email IDs. to identify and redact spe-
cific data types.
-Use the Cloud Data Loss Prevention (DLP) API to iden-
tify and redact data that matches infoTypes like credit
card numbers, phone numbers, and email IDs.
-Use the Cloud Data Loss Prevention (DLP) API to
, GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
perform date shifting of any entries with credit card
numbers, phone numbers, and email IDs.
5. Cymbal Retail has a team of business analysts who Load the data into Dat-
need to fix and enhance a set of large input data aprep, explore the data,
files. For example, duplicates need to be removed, and edit the transforma-
erroneous rows should be deleted, and missing data tions as needed.
should be added. These steps need to be performed
on all the present set of files and any files receivedCorrect. Dataprep lets you
in the future in a repeatable, automated process. load large amounts of
The business analysts are not adept at programming. data and visually fix it,
What should they do? which would be very con-
venient for those who are
- Create a Dataproc job to perform the data fixes you unfamiliar with program-
need. ming. The data wrangling
steps can be captured as
- Load the data into Google Sheets, explore the data, a series of transformations
and fix the data as needed. that can be reapplied later
to future data.
- Load the data into Dataprep, explore the data, and
edit the transformations as needed.
- Create a Dataflow pipeline with the data fixes you
need.
6. Cymbal Retail has acquired another company in Eu- Create top level folders for
rope. Data access permissions and policies in this new each region, and assign
region differ from those in Cymbal Retail's headquar- policies at the folder lev-
ters, which is in North America. You need to define a el.
consistent set of policies for projects in each region
that follow recommended practices. What should you Correct. Folders are used
do? to group related pro-
jects within an organiza-
, GCP DATA ENGINEER CERTIFICATION
Study online at https://quizlet.com/_fg3n9i
- Create a new organization for all projects in Europe tion. They can also be used
and assign policies in each organization that comply to apply consistent poli-
with regional laws. cies for projects within the
folder.
- Implement a flat hierarchy, and assign policies to
each project according to its region.
- Create top level folders for each region, and assign
policies at the folder level.
- Implement policies at the resource level that comply
with regional laws.
7. You are managing the data for Cymbal Retail, which Implement a data mesh
consists of multiple teams including retail, sales, mar- with Dataplex and have
keting, and legal. These teams are consuming data producers tag data when
from multiple producers including point of sales sys- created.
tems, industry data, orders, and more. Currently,
teams that consume data have to repeatedly ask the Correct. Dataplex is a data
teams that produce it to verify the most up-to-date mesh that also includes
data and to clarify other questions about the data, data cataloging capabili-
such as source and ownership. This process is unre- ty with Data Catalog. Con-
liable and time-consuming and often leads to repeat- sumers of data can search
ed escalations. You need to implement a centralized and discover information
solution that gains a unified view of the organiza- readily without having to
tion's data and improves searchability. What should wait for data producers
you do? to respond, which reduces
the bottlenecks on data
- Implement a data mesh with Dataplex and have analysis.
producers tag data when created.
- Implement a data warehouse by using BigQuery, and
create datasets for each team such as retail, sales,
