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 181–190 of 486

Q181

Which service allows for serverless SQL queries on large datasets?

  • A BigQuery
  • B Cloud Spanner
  • C Cloud SQL
  • D Firestore
Explanation BigQuery is designed for serverless analytics on large volumes of data. The other options are either not serverless or focus on relational or NoSQL databases.
Q182

A company needs to store sensitive data securely. Which Google Cloud product should they use?

  • A Cloud Storage
  • B Cloud Firestore
  • C Cloud Key Management
Explanation Cloud Key Management enables secure storage and management of cryptographic keys. The other options do not specifically focus on securing sensitive data cryptographically.
Q183

What happens when you set a CI/CD pipeline to a retry strategy with an exponential backoff for step failures?

  • A Fails immediately after the first attempt
  • B Retries failed steps with increasing intervals
  • C Joins failed step logs for analysis
  • D Stops the entire pipeline indefinitely
Explanation Exponential backoff retries increase wait time between attempts. Options A, C, and D do not accurately describe the retry strategy behavior.
Q184

Which service is best for processing streaming data?

  • A Cloud Pub/Sub
  • B Cloud SQL
  • C Cloud Storage
  • D Cloud Datastore
Explanation Cloud Pub/Sub is designed for message-oriented middleware, enabling real-time data processing, while the other options cater to different data workflows.
Q185

A company needs to ensure low-latency access to its data for every query. Which Database service should they choose?

  • A BigQuery
  • B Cloud Firestore
  • C Cloud Spanner
  • D Cloud Dataflow
Explanation Cloud Spanner is designed for low-latency, scalable global applications, while the others do not guarantee low-latency access in the same way.
Q186

You are configuring IAM policies, which of the following ensures maximum privileges are not accidentally granted?

  • A Grant roles to users directly
  • B Use least privilege principle
  • C Assign full access roles
  • D Share account credentials
Explanation Using the least privilege principle minimizes excessive permissions, while the other options can lead to security risks.
Q187

Which service is used for data warehousing in Google Cloud?

  • A BigQuery
  • B Cloud SQL
  • C Cloud Pub/Sub
  • D Cloud Storage
Explanation BigQuery is specifically designed for data warehousing, while other options serve different purposes.
Q188

A company needs to analyze a large dataset in real-time. What Google Cloud solution should they use?

  • A Cloud Dataflow
  • B Cloud Storage
  • C Cloud Functions
  • D Cloud Spanner
Explanation Cloud Dataflow enables real-time data processing and analytics, while the others are not tailored for that specific need.
Q189

You are configuring IAM roles for a project. What happens if you assign a user a role that grants more permissions than necessary?

  • A Increased security risk
  • B Permissions will be ignored
  • C User access denied
  • D Resources become inaccessible
Explanation Giving excess permissions can heighten security risks, while the other options do not accurately describe the effect of over-permissioning.
Q190

Which service allows you to create and manage data pipelines in Google Cloud?

  • A Cloud Dataflow
  • B BigQuery
  • C Cloud Functions
  • D Firebase
Explanation Cloud Dataflow is specifically designed for creating and managing data pipelines, whereas other services serve different purposes.