A company needs to analyze large datasets using SQL. Which service should they use?
ACloud SQL
BBigQuery
CCloud Spanner
DCloud Datastore
Explanation
BigQuery is designed for analyzing large datasets; Cloud SQL is for relational databases, Cloud Spanner is for transactional workloads, and Cloud Datastore is for NoSQL databases.
Q472
Which Google Cloud service provides scalable cloud-based SQL databases?
ACloud SQL
BBigtable
CFireStore
DSpanner
Explanation
Cloud SQL offers managed SQL databases, unlike others which target NoSQL or different use cases.
Q473
A company needs to ensure their Compute Engine instances run under a specific security context. What should they configure?
ACustom IAM role
BService account
CVPC network
DFirewall rules
Explanation
Service accounts allow for specific access controls for instances, while others do not provide the same contextual security.
Q474
You are configuring a Pub/Sub subscription to only receive messages published within the last 30 days. What happens if a message is older than this duration?
AIt will still be received.
BIt is dropped silently.
CAn error is thrown.
DIt is archived for later retrieval.
Explanation
Messages older than the retention period are discarded, hence they are dropped silently and not delivered.
Q475
Which service allows you to run containers in Google Cloud?
AGoogle Kubernetes Engine
BGoogle App Engine
CCloud Functions
DCloud Run
Explanation
Google Kubernetes Engine is specifically designed for container orchestration, while Cloud Run is for serverless container execution.
Q476
A company needs to share data without exposing full database access. Which Google Cloud service should they use?
ABigQuery
BCloud Firestore
CCloud SQL
DCloud Storage Signed URLs
Explanation
Cloud Storage Signed URLs allow secure access to specific files without exposing database details.
Q477
You are configuring IAM permissions for a service account. What happens if you grant the 'Viewer' role but deny 'roles/owner'?
AService account can read resources
BService account gets no access
CService account can change IAM roles
DService account can delete resources
Explanation
The 'Viewer' role allows read access, while denying 'Owner' prevents changes to IAM roles.
Q478
Which service allows you to automate deployment in Google Cloud?
ACloud Build
BCloud Pub/Sub
CCloud Functions
DCloud Storage
Explanation
Cloud Build automates build and deployment processes, while the others serve different purposes.
Q479
A company needs to securely manage API keys. Which Google Cloud service should they use?
ASecret Manager
BCloud Functions
CCloud Tasks
DApp Engine
Explanation
Secret Manager securely stores sensitive data like API keys, unlike the other options.
Q480
What happens when you enable Auto Scaling on a Google Compute Engine instance group?
AConsistent CPU usage only
BInstances will always increase
CDynamic number of instances adjusts
DBilling stops during scaling
Explanation
Auto Scaling adjusts the number of instances based on workload demand, while other options are incorrect.