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 171–180 of 492

Q171

You are configuring a Cloud SQL instance. What happens if you set the maintenance window to Friday at 2 AM?

  • A Maintenance runs every Friday.
  • B Maintenance runs only once.
  • C Maintenance time is random.
  • D Maintenance window is ignored.
Explanation Setting the maintenance window defines a recurring schedule for updates every week on that specified day and time.
Q172

Which service is used for real-time data processing in Google Cloud?

  • A Cloud Dataflow
  • B Cloud Storage
  • C BigQuery
  • D Cloud Pub/Sub
Explanation Cloud Dataflow is designed for real-time processing, while others focus on storage or batch processing.
Q173

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

  • A Cloud Functions
  • B Cloud Dataflow
  • C Cloud Spanner
  • D BigQuery
Explanation Cloud Dataflow is optimal for streaming data analysis, unlike the others that cater to different needs or data types.
Q174

You are configuring IAM roles for a new project. What occurs when you assign multiple roles to a user?

  • A User gains all assigned permissions
  • B User loses previous permissions
  • C Only the latest role applies
  • D Permissions are merged without conflict
Explanation A user accumulates all permissions from the assigned roles, while the other options misrepresent role behavior.
Q175

Which service is best for large-scale relational databases?

  • A Cloud SQL
  • B Google Sheets
  • C BigQuery
  • D Cloud Functions
Explanation Cloud SQL is designed for scalable relational databases, unlike the others.
Q176

A company needs to allow external users to authenticate using their Google accounts. What should they implement?

  • A Cloud Identity
  • B Cloud Pub/Sub
  • C Cloud Functions
  • D Google Cloud CDN
Explanation Cloud Identity provides user authentication systems, whereas the others do not.
Q177

What happens when you set a bucket's permissions to public?

  • A Only you can access it.
  • B Anyone can access it.
  • C It becomes a private bucket.
  • D It gets deleted automatically.
Explanation Setting public permissions allows anyone access, while the others misunderstand ACL implications.
Q178

Which service is ideal for real-time data ingestion?

  • A Cloud Pub/Sub
  • B Cloud Storage
  • C BigQuery
  • D Cloud Functions
Explanation Cloud Pub/Sub is designed for real-time messaging, while the others are not optimized for this purpose.
Q179

A company needs to analyze logs stored in Cloud Storage. What would be the most efficient approach?

  • A Export logs to BigQuery
  • B Download logs locally
  • C Use Cloud Functions only
  • D Analyze in Cloud Storage directly
Explanation Exporting logs to BigQuery allows for efficient analysis, unlike the other options, which are not optimal.
Q180

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

  • A Conflicts are ignored
  • B Roll-up permissions apply
  • C Least privilege applies
  • D Most permissive access granted
Explanation In IAM, if conflicting permissions exist, the most permissive access is applied, making D correct.