최신 Professional-Data-Engineer 무료덤프 - Google Certified Professional Data Engineer

문제1

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 dat a. They want to improve this performance while minimizing cost. What should they do?

A. Redesign the schema to use row keys based on numeric IDs that increase sequentially per user viewing the offers.

B. Redefine the schema by evenly distributing reads and writes across the row space of the table.

C. The performance issue should be resolved over time as the site of the BigDate cluster is increased.

D. Redesign the schema to use a single row key to identify values that need to be updated frequently in the cluster.

정답: B

문제2

When a Cloud Bigtable node fails, ____ is lost.

A. all data

B. the last transaction

C. no data

D. the time dimension

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제3

What are two of the characteristics of using online prediction rather than batch prediction?

A. It is optimized to handle a high volume of data instances in a job and to run more complex models.

B. It is optimized to minimize the latency of serving predictions.

C. Predictions are returned in the response message.

D. Predictions are written to output files in a Cloud Storage location that you specify.

정답: B,C

설명: (DumpTOP 회원만 볼 수 있음)

문제4

Your chemical company needs to manually check documentation for customer order. You use a pull subscription in Pub/Sub so that sales agents get details from the order. You must ensure that you do not process orders twice with different sales agents and that you do not add more complexity to this workflow. What should you do?

A. Use a Deduphcate PTransform in Dataflow before sending the messages to the sales agents.

B. Create a transactional database that monitors the pending messages.

C. Use Pub/Sub exactly-once delivery in your pull subscription.

D. Create a new Pub/Sub push subscription to monitor the orders processed in the agent's system.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제5

You are running your BigQuery project in the on-demand billing model and are executing a change data capture (CDC) process that ingests dat a. The CDC process loads 1 GB of data every 10 minutes into a temporary table, and then performs a merge into a 10 TB target table. This process is very scan intensive and you want to explore options to enable a predictable cost model. You need to create a BigQuery reservation based on utilization information gathered from BigQuery Monitoring and apply the reservation to the CDC process. What should you do?

A. Create a BigQuery reservation for the dataset.

B. Create a BigQuery reservation for the project.

C. Create a BigQuery reservation for the job.

D. Create a BigQuery reservation for the service account running the job.

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제6

You are developing a software application using Google's Dataflow SDK, and want to use conditional, for loops and other complex programming structures to create a branching pipeline. Which component will be used for the data processing operation?

A. PCollection

B. Transform

C. Sink API

D. Pipeline

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Your team is building a data lake platform on Google Cloud. As a part of the data foundation design, you are planning to store all the raw data in Cloud Storage You are expecting to ingest approximately 25 GB of data a day and your billing department is worried about the increasing cost of storing old dat a. The current business requirements are:
* The old data can be deleted anytime
* You plan to use the visualization layer for current and historical reporting
* The old data should be available instantly when accessed
* There should not be any charges for data retrieval.
What should you do to optimize for cost?

A. Create the bucket with the Autoclass storage class feature.

B. Create an Object Lifecycle Management policy to modify the storage class for data older than 30 days to nearlme. 45 days to coldline. and 60 days to archive storage class Delete old data as needed.

C. Create an Object Lifecycle Management policy to modify the storage class for data older than 30 days to coldline, 90 days to nearline. and 365 days to archive storage class Delete old data as needed.

D. Create an Object Lifecycle Management policy to modify the storage class for data older than 30 days to nearline, 90 days to coldline. and 365 days to archive storage class. Delete old data as needed.

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제8

Data Analysts in your company have the Cloud IAM Owner role assigned to them in their projects to allow them to work with multiple GCP products in their projects. Your organization requires that all BigQuery data access logs be retained for 6 months. You need to ensure that only audit personnel in your company can access the data access logs for all projects. What should you do?

A. Export the data access logs via a project-level export sink to a Cloud Storage bucket in the Data Analysts' projects. Restrict access to the Cloud Storage bucket.

B. Export the data access logs via a project-level export sink to a Cloud Storage bucket in a newly created projects for audit logs. Restrict access to the project with the exported logs.

C. Enable data access logs in each Data Analyst's project. Restrict access to Stackdriver Logging via Cloud IAM roles.

