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

문제1

In order to securely transfer web traffic data from your computer's web browser to the Cloud Dataproc cluster you should use a(n) _____.

A. SSH tunnel

B. FTP connection

C. VPN connection

D. Special browser

정답: A

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

문제2

You are using BigQuery and Data Studio to design a customer-facing dashboard that displays large quantities of aggregated dat a. You expect a high volume of concurrent users. You need to optimize tie dashboard to provide quick visualizations with minimal latency. What should you do?

A. Use BigQuery Bl Engine with logical reviews

B. Use BigQuery BI Engine with streaming data.

C. Use BigQuery BI Engine with materialized views

D. Use BigQuery Bl Engine with authorized views

정답: B

문제3

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. Provide latitude and longtitude as input vectors to your neural net.

B. Create a feature cross of latitude and longtitude, bucketize at the minute level and use L1 regularization during optimization.

C. Create a feature cross of latitude and longtitude, bucketize it at the minute level and use L2 regularization during optimization.

D. Create a numeric column from a feature cross of latitude and longtitude.

정답: D

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

문제4

Your company is in a highly regulated industry. One of your requirements is to ensure individual users have access only to the minimum amount of information required to do their jobs. You want to enforce this requirement with Google BigQuery. Which three approaches can you take? (Choose three.)

A. Disable writes to certain tables.

B. Restrict access to tables by role.

C. Segregate data across multiple tables or databases.

D. Use Google Stackdriver Audit Logging to determine policy violations.

E. Restrict BigQuery API access to approved users.

F. Ensure that the data is encrypted at all times.

정답: B,D,E

문제5

Which role must be assigned to a service account used by the virtual machines in a Dataproc cluster so they can execute jobs?

A. Dataproc Worker

B. Dataproc Viewer

C. Dataproc Runner

D. Dataproc Editor

정답: A

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

문제6

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?

A. The CSV data loaded in BigQuery is not using BigQuery's default encoding.

B. The CSV data has not gone through an ETL phase before loading into BigQuery.

C. The CSV data has invalid rows that were skipped on import.

D. The CSV data loaded in BigQuery is not flagged as CSV.

정답: C

문제7

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

문제8

You have designed an Apache Beam processing pipeline that reads from a Pub/Sub topic. The topic has a message retention duration of one day, and writes to a Cloud Storage bucket. You need to select a bucket location and processing strategy to prevent data loss in case of a regional outage with an RPO of 15 minutes. What should you do?

A. 1. Use a dual-region Cloud Storage bucket with turbo replication enabled
2 Monitor Dataflow metrics with Cloud Monitoring to determine when an outage occurs
3 Seek the subscription back in time by 60 minutes to recover the acknowledged messages
4 Start the Dataflow job in a secondary region.

B. 1. Use a dual-region Cloud Storage bucket.
2. Monitor Dataflow metrics with Cloud Monitoring to determine when an outage occurs
3 Seek the subscription back in time by 15 minutes to recover the acknowledged messages
4 Start the Dataflow job in a secondary region

C. 1 Use a multi-regional Cloud Storage bucket
2 Monitor Dataflow metrics with Cloud Monitoring to determine when an outage occurs
3 Seek the subscription back in time by 60 minutes to recover the acknowledged messages
4 Start the Dataflow job in a secondary region

D. 1 Use a regional Cloud Storage bucket
2 Monitor Dataflow metrics with Cloud Monitoring to determine when an outage occurs
3 Seek the subscription back in time by one day to recover the acknowledged messages
4 Start the Dataflow job in a secondary region and write in a bucket in the same region

정답: B

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

문제9

You need to compose visualization for operations teams with the following requirements:
Telemetry must include data from all 50,000 installations for the most recent 6 weeks (sampling once every minute) The report must not be more than 3 hours delayed from live data.
The actionable report should only show suboptimal links.
Most suboptimal links should be sorted to the top.
Suboptimal links can be grouped and filtered by regional geography.
User response time to load the report must be <5 seconds.
You create a data source to store the last 6 weeks of data, and create visualizations that allow viewers to see multiple date ranges, distinct geographic regions, and unique installation types. You always show the latest data without any changes to your visualizations. You want to avoid creating and updating new visualizations each month. What should you do?

A. Look through the current data and compose a series of charts and tables, one for each possible combination of criteria.

