Google Cloud

Google Cloud Certified – Associate Data Practitioner

PR000306

Become a certified Associate Data Practitioner with exam code PR000306 to validate your data skills in Google Cloud.

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

Questions 461–470 of 492

Q461

A company needs to query large datasets quickly without needing a data warehouse. What should they use?

  • A Cloud SQL
  • B BigQuery
  • C Firestore
  • D Dataflow
Explanation BigQuery is optimized for fast SQL queries on large datasets; Cloud SQL and Firestore are not designed for large-scale analytical queries.
Q462

You are configuring IAM policies in Google Cloud. What happens if you assign a role at the project level and then at the folder level?

  • A Folder role overrides project role
  • B Project role overrides folder role
  • C Both roles are combined
  • D No role is effective
Explanation Roles assigned at a more specific level (folder) take precedence over broader levels (project).
Q463

Which service is best for real-time streaming analytics?

  • A Pub/Sub
  • B Cloud Storage
  • C BigQuery
  • D Cloud Functions
Explanation Pub/Sub is designed for real-time data processing, while others are for storage and analysis.
Q464

A company needs low-latency access to frequently accessed data. Which storage class should they choose?

  • A Coldline
  • B Regional
  • C Nearline
  • D Archive
Explanation Regional storage offers low-latency access, while others are for infrequent use.
Q465

What happens when you assign an IAM role to a service account?

  • A It gains access rights.
  • B It loses all permissions.
  • C It merges roles with other accounts.
  • D It can only access public resources.
Explanation Assigning a role grants access rights, while others misrepresent role assignments.
Q466

Which Google Cloud service is designed for data warehousing?

  • A BigQuery
  • B Cloud Storage
  • C Cloud SQL
  • D Dataflow
Explanation BigQuery is a serverless data warehouse; others serve different data needs.
Q467

A company needs to provide temporary access to a limited resource in GCP. What should they use?

  • A IAM roles with predefined permissions
  • B Service accounts with permanent keys
  • C IAM roles with condition-based access
  • D Public permissions on the resource
Explanation Condition-based IAM roles offer time-limited access; others do not limit the access duration effectively.
Q468

You are configuring a Pub/Sub topic. What happens when you exceed the message size limit?

  • A Message is truncated silently
  • B Message is dropped and not sent
  • C Error returned to sender
  • D Message queued for later delivery
Explanation Exceeding the limit returns an error; others misrepresent the outcome or violate protocol.
Q469

Which service provides serverless data processing in real-time?

  • A Cloud Functions
  • B Cloud Pub/Sub
  • C Cloud Dataproc
  • D Cloud Storage
Explanation Cloud Pub/Sub is designed for real-time message processing; the other options serve different purposes.
Q470

A company needs to analyze unstructured data. Which Google Cloud tool should they use?

  • A BigQuery
  • B Cloud SQL
  • C Dataproc
  • D Cloud Datastore
Explanation Cloud Datastore is suited for unstructured data; BigQuery and Cloud SQL are more for structured data analytics.