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
Questions 221–230 of 486
A company needs to analyze large data sets for patterns without a predefined schema. What should they use?
-
A
Google Cloud SQL
-
B
Google BigQuery
-
C
Google Cloud Spanner
-
D
Google Cloud Datastore
Explanation
Google BigQuery is designed for analytical queries on large datasets using a schema-less architecture.
You are configuring IAM roles for a service account that requires read access to Cloud Storage only. Which role should you assign?
-
A
Storage Admin
-
B
Storage Object Viewer
-
C
Storage Object Creator
-
D
Storage Viewer
Explanation
The 'Storage Object Viewer' role allows read access to objects, whereas the others provide higher or incorrect access permissions.
Which service is best for real-time data processing?
-
A
BigQuery
-
B
Dataflow
-
C
Cloud Storage
-
D
Cloud Pub/Sub
Explanation
Dataflow is designed for real-time data streaming, while BigQuery and Cloud Storage are for batch processing and storage, respectively.
A company needs to automate ML model training based on incoming streaming data. What should they use?
-
A
Cloud Functions
-
B
AI Platform Pipelines
-
C
Cloud Run
-
D
Dataflow
Explanation
AI Platform Pipelines allows automation of machine learning workflows, ideal for model training.
What happens when you exceed the quotas for BigQuery?
-
A
Tasks are queued until limits reset
-
B
Queries are automatically optimized
-
C
Excess queries return errors
-
D
Service switches to free tier
Explanation
Exceeding quotas will result in errors for additional queries, preventing processing.
Which Google Cloud service enables you to manage API requests?
-
A
Cloud Functions
-
B
Cloud Endpoints
-
C
Cloud Run
-
D
App Engine
Explanation
Cloud Endpoints specifically provides API management capabilities, whereas the other services focus on compute and serverless functions.
A company needs to analyze streaming data in real-time. Which service should they use?
-
A
BigQuery
-
B
Dataflow
-
C
Dataproc
-
D
Pub/Sub
Explanation
Dataflow is designed for real-time data processing, while the others are not primarily focused on streaming analytics.
What happens when you apply an IAM policy without specifying conditions?
-
A
Policy is ignored
-
B
Policy applies universally
-
C
Policy is only for admins
-
D
Policy cannot be saved
Explanation
Without conditions, the IAM policy applies universally to all specified principals, with no restrictions.
A company needs to analyze streaming data in real-time. Which Google Cloud service is best suited for this task?
-
A
Google Cloud Pub/Sub
-
B
Google Cloud Datastore
-
C
Google Cloud Functions
-
D
Google BigQuery
Explanation
Google Cloud Pub/Sub allows for real-time data ingestion, while the others serve different purposes.
What happens when you set the 'data retention policy' on a Cloud Storage bucket?
-
A
Data will be backed up daily
-
B
Data is deleted after specified time
-
C
Data replication increases
-
D
Data is encrypted automatically
Explanation
Setting a data retention policy ensures data is automatically deleted after a specific period.