Updated Jan-2022 Official licence for Professional-Data-Engineer Certified by Professional-Data-Engineer Dumps PDF [Q112-Q127]

Share

Updated Jan-2022 Official licence for Professional-Data-Engineer Certified by Professional-Data-Engineer Dumps PDF

Grab latest Amazon Professional-Data-Engineer Dumps as PDF Updated on 2022

NEW QUESTION 112
You are planning to migrate your current on-premises Apache Hadoop deployment to the cloud. You need to ensure that the deployment is as fault-tolerant and cost-effective as possible for long-running batch jobs. You want to use a managed service. What should you do?

  • A. Deploy a Cloud Dataproc cluster. Use a standard persistent disk and 50% preemptible workers. Store data in Cloud Storage, and change references in scripts from hdfs:// to gs://
  • B. Install Hadoop and Spark on a 10-node Compute Engine instance group with preemptible instances.
    Store data in HDFS. Change references in scripts from hdfs:// to gs://
  • C. Install Hadoop and Spark on a 10-node Compute Engine instance group with standard instances. Install the Cloud Storage connector, and store the data in Cloud Storage. Change references in scripts from hdfs:// to gs://
  • D. Deploy a Cloud Dataproc cluster. Use an SSD persistent disk and 50% preemptible workers. Store data in Cloud Storage, and change references in scripts from hdfs:// to gs://

Answer: A

 

NEW QUESTION 113
You have a query that filters a BigQuery table using a WHERE clause on timestamp and ID columns. By using bq query - -dry_run you learn that the query triggers a full scan of the table, even though the filter on timestamp and ID select a tiny fraction of the overall data. You want to reduce the amount of data scanned by BigQuery with minimal changes to existing SQL queries. What should you do?

  • A. Use the LIMIT keyword to reduce the number of rows returned.
  • B. Use the bq query - -maximum_bytes_billedflag to restrict the number of bytes billed.
  • C. Create a separate table for each ID.
  • D. Recreate the table with a partitioning column and clustering column.

Answer: A

Explanation:
Explanation

 

NEW QUESTION 114
You are designing storage for 20 TB of text files as part of deploying a data pipeline on Google Cloud. Your input data is in CSV format. You want to minimize the cost of querying aggregate values for multiple users who will query the data in Cloud Storage with multiple engines. Which storage service and schema design should you use?

  • A. Use Cloud Storage for storage. Link as permanent tables in BigQuery for query.
  • B. Use Cloud Bigtable for storage. Link as permanent tables in BigQuery for query.
  • C. Use Cloud Storage for storage. Link as temporary tables in BigQuery for query.
  • D. Use Cloud Bigtable for storage. Install the HBase shell on a Compute Engine instance to query the Cloud Bigtable data.

Answer: A

 

NEW QUESTION 115
Which of the following statements is NOT true regarding Bigtable access roles?

  • A. To give a user access to only one table in a project, grant the user the Bigtable Editor role for that table.
  • B. To give a user access to only one table in a project, you must configure access through your application.
  • C. Using IAM roles, you cannot give a user access to only one table in a project, rather than all tables in a project.
  • D. You can configure access control only at the project level.

Answer: A

Explanation:
Explanation
For Cloud Bigtable, you can configure access control at the project level. For example, you can grant the ability to:
Read from, but not write to, any table within the project.
Read from and write to any table within the project, but not manage instances.
Read from and write to any table within the project, and manage instances.
Reference: https://cloud.google.com/bigtable/docs/access-control

 

NEW QUESTION 116
When using Cloud Dataproc clusters, you can access the YARN web interface by configuring a browser to connect through a ____ proxy.

  • A. HTTPS
  • B. VPN
  • C. SOCKS
  • D. HTTP

Answer: C

Explanation:
When using Cloud Dataproc clusters, configure your browser to use the SOCKS proxy. The SOCKS proxy routes data intended for the Cloud Dataproc cluster through an SSH tunnel.
Reference: https://cloud.google.com/dataproc/docs/concepts/cluster-web- interfaces#interfaces

 

NEW QUESTION 117
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. Special browser
  • B. SSH tunnel
  • C. FTP connection
  • D. VPN connection

Answer: B

Explanation:
Explanation
To connect to the web interfaces, it is recommended to use an SSH tunnel to create a secure connection to the master node.
Reference:
https://cloud.google.com/dataproc/docs/concepts/cluster-web-interfaces#connecting_to_the_web_interfaces

 

NEW QUESTION 118
You want to automate execution of a multi-step data pipeline running on Google Cloud. The pipeline includes Cloud Dataproc and Cloud Dataflow jobs that have multiple dependencies on each other. You want to use managed services where possible, and the pipeline will run every day. Which tool should you use?

  • A. Workflow Templates on Cloud Dataproc
  • B. Cloud Scheduler
  • C. cron
  • D. Cloud Composer