B. Load the data into relational database tables, write a Google App Engine application that queries all rows, summarizes the data across each criteria, and then renders results using the Google Charts and visualization API.

C. Export the data to a spreadsheet, compose a series of charts and tables, one for each possible combination of criteria, and spread them across multiple tabs.

D. Look through the current data and compose a small set of generalized charts and tables bound to criteria filters that allow value selection.

정답: D

문제10

You are designing a Dataflow pipeline for a batch processing job. You want to mitigate multiple zonal failures at job submission time. What should you do?

A. Create an Eventarc trigger to resubmit the job in case of zonal failure when submitting the job.

B. Set the pipeline staging location as a regional Cloud Storage bucket.

C. Submit duplicate pipelines in two different zones by using the -zone flag.

D. Specify a worker region by using the -region flag.

정답: B

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

문제11

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 회원만 볼 수 있음)

문제12

You are developing an Apache Beam pipeline to extract data from a Cloud SQL instance by using JdbclO. You have two projects running in Google Cloud. The pipeline will be deployed and executed on Dataflow in Project A. The Cloud SQL instance is running jn Project B and does not have a public IP address. After deploying the pipeline, you noticed that the pipeline failed to extract data from the Cloud SQL instance due to connection failure. You verified that VPC Service Controls and shared VPC are not in use in these projects. You want to resolve this error while ensuring that the data does not go through the public internet. What should you do?

A. Set up VPC Network Peering between Project A and Project B. Create a Compute Engine instance without external IP address in Project B on the peered subnet to serve as a proxy server to the Cloud SQL database.

B. Set up VPC Network Peering between Project A and Project B. Add a firewall rule to allow the peered subnet range to access all instances on the network.

C. Add the external IP addresses of the Dataflow worker as authorized networks in the Cloud SOL instance.

D. Turn off the external IP addresses on the Dataflow worker. Enable Cloud NAT in Project A.

정답: A

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

문제13

Your company handles data processing for a number of different clients. Each client prefers to use their own suite of analytics tools, with some allowing direct query access via Google BigQuery. You need to secure the data so that clients cannot see each other's dat a. You want to ensure appropriate access to the data. Which three steps should you take? (Choose three.)

A. Load data into different partitions.

B. Put each client's BigQuery dataset into a different table.

C. Restrict a client's dataset to approved users.

D. Only allow a service account to access the datasets.

E. Load data into a different dataset for each client.

F. Use the appropriate identity and access management (IAM) roles for each client's users.

정답: C,E,F

문제14

You are designing an Apache Beam pipeline to enrich data from Cloud Pub/Sub with static reference data from BigQuery. The reference data is small enough to fit in memory on a single worker. The pipeline should write enriched results to BigQuery for analysis. Which job type and transforms should this pipeline use?

A. Batch job, PubSubIO, side-inputs

B. Streaming job, PubSubIO, JdbcIO, side-outputs

C. Streaming job, PubSubIO, BigQueryIO, side-inputs

D. Streaming job, PubSubIO, BigQueryIO, side-outputs

정답: C

문제15

Your team is responsible for developing and maintaining ETLs in your company. One of your Dataflow jobs is failing because of some errors in the input data, and you need to improve reliability of the pipeline (incl. being able to reprocess all failing data).
What should you do?

A. Add a filtering step to skip these types of errors in the future, extract erroneous rows from logs.

B. Add a try... catch block to your DoFn that transforms the data, extract erroneous rows from logs.

C. Add a try... catch block to your DoFn that transforms the data, use a sideOutput to create a PCollection that can be stored to PubSub later.

D. Add a try... catch block to your DoFn that transforms the data, write erroneous rows to PubSub directly from the DoFn.

정답: D

문제16

Your company uses a proprietary system to send inventory data every 6 hours to a data ingestion service in the cloud. Transmitted data includes a payload of several fields and the timestamp of the transmission. If there are any concerns about a transmission, the system re-transmits the dat a. How should you deduplicate the data most efficiency?

A. Store each data entry as the primary key in a separate database and apply an index.

B. Maintain a database table to store the hash value and other metadata for each data entry.

C. Compute the hash value of each data entry, and compare it with all historical data.

D. Assign global unique identifiers (GUID) to each data entry.

정답: B

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

우리와 연락하기

유용한 링크

최신 업데이트