Google Cloud

Google Cloud Certified – Professional Data Engineer

PR000258
Popular Trending

Become a certified Professional Data Engineer with exam code PR000258 to validate your data engineering skills in Google Cloud.

486 questions 0 views Free
Start Mock Test Timed · Full-length · Scored

Questions 391–400 of 486

Q391

Which service allows you to run SQL queries on large datasets?

  • A BigQuery
  • B Cloud Functions
  • C Cloud Storage
  • D Dataflow
Explanation BigQuery is specifically designed for running SQL queries on large datasets; the others serve different purposes.
Q392

A company needs to analyze streaming data in real-time. Which Google Cloud service should they use?

  • A Cloud Pub/Sub
  • B Cloud SQL
  • C Firestore
  • D Dataproc
Explanation Cloud Pub/Sub is designed for event-driven architectures and can process streaming data in real-time; the others are not optimized for this use-case.
Q393

What happens when you enable versioning on a Google Cloud Storage bucket?

  • A Old objects are deleted
  • B Versions of objects are kept
  • C All objects are archived
  • D Files cannot be overwritten
Explanation Enabling versioning allows multiple versions of objects to be stored; the other options misrepresent how versioning works.
Q394

Which service is best for real-time analytics on streaming data?

  • A Cloud Dataflow
  • B BigQuery
  • C Cloud Storage
  • D Cloud Pub/Sub
Explanation Cloud Dataflow is designed for real-time analytics; BigQuery focuses on batch processing, while Cloud Storage and Pub/Sub are utilities.
Q395

A company needs to store frequently accessed files with low latency. Which storage option should they use?

  • A Cloud Storage Nearline
  • B Cloud Filestore
  • C Cloud Bigtable
  • D Cloud Storage Coldline
Explanation Cloud Filestore offers low latency file storage; other options focus on less frequent access or different use cases.
Q396

What happens when you increase the number of nodes in a Cloud Dataproc cluster?

  • A Prices increase exponentially
  • B Job execution slows down
  • C Memory for jobs decreases
  • D Processing capacity increases
Explanation Increasing nodes enhances processing capacity by providing more compute resources; price increases and job speed are not guaranteed affects.
Q397

Which service is ideal for real-time analytics on streaming data?

  • A BigQuery
  • B Cloud Dataflow
  • C Cloud Storage
  • D Cloud Pub/Sub
Explanation Cloud Dataflow processes streaming data in real-time, while BigQuery is primarily for batch querying. Cloud Storage and Cloud Pub/Sub are for data storage and message queuing respectively.
Q398

A company needs to store sensitive customer data securely. Which GCP service should they use?

  • A Cloud SQL
  • B Cloud Datastore
  • C Cloud Spanner
  • D Google Kubernetes Engine
Explanation Cloud Spanner provides strong consistency and encryption for sensitive data at rest and in transit, unlike Cloud SQL and Cloud Datastore which may not scale as effectively for complex operations. GKE is for container management, not data storage.
Q399

You are configuring IAM roles for a cloud project. What happens if a user has conflicting roles?

  • A User gets the highest privileges
  • B User inherits no permissions
  • C Roles are combined with warnings
  • D User loses all access rights
Explanation In GCP, conflicting roles result in the user being granted the highest level of privileges out of the roles assigned. Therefore, the other options misrepresent how role permissions are assigned.
Q400

Which service is best for large-scale data processing?

  • A Google BigQuery
  • B Google Cloud Functions
  • C Google Cloud Pub/Sub
  • D Google Cloud Storage
Explanation BigQuery is optimized for executing complex queries on large datasets, while the others serve different functions.