Google Professional Data Engineer Google Certified Professional – Data Engineer Online Training
Google Professional Data Engineer Online Training
The questions for Professional Data Engineer were last updated at Nov 26,2024.
- Exam Code: Professional Data Engineer
- Exam Name: Google Certified Professional – Data Engineer
- Certification Provider: Google
- Latest update: Nov 26,2024
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 flagged as CSV.
- B . The CSV data has invalid rows that were skipped on import.
- C . The CSV data loaded in BigQuery is not using BigQuery’s default encoding.
- D . The CSV data has not gone through an ETL phase before loading into BigQuery.
Your company produces 20,000 files every hour. Each data file is formatted as a comma separated values (CSV) file that is less than 4 KB. All files must be ingested on Google Cloud Platform before they can be processed. Your company site has a 200 ms latency to Google Cloud, and your Internet connection bandwidth is limited as 50 Mbps. You currently deploy a secure FTP (SFTP) server on a virtual machine in Google Compute Engine as the data ingestion point. A local SFTP client runs on a dedicated machine to transmit the CSV files as is. The goal is to make reports with data from the previous day available to the executives by 10:00 a.m. each day. This design is barely able to keep up with the current volume, even though the bandwidth utilization is rather low.
You are told that due to seasonality, your company expects the number of files to double for the next three months.
Which two actions should you take? (Choose two.)
- A . Introduce data compression for each file to increase the rate file of file transfer.
- B . Contact your internet service provider (ISP) to increase your maximum bandwidth to at least 100 Mbps.
- C . Redesign the data ingestion process to use gsutil tool to send the CSV files to a storage bucket in parallel.
- D . Assemble 1,000 files into a tape archive (TAR) file. Transmit the TAR files instead, and disassemble the CSV files in the cloud upon receiving them.
- E . Create an S3-compatible storage endpoint in your network, and use Google Cloud Storage Transfer Service to transfer on-premices data to the designated storage bucket.
You are choosing a NoSQL database to handle telemetry data submitted from millions of Internet-of-Things (IoT) devices. The volume of data is growing at 100 TB per year, and each data entry has about 100 attributes. The data processing pipeline does not require atomicity, consistency, isolation, and durability (ACID). However, high availability and low latency are required.
You need to analyze the data by querying against individual fields.
Which three databases meet your requirements? (Choose three.)
- A . Redis
- B . HBase
- C . MySQL
- D . MongoDB
- E . Cassandra
- F . HDFS with Hive
Topic 5, Practice Questions
Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error. SELECT person FROM `project1.example.table1` WHERE city = "London"
How would you correct the error?
- A . Add ", UNNEST(person)" before the WHERE clause.
- B . Change "person" to "person.city".
- C . Change "person" to "city.person".
- D . Add ", UNNEST(city)" before the WHERE clause.
What are two of the benefits of using denormalized data structures in BigQuery?
- A . Reduces the amount of data processed, reduces the amount of storage required
- B . Increases query speed, makes queries simpler
- C . Reduces the amount of storage required, increases query speed
- D . Reduces the amount of data processed, increases query speed
Which of these statements about exporting data from BigQuery is false?
- A . To export more than 1 GB of data, you need to put a wildcard in the destination filename.
- B . The only supported export destination is Google Cloud Storage.
- C . Data can only be exported in JSON or Avro format.
- D . The only compression option available is GZIP.
What are all of the BigQuery operations that Google charges for?
- A . Storage, queries, and streaming inserts
- B . Storage, queries, and loading data from a file
- C . Storage, queries, and exporting data
- D . Queries and streaming inserts
Which of the following is not possible using primitive roles?
- A . Give a user viewer access to BigQuery and owner access to Google Compute Engine instances.
- B . Give UserA owner access and UserB editor access for all datasets in a project.
- C . Give a user access to view all datasets in a project, but not run queries on them.
- D . Give GroupA owner access and GroupB editor access for all datasets in a project.
Which of these statements about BigQuery caching is true?
- A . By default, a query’s results are not cached.
- B . BigQuery caches query results for 48 hours.
- C . Query results are cached even if you specify a destination table.
- D . There is no charge for a query that retrieves its results from cache.
Which of these sources can you not load data into BigQuery from?
- A . File upload
- B . Google Drive
- C . Google Cloud Storage
- D . Google Cloud SQL
Latest Professional Data Engineer Dumps Valid Version with 160 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