Answer: D

 

NEW QUESTION 119
Cloud Bigtable is Google's ______ Big Data database service.

  • A. Relational
  • B. SQL Server
  • C. NoSQL
  • D. mySQL

Answer: C

Explanation:
Explanation
Cloud Bigtable is Google's NoSQL Big Data database service. It is the same database that Google uses for services, such as Search, Analytics, Maps, and Gmail.
It is used for requirements that are low latency and high throughput including Internet of Things (IoT), user analytics, and financial data analysis.
Reference: https://cloud.google.com/bigtable/

 

NEW QUESTION 120
You architect a system to analyze seismic data. Your extract, transform, and load (ETL) process runs as a series of MapReduce jobs on an Apache Hadoop cluster. The ETL process takes days to process a data set because some steps are computationally expensive. Then you discover that a sensor calibration step has been omitted. How should you change your ETL process to carry out sensor calibration systematically in the future?

  • A. Add sensor calibration data to the output of the ETL process, and document that all users need to apply sensor calibration themselves.
  • B. Modify the transformMapReduce jobs to apply sensor calibration before they do anything else.
  • C. Develop an algorithm through simulation to predict variance of data output from the last MapReduce job based on calibration factors, and apply the correction to all data.
  • D. Introduce a new MapReduce job to apply sensor calibration to raw data, and ensure all other MapReduce jobs are chained after this.

Answer: B

 

NEW QUESTION 121
Flowlogistic Case Study
Company Overview
Flowlogistic is a leading logistics and supply chain provider. They help businesses throughout the world manage their resources and transport them to their final destination. The company has grown rapidly, expanding their offerings to include rail, truck, aircraft, and oceanic shipping.
Company Background
The company started as a regional trucking company, and then expanded into other logistics market.
Because they have not updated their infrastructure, managing and tracking orders and shipments has become a bottleneck. To improve operations, Flowlogistic developed proprietary technology for tracking shipments in real time at the parcel level. However, they are unable to deploy it because their technology stack, based on Apache Kafka, cannot support the processing volume. In addition, Flowlogistic wants to further analyze their orders and shipments to determine how best to deploy their resources.
Solution Concept
Flowlogistic wants to implement two concepts using the cloud:
Use their proprietary technology in a real-time inventory-tracking system that indicates the location of

their loads
Perform analytics on all their orders and shipment logs, which contain both structured and unstructured

data, to determine how best to deploy resources, which markets to expand info. They also want to use predictive analytics to learn earlier when a shipment will be delayed.
Existing Technical Environment
Flowlogistic architecture resides in a single data center:
Databases

8 physical servers in 2 clusters
- SQL Server - user data, inventory, static data
3 physical servers
- Cassandra - metadata, tracking messages
10 Kafka servers - tracking message aggregation and batch insert
Application servers - customer front end, middleware for order/customs

60 virtual machines across 20 physical servers
- Tomcat - Java services
- Nginx - static content
- Batch servers
Storage appliances

- iSCSI for virtual machine (VM) hosts
- Fibre Channel storage area network (FC SAN) - SQL server storage
- Network-attached storage (NAS) image storage, logs, backups
Apache Hadoop /Spark servers

- Core Data Lake
- Data analysis workloads
20 miscellaneous servers

- Jenkins, monitoring, bastion hosts,
Business Requirements
Build a reliable and reproducible environment with scaled panty of production.

Aggregate data in a centralized Data Lake for analysis

Use historical data to perform predictive analytics on future shipments

Accurately track every shipment worldwide using proprietary technology

Improve business agility and speed of innovation through rapid provisioning of new resources

Analyze and optimize architecture for performance in the cloud

Migrate fully to the cloud if all other requirements are met

Technical Requirements
Handle both streaming and batch data

Migrate existing Hadoop workloads

Ensure architecture is scalable and elastic to meet the changing demands of the company.

Use managed services whenever possible

Encrypt data flight and at rest

Connect a VPN between the production data center and cloud environment

SEO Statement
We have grown so quickly that our inability to upgrade our infrastructure is really hampering further growth and efficiency. We are efficient at moving shipments around the world, but we are inefficient at moving data around.
We need to organize our information so we can more easily understand where our customers are and what they are shipping.
CTO Statement
IT has never been a priority for us, so as our data has grown, we have not invested enough in our technology. I have a good staff to manage IT, but they are so busy managing our infrastructure that I cannot get them to do the things that really matter, such as organizing our data, building the analytics, and figuring out how to implement the CFO' s tracking technology.
CFO Statement
Part of our competitive advantage is that we penalize ourselves for late shipments and deliveries. Knowing where out shipments are at all times has a direct correlation to our bottom line and profitability.
Additionally, I don't want to commit capital to building out a server environment.
Flowlogistic's management has determined that the current Apache Kafka servers cannot handle the data volume for their real-time inventory tracking system. You need to build a new system on Google Cloud Platform (GCP) that will feed the proprietary tracking software. The system must be able to ingest data from a variety of global sources, process and query in real-time, and store the data reliably. Which combination of GCP products should you choose?

  • A. Cloud Load Balancing, Cloud Dataflow, and Cloud Storage
  • B. Cloud Pub/Sub, Cloud Dataflow, and Cloud Storage
  • C. Cloud Pub/Sub, Cloud Dataflow, and Local SSD
  • D. Cloud Pub/Sub, Cloud SQL, and Cloud Storage

