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

문제1

You need to create a new transaction table in Cloud Spanner that stores product sales dat a. You are deciding what to use as a primary key. From a performance perspective, which strategy should you choose?

A. A concatenation of the product name and the current epoch time

B. The original order identification number from the sales system, which is a monotonically increasing integer

C. A random universally unique identifier number (version 4 UUID)

D. The current epoch time

정답: C

문제2

You launched a new gaming app almost three years ago. You have been uploading log files from the previous day to a separate Google BigQuery table with the table name format LOGS_yyyymmdd. You have been using table wildcard functions to generate daily and monthly reports for all time ranges. Recently, you discovered that some queries that cover long date ranges are exceeding the limit of 1,000 tables and failing. How can you resolve this issue?

A. Convert all daily log tables into date-partitioned tables

B. Create separate views to cover each month, and query from these views

C. Convert the sharded tables into a single partitioned table

D. Enable query caching so you can cache data from previous months

정답: A

문제3

Which of these sources can you not load data into BigQuery from?

A. File upload

B. Google Cloud SQL

C. Google Cloud Storage

D. Google Drive

정답: B

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

문제4

You have important legal hold documents in a Cloud Storage bucket. You need to ensure that these documents are not deleted or modified. What should you do?

A. Set a retention policy. Set the default storage class to Archive for long-term digital preservation.

B. Enable the Object Versioning feature. Create a copy in a bucket in a different region.

C. Enable the Object Versioning feature. Add a lifecycle rule.

D. Set a retention policy. Lock the retention policy.

정답: D

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

문제5

Your globally distributed auction application allows users to bid on items. Occasionally, users place identical bids at nearly identical times, and different application servers process those bids. Each bid event contains the item, amount, user, and timestamp. You want to collate those bid events into a single location in real time to determine which user bid first. What should you do?

A. Have each application server write the bid events to Google Cloud Pub/Sub as they occur. Use a pull

B. Create a file on a shared file and have the application servers write all bid events to that file. Process the file with Apache Hadoop to identify which user bid first.

C. Have each application server write the bid events to Cloud Pub/Sub as they occur. Push the events from Cloud Pub/Sub to a custom endpoint that writes the bid event information into Cloud SQL.

D. Set up a MySQL database for each application server to write bid events into. Periodically query each of those distributed MySQL databases and update a master MySQL database with bid event information.

정답: D

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

문제6

Which of these operations can you perform from the BigQuery Web UI?

A. Load data with nested and repeated fields.

B. Upload a 20 MB file.

C. Upload multiple files using a wildcard.

D. Upload a file in SQL format.

정답: A

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

문제7

Dataproc clusters contain many configuration files. To update these files, you will need to use the --properties option. The format for the option is: file_prefix:property=_____.

A. null

B. value

C. details

D. id

정답: B

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

문제8

Which of these statements about BigQuery caching is true?

A. BigQuery caches query results for 48 hours.

B. Query results are cached even if you specify a destination table.

C. By default, a query's results are not cached.

D. There is no charge for a query that retrieves its results from cache.

정답: D

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

문제9

You are migrating your data warehouse to Google Cloud and decommissioning your on-premises data center Because this is a priority for your company, you know that bandwidth will be made available for the initial data load to the cloud. The files being transferred are not large in number, but each file is 90 GB Additionally, you want your transactional systems to continually update the warehouse on Google Cloud in real time What tools should you use to migrate the data and ensure that it continues to write to your warehouse?

A. Storage Transfer Service for the migration, Pub/Sub and Cloud Data Fusion for the real-time updates

B. gsutil for both the migration and the real-time updates

C. BigQuery Data Transfer Service for the migration, Pub/Sub and Dataproc for the real-time updates

D. gsutil for the migration; Pub/Sub and Dataflow for the real-time updates

정답: A

문제10

Which Cloud Dataflow / Beam feature should you use to aggregate data in an unbounded data source every hour based on the time when the data entered the pipeline?

A. A processing time trigger

B. An event time trigger

C. The with Allowed Lateness method

D. An hourly watermark

정답: A

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

문제11

Your company has a hybrid cloud initiative. You have a complex data pipeline that moves data between cloud provider services and leverages services from each of the cloud providers. Which cloud-native service should you use to orchestrate the entire pipeline?

A. Cloud Composer

B. Cloud Dataprep

C. Cloud Dataproc

D. Cloud Dataflow

정답: C

문제12

You need to connect multiple applications with dynamic public IP addresses to a Cloud SQL instance. You configured users with strong passwords and enforced the SSL connection to your Cloud SOL instance. You want to use Cloud SQL public IP and ensure that you have secured connections. What should you do?

A. Add CIDR 0.0.0.0/0 network to Authorized Network. Use Cloud SOL Auth proxy on all applications.

B. Add all application networks to Authorized Network and regularly update them.

C. Leave the Authorized Network empty. Use Cloud SQL Auth proxy on all applications.

D. Add CIDR 0.0.0.0/0 network to Authorized Network. Use Identity and Access Management (1AM) to add users.

정답: C

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

문제13

Which of the following IAM roles does your Compute Engine account require to be able to run pipeline jobs?

A. dataflow.worker

B. dataflow.developer

C. dataflow.viewer

D. dataflow.compute

정답: A

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

문제14

Your company built a TensorFlow neural-network model with a large number of neurons and layers. The model fits well for the training dat a. However, when tested against new data, it performs poorly. What method can you employ to address this?

A. Dropout Methods

B. Threading

C. Serialization

D. Dimensionality Reduction

정답: A

문제15

You have a data pipeline that writes data to Cloud Bigtable using well-designed row keys. You want to monitor your pipeline to determine when to increase the size of you Cloud Bigtable cluster. Which two actions can you take to accomplish this? Choose 2 answers.

A. Monitor storage utilization. Increase the size of the Cloud Bigtable cluster when utilization increases above 70% of max capacity.

B. Review Key Visualizer metrics. Increase the size of the Cloud Bigtable cluster when the Read pressure index is above 100.

C. Monitor latency of read operations. Increase the size of the Cloud Bigtable cluster of read operations take longer than 100 ms.

D. Monitor the latency of write operations. Increase the size of the Cloud Bigtable cluster when there is a sustained increase in write latency.

E. Review Key Visualizer metrics. Increase the size of the Cloud Bigtable cluster when the Write pressure index is above 100.

정답: B,D

문제16

What are two methods that can be used to denormalize tables in BigQuery?

A. 1) Join tables into one table; 2) Use nested repeated fields

B. 1) Use a partitioned table; 2) Join tables into one table

C. 1) Use nested repeated fields; 2) Use a partitioned table

D. 1) Split table into multiple tables; 2) Use a partitioned table

정답: A

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

문제17

When creating a new Cloud Dataproc cluster with the projects.regions.clusters.create operation, these four values are required: project, region, name, and ____.

A. zone

B. label

C. node

D. type

정답: A

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

문제18

Which of these are examples of a value in a sparse vector? (Select 2 answers.)

A. [0, 0, 0, 1, 0, 0, 1]

B. [1, 0, 0, 0, 0, 0, 0]

C. [0, 5, 0, 0, 0, 0]

D. [0, 1]

정답: B,D

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

문제19

An online brokerage company requires a high volume trade processing architecture. You need to create a secure queuing system that triggers jobs. The jobs will run in Google Cloud and cat the company's Python API to execute trades. You need to efficiently implement a solution. What should you do?

A. Use Cloud Composer to subscribe to a Pub/Sub tope and can the Python API.

B. Use a Pub/Sub push subscription to trigger a Cloud Function to pass the data to tie Python API.

C. Write an application hosted on a Compute Engine instance that makes a push subscription to the Pub/Sub topic

D. Write an application that makes a queue in a NoSQL database

정답: D

문제20

You stream order data by using a Dataflow pipeline, and write the aggregated result to Memorystore. You provisioned a Memorystore for Redis instance with Basic Tier. 4 GB capacity, which is used by 40 clients for read-only access. You are expecting the number of read-only clients to increase significantly to a few hundred and you need to be able to support the demand. You want to ensure that read and write access availability is not impacted, and any changes you make can be deployed quickly. What should you do?

A. Create a new Memorystore for Redis instance with Standard Tier Set capacity to 4 GB and read replica to No read replicas (high availability only). Delete the old instance.

B. Create a new Memorystore for Redis instance with Standard Tier Set capacity to 5 GB and create multiple read replicas Delete the old instance.

C. Create multiple new Memorystore for Redis instances with Basic Tier (4 GB capacity) Modify the Dataflow pipeline and new clients to use all instances

D. Create a new Memorystore for Memcached instance Set a minimum of three nodes, and memory per node to 4 GB. Modify the Dataflow pipeline and all clients to use the Memcached instance Delete the old instance.

정답: B

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

우리와 연락하기

문의할 점이 있으시면 메일을 보내오세요. 12시간이내에 답장드리도록 하고 있습니다.

근무시간: ( UTC+9 ) 9:00-24:00
월요일~토요일

서포트: 바로 연락하기

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

우리와 연락하기

유용한 링크

최신 업데이트