D. Export the data access logs via an aggregated export sink to a Cloud Storage bucket in a newly created project for audit logs. Restrict access to the project that contains the exported logs.

정답: D

문제9

You have enabled the free integration between Firebase Analytics and Google BigQuery. Firebase now automatically creates a new table daily in BigQuery in the format app_events_YYYYMMDD. You want to query all of the tables for the past 30 days in legacy SQL. What should you do?

A. Use SELECT IF.(date >= YYYY-MM-DD AND date <= YYYY-MM-DD

B. Use the WHERE_PARTITIONTIME pseudo column

C. Use the TABLE_DATE_RANGE function

D. Use WHERE date BETWEEN YYYY-MM-DD AND YYYY-MM-DD

정답: C

문제10

Different teams in your organization store customer and performance data in BigOuery. Each team needs to keep full control of their collected data, be able to query data within their projects, and be able to exchange their data with other teams. You need to implement an organization-wide solution, while minimizing operational tasks and costs. What should you do?

A. Ask each team to publish their data in Analytics Hub. Direct the other teams to subscribe to them.

B. Create a BigQuery scheduled query to replicate all customer data into team projects.

C. Ask each team to create authorized views of their data. Grant the biquery. jobUser role to each team.

D. Enable each team to create materialized views of the data they need to access in their projects.

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제11

How would you query specific partitions in a BigQuery table?

A. Use the EXTRACT(DAY) clause

B. Use the DAY column in the WHERE clause

C. Use the __PARTITIONTIME pseudo-column in the WHERE clause

D. Use DATE BETWEEN in the WHERE clause

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제12

Your new customer has requested daily reports that show their net consumption of Google Cloud compute resources and who used the resources. You need to quickly and efficiently generate these daily reports. What should you do?

A. Filter data in Cloud Logging by project, log type, resource, and user, then import the data into BigQuery.

B. Export Cloud Logging data to Cloud Storage in CSV format. Cleanse the data using Dataprep, filtering by project, resource, and user.

C. Filter data in Cloud Logging by project, resource, and user; then export the data in CSV format.

D. Do daily exports of Cloud Logging data to BigQuery. Create views filtering by project, log type, resource, and user.

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제13

An external customer provides you with a daily dump of data from their database. The data flows into Google Cloud Storage GCS as comma-separated values (CSV) files. You want to analyze this data in Google BigQuery, but the data could have rows that are formatted incorrectly or corrupted. How should you build this pipeline?

A. Use federated data sources, and check data in the SQL query.

B. Import the data into BigQuery using the gcloud CLI and set max_bad_records to 0.

C. Run a Google Cloud Dataflow batch pipeline to import the data into BigQuery, and push errors to another dead-letter table for analysis.

D. Enable BigQuery monitoring in Google Stackdriver and create an alert.

정답: C

문제14

After migrating ETL jobs to run on BigQuery, you need to verify that the output of the migrated jobs is the same as the output of the original. You've loaded a table containing the output of the original job and want to compare the contents with output from the migrated job to show that they are identical. The tables do not contain a primary key column that would enable you to join them together for comparison.
What should you do?

A. Select random samples from the tables using the RAND() function and compare the samples.

B. Use a Dataproc cluster and the BigQuery Hadoop connector to read the data from each table and calculate a hash from non-timestamp columns of the table after sorting. Compare the hashes of each table.

C. Create stratified random samples using the OVER() function and compare equivalent samples from each table.

D. Select random samples from the tables using the HASH() function and compare the samples.

정답: D

문제15

Your startup has never implemented a formal security policy. Currently, everyone in the company has access to the datasets stored in Google BigQuery. Teams have freedom to use the service as they see fit, and they have not documented their use cases. You have been asked to secure the data warehouse. You need to discover what everyone is doing. What should you do first?

A. Get the identity and access management IIAM) policy of each table

B. Use Stackdriver Monitoring to see the usage of BigQuery query slots.

C. Use Google Stackdriver Audit Logs to review data access.

D. Use the Google Cloud Billing API to see what account the warehouse is being billed to.

정답: C

최신 Professional-Data-Engineer 무료덤프 - Google Certified Professional Data Engineer

우리와 연락하기

유용한 링크

최신 업데이트