Answer: D

 

NEW QUESTION 122
Your company's customer and order databases are often under heavy load. This makes performing analytics against them difficult without harming operations. The databases are in a MySQL cluster, with nightly backups taken using mysqldump. You want to perform analytics with minimal impact on operations. What should you do?

  • A. Mount the backups to Google Cloud SQL, and then process the data using Google Cloud Dataproc.
  • B. Add a node to the MySQL cluster and build an OLAP cube there.
  • C. Connect an on-premises Apache Hadoop cluster to MySQL and perform ETL.
  • D. Use an ETL tool to load the data from MySQL into Google BigQuery.

Answer: C

 

NEW QUESTION 123
You designed a database for patient records as a pilot project to cover a few hundred patients in three clinics.
Your design used a single database table to represent all patients and their visits, and you used self-joins to generate reports. The server resource utilization was at 50%. Since then, the scope of the project has expanded.
The database must now store 100 times more patient records. You can no longer run the reports, because they either take too long or they encounter errors with insufficient compute resources. How should you adjust the database design?

  • A. Shard the tables into smaller ones based on date ranges, and only generate reports with prespecified date ranges.
  • B. Partition the table into smaller tables, with one for each clinic. Run queries against the smaller table pairs, and use unions for consolidated reports.
  • C. Add capacity (memory and disk space) to the database server by the order of 200.
  • D. Normalize the master patient-record table into the patient table and the visits table, and create other necessary tables to avoid self-join.

Answer: D

 

NEW QUESTION 124
Which of the following are examples of hyperparameters? (Select 2 answers.)

  • A. Number of hidden layers
  • B. Number of nodes in each hidden layer
  • C. Biases
  • D. Weights

Answer: A,B

Explanation:
If model parameters are variables that get adjusted by training with existing data, your hyperparameters are the variables about the training process itself. For example, part of setting up a deep neural network is deciding how many "hidden" layers of nodes to use between the input layer and the output layer, as well as how many nodes each layer should use. These variables are not directly related to the training data at all.
They are configuration variables. Another difference is that parameters change during a training job, while the hyperparameters are usually constant during a job.
Weights and biases are variables that get adjusted during the training process, so they are not hyperparameters.
Reference: https://cloud.google.com/ml-engine/docs/hyperparameter-tuning-overview

 

NEW QUESTION 125
You are deploying a new storage system for your mobile application, which is a media streaming service. You decide the best fit is Google Cloud Datastore. You have entities with multiple properties, some of which can take on multiple values. For example, in the entity 'Movie'the property 'actors'and the property 'tags' have multiple values but the property 'date released' does not. A typical query would ask for all movies with actor=<actorname>ordered by date_releasedor all movies with tag=Comedyordered by date_released. How should you avoid a combinatorial explosion in the number of indexes?

  • A. Set the following in your entity options: exclude_from_indexes = 'actors, tags'
  • B. Set the following in your entity options: exclude_from_indexes = 'date_published'
  • C. Manually configure the index in your index config as follows:
  • D. Manually configure the index in your index config as follows:

Answer: C

 

NEW QUESTION 126
Which is the preferred method to use to avoid hotspotting in time series data in Bigtable?

  • A. Hashing
  • B. Field promotion
  • C. Randomization
  • D. Salting

Answer: B

Explanation:
By default, prefer field promotion. Field promotion avoids hotspotting in almost all cases, and it tends to make it easier to design a row key that facilitates queries.
Reference: https://cloud.google.com/bigtable/docs/schema-design-time-series#ensure_that_your_row_key_avoids_hotspotting

 

NEW QUESTION 127
......


Training Courses Recommended for the Exam Preparation

Training courses are meant to help candidates to learn about the Google exam syllabus and prepare well. It has hands-on labs and expert support that will allow you to get in-depth knowledge of each domain covered in the test. So, these are some of the best training courses offered by Google for the Professional Data Engineer certification exam.

 

Latest Professional-Data-Engineer Exam Dumps Google Exam from Training: https://www.briandumpsprep.com/Professional-Data-Engineer-prep-exam-braindumps.html

Newly Released Professional-Data-Engineer Dumps for Google Cloud Certified Certified: https://drive.google.com/open?id=1_wEvK0My41-Mc-Gi2ey80sjSa2TLydm6