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 281–290 of 486

Q281

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

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C BigQuery
  • D Cloud SQL
Explanation Cloud Pub/Sub is built for real-time data streaming unlike the others that are for storage and analytics.
Q282

You are configuring access for a new Google Cloud project. What happens if you grant a user the 'roles/viewer' role?

  • A User can view all resources
  • B User can modify resources
  • C User can create new resources
  • D User can delete resources
Explanation The 'viewer' role allows only viewing permissions, not modifications or deletions.
Q283

Which service is most suitable for real-time data processing?

  • A Cloud Dataflow
  • B Cloud Functions
  • C BigQuery
  • D Cloud Storage
Explanation Cloud Dataflow is designed for processing streaming data, while other options are not primarily for real-time processing.
Q284

A company needs to analyze user behavior data stored in a Cloud SQL database. Which approach is best for running complex queries and visualizing the results?

  • A BigQuery with federated queries
  • B Direct SQL queries in Cloud SQL
  • C Cloud Storage file exports
  • D Dataflow transformations on Cloud SQL
Explanation BigQuery with federated queries allows for efficient analysis of data in Cloud SQL without exporting data.
Q285

What happens when you set a Pub/Sub topic's message retention period to zero?

  • A Messages are never retained.
  • B Messages are retained indefinitely.
  • C Messages are retained for 1 day.
  • D Messages are stored in Cloud Storage.
Explanation Setting the retention period to zero causes messages to be discarded immediately after acknowledgment.
Q286

Which service is designed for analyzing big data with SQL?

  • A BigQuery
  • B Cloud Functions
  • C Cloud Run
  • D App Engine
Explanation BigQuery is specifically designed for SQL-based analytics, while others serve different purposes.
Q287

A company needs a scalable NoSQL database. Which should they use?

  • A Cloud SQL
  • B Firestore
  • C Cloud Spanner
  • D Cloud Storage
Explanation Firestore is a NoSQL database, whereas others are SQL or object storage solutions.
Q288

You are configuring a Dataflow job to process streaming data. What will happen if the job encounters a malformed record?

  • A Job will fail immediately.
  • B Record will be skipped.
  • C Job retries processing the record.
  • D Record will be logged for review.
Explanation Dataflow skips malformed records by default, while others imply job failure or retry without valid behavior.
Q289

Which service would you use for serverless data processing?

  • A Cloud Functions
  • B Cloud Bigtable
  • C Cloud Composer
  • D Cloud Source Repositories
Explanation Cloud Functions allows for serverless execution of code in response to events, while others serve different purposes like data storage or orchestration.
Q290

A company needs to analyze streaming data for real-time insights. Which Google Cloud service is best suited?

  • A Cloud Pub/Sub
  • B Cloud Dataproc
  • C BigQuery
  • D Cloud Storage
Explanation Cloud Pub/Sub is designed for real-time messaging and event-driven architectures, while others are focused on batch processing or storage.