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 61–70 of 486

Q61

Which Google Cloud service is best for real-time analytics?

  • A BigQuery
  • B Cloud Storage
  • C Dataflow
  • D Cloud SQL
Explanation Dataflow is designed for real-time data processing, while the others focus on storage or batch processing.
Q62

A company needs to transfer large volumes of data to Google Cloud. What is the recommended service?

  • A Cloud Functions
  • B Transfer Appliance
  • C Cloud Pub/Sub
  • D Bigtable
Explanation Transfer Appliance is specifically designed for large data transfers, unlike the other options, which serve different purposes.
Q63

You are configuring IAM roles for a service account. What happens if you assign roles with overlapping permissions?

  • A Permissions are deducted.
  • B Only the highest role applies.
  • C All permissions are combined.
  • D Conflicts cause a failure.
Explanation All roles assigned to a service account combine permissions, increasing authorization levels rather than conflicting.
Q64

Which Google Cloud service is primarily used for data warehousing?

  • A BigQuery
  • B Cloud Firestore
  • C Cloud Spanner
  • D Cloud SQL
Explanation BigQuery is designed for analytics and data warehousing, while others serve different database needs.
Q65

A company needs to analyze massive datasets in real-time. Which solution is best for this?

  • A Dataflow
  • B Dataproc
  • C Compute Engine
  • D App Engine
Explanation Dataflow enables real-time data processing, while others are not optimized for this use case.
Q66

You are configuring a Data Loss Prevention (DLP) API. What happens when you set the risk threshold to low?

  • A More information is scanned
  • B Data masking is applied
  • C Less sensitive data is detected
  • D Tasks are processed faster
Explanation A low threshold leads to less sensitive data being flagged, while A, B, and D misrepresent the behavior.
Q67

Which service is best for real-time data analytics?

  • A BigQuery
  • B Cloud Pub/Sub
  • C Cloud Storage
  • D Dataflow
Explanation Dataflow allows for real-time data processing, while BigQuery is optimized for batch analytics.
Q68

A company needs to migrate a large relational database to Cloud SQL without downtime. What should they implement?

  • A Replica set configuration
  • B Two-phase commit protocol
  • C Database Migration Service
  • D Cloud Spanner
Explanation Database Migration Service supports minimal downtime migration for relational databases.
Q69

You are configuring a GCP IAM policy. What happens if a resource's access policy denies access, but the user's group grants it?

  • A Access is granted only
  • B Access is denied
  • C Access is granted depending on roles
  • D Access is audited
Explanation GCP follows the principle of 'deny overrides allow', so access is denied.
Q70

Which service is best for serverless data processing?

  • A Cloud Dataflow
  • B Cloud Storage
  • C Cloud Spanner
  • D Cloud Pub/Sub
Explanation Cloud Dataflow is designed for serverless data processing, while the others serve different purposes.