{"id":13008,"date":"2026-09-16T05:49:09","date_gmt":"2026-09-16T05:49:09","guid":{"rendered":"https:\/\/www.examlabs.com\/certification\/?p=13008"},"modified":"2026-09-16T05:49:09","modified_gmt":"2026-09-16T05:49:09","slug":"google-associate-cloud-engineer-practice-test-questions-and-exam-dumps-part-19-q361-380","status":"publish","type":"post","link":"https:\/\/www.examlabs.com\/certification\/google-associate-cloud-engineer-practice-test-questions-and-exam-dumps-part-19-q361-380\/","title":{"rendered":"Google Associate Cloud Engineer Practice Test Questions and Exam Dumps Part 19 Q361-380"},"content":{"rendered":"

View Full Google Associate Cloud Engineer Exam Dumps<\/a> and Practice Test Dumps<\/b><\/p>\n

 <\/p>\n

Q361. Which BigQuery feature can improve query performance by organizing table data based on one or more columns?<\/b><\/h3>\n

1)<\/b> Cloud Storage Versioning<\/span>
\n<\/span>2)<\/b> BigQuery clustering<\/span>
\n<\/span>3)<\/b> Cloud NAT<\/span>
\n<\/span>4)<\/b> Cloud Scheduler<\/span><\/p>\n

Correct Answer: 2)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

BigQuery clustering organizes table data based on the values of selected columns. When queries frequently filter or aggregate using those columns, clustering can help BigQuery process relevant data more efficiently. Clustering is particularly useful for large tables where queries repeatedly use specific fields such as customer IDs, regions, or categories. It can be combined with partitioning for additional query optimization. Cloud Storage Versioning preserves object versions, Cloud NAT provides outbound connectivity, and Cloud Scheduler runs scheduled jobs. Therefore, BigQuery clustering is the appropriate feature when the goal is to organize table data around frequently used columns and potentially improve query performance.<\/span><\/p>\n

Q362. A BigQuery table contains several years of transaction data, and queries usually filter by transaction date. Which feature is most appropriate for improving query efficiency?<\/b><\/h3>\n

1)<\/b> BigQuery partitioning<\/span>
\n<\/span>2)<\/b> Cloud CDN<\/span>
\n<\/span>3)<\/b> Cloud VPN<\/span>
\n<\/span>4)<\/b> Cloud Armor<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

BigQuery partitioning divides a table into segments based on a partitioning column or another supported partitioning method. For transaction data spanning several years, partitioning by transaction date allows queries that filter by date to process only the relevant partitions instead of scanning the entire table. This can reduce the amount of data processed and improve query efficiency. Cloud CDN is used for content caching, Cloud VPN provides encrypted network connectivity, and Cloud Armor provides application protection. Therefore, partitioning by transaction date is the most appropriate choice for a large BigQuery table where date-based filtering is common.<\/span><\/p>\n

Q363. A company needs to query data stored in Cloud Storage directly from BigQuery without first loading the data into a native BigQuery table. What should it use?<\/b><\/h3>\n

1)<\/b> BigQuery external table<\/span>
\n<\/span>2)<\/b> Cloud SQL read replica<\/span>
\n<\/span>3)<\/b> Cloud Run revision<\/span>
\n<\/span>4)<\/b> Cloud NAT<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

BigQuery external tables allow BigQuery to query supported data stored outside native BigQuery storage, such as certain files in Cloud Storage. This can be useful when organizations want to analyze existing datasets without first copying all the data into BigQuery-managed storage. External tables can help integrate data sources while keeping the original data in its existing location. A Cloud SQL read replica is designed for database read scaling, Cloud Run revisions represent deployed application versions, and Cloud NAT provides outbound network connectivity. Therefore, a BigQuery external table is the appropriate solution for querying supported Cloud Storage data directly.<\/span><\/p>\n

Q364. A company wants to allow selected users to query specific rows or columns through a controlled BigQuery interface without giving them direct access to the underlying table. Which feature can help?<\/b><\/h3>\n

1)<\/b> Authorized view<\/span>
\n<\/span>2)<\/b> Cloud NAT<\/span>
\n<\/span>3)<\/b> Cloud Router<\/span>
\n<\/span>4)<\/b> Persistent Disk snapshot<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

BigQuery authorized views can provide controlled access to data while limiting users’ direct access to the underlying tables. An organization can create a view that exposes only the required fields or filtered information and then authorize appropriate users or datasets to access that view. This can be useful when analysts need access to selected information without receiving unrestricted access to the source table. Cloud NAT and Cloud Router are networking services, while Persistent Disk snapshots protect VM disk data. Therefore, an authorized view is an appropriate BigQuery feature for providing controlled access to selected data.<\/span><\/p>\n

Q365. An administrator wants BigQuery tables to be automatically deleted after a defined period to control storage costs. Which feature should be configured?<\/b><\/h3>\n

1)<\/b> Table expiration<\/span>
\n<\/span>2)<\/b> Cloud VPN<\/span>
\n<\/span>3)<\/b> IAM Conditions<\/span>
\n<\/span>4)<\/b> Cloud Load Balancing<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

BigQuery table expiration allows administrators to configure a table to expire automatically after a specified period. When the expiration time is reached, the table is automatically deleted. This feature can be useful for temporary datasets, staging tables, test data, or workloads where retaining historical data indefinitely is unnecessary. Automatic expiration can also help organizations manage storage usage without relying on manual cleanup processes. Cloud VPN provides encrypted connectivity, IAM Conditions add conditional authorization logic, and Cloud Load Balancing distributes traffic. Therefore, BigQuery table expiration is the correct feature for automatically removing tables after a defined retention period.<\/span><\/p>\n

Q366. A data analytics team needs to run SQL queries over very large datasets without managing database servers. Which Google Cloud service is best suited for this requirement?<\/b><\/h3>\n

1)<\/b> BigQuery<\/span>
\n<\/span>2)<\/b> Compute Engine<\/span>
\n<\/span>3)<\/b> Cloud DNS<\/span>
\n<\/span>4)<\/b> Cloud NAT<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

BigQuery is a fully managed, serverless data warehouse designed for large-scale analytics using SQL. It allows organizations to analyze large datasets without manually provisioning or maintaining database servers. BigQuery handles much of the underlying infrastructure and can scale resources to support analytical workloads. Compute Engine provides virtual machines and requires users to manage operating-system and instance-level configurations. Cloud DNS provides name resolution, while Cloud NAT supports outbound connectivity for private resources. Therefore, BigQuery is the best choice when a data analytics team needs to execute SQL queries against very large datasets without managing database infrastructure.<\/span><\/p>\n

Q367. A Cloud SQL administrator wants to protect a database against accidental deletion or corruption by maintaining regular copies of the database. Which feature should be enabled?<\/b><\/h3>\n

1)<\/b> Automated backups<\/span>
\n<\/span>2)<\/b> Cloud CDN<\/span>
\n<\/span>3)<\/b> Cloud Router<\/span>
\n<\/span>4)<\/b> VPC Peering<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Cloud SQL automated backups create scheduled backups of a managed relational database instance. These backups can be used to restore database data after accidental deletion, corruption, or other operational problems. Automated backups are an important part of a database recovery strategy and should be configured according to the application’s recovery requirements. Cloud CDN caches content at the edge, Cloud Router exchanges routes dynamically, and VPC Peering connects supported VPC networks privately. None of those services provide database backup functionality. Therefore, Cloud SQL automated backups are the appropriate feature for maintaining regular recoverable copies of a managed database.<\/span><\/p>\n

Q368. A Cloud SQL administrator needs to restore a database to a specific point in time after unwanted data changes occurred. Which capability should be used?<\/b><\/h3>\n

1)<\/b> Point-in-time recovery<\/span>
\n<\/span>2)<\/b> Cloud CDN<\/span>
\n<\/span>3)<\/b> Cloud NAT<\/span>
\n<\/span>4)<\/b> Cloud Scheduler<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Cloud SQL point-in-time recovery allows an administrator to restore a database to a selected point within the available recovery window, depending on the database configuration and supported capabilities. This is useful when unwanted changes, accidental deletions, or data corruption occur and the organization needs to recover the database to a state before the incident. Automated backups provide the foundation for recovery, while transaction logs or equivalent recovery information support restoration to a particular time. Cloud CDN, Cloud NAT, and Cloud Scheduler provide unrelated functionality. Therefore, point-in-time recovery is the appropriate capability for restoring a Cloud SQL database to a specific earlier point.<\/span><\/p>\n

Q369. A production Cloud SQL database requires higher availability if the primary database instance becomes unavailable. Which configuration should be considered?<\/b><\/h3>\n

1)<\/b> High availability configuration<\/span>
\n<\/span>2)<\/b> Cloud Storage Nearline<\/span>
\n<\/span>3)<\/b> BigQuery clustering<\/span>
\n<\/span>4)<\/b> Cloud DNS public zone<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Cloud SQL high availability is designed to improve database availability by providing a standby configuration and enabling failover when the primary instance becomes unavailable. This is particularly important for production workloads where database downtime can affect application availability. High availability should be considered together with backups and other recovery mechanisms because availability and disaster recovery address different operational requirements. Cloud Storage Nearline is a storage class for infrequently accessed objects, BigQuery clustering organizes analytical data, and a public Cloud DNS zone manages internet-facing DNS records. Therefore, a Cloud SQL high availability configuration is the appropriate choice for improving production database availability.<\/span><\/p>\n

Q370. A reporting application generates many read queries against a Cloud SQL database, and the team wants to reduce read load on the primary instance. What should be considered?<\/b><\/h3>\n

1)<\/b> Cloud SQL read replica<\/span>
\n<\/span>2)<\/b> Cloud NAT<\/span>
\n<\/span>3)<\/b> Cloud CDN<\/span>
\n<\/span>4)<\/b> Cloud Scheduler<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

A Cloud SQL read replica can provide a separate database instance that receives replicated data from a primary instance and can serve read traffic. This can help reduce read workload on the primary database and is useful for reporting, analytics, or applications with substantial read requirements. Read replicas are different from high availability configurations: a read replica primarily addresses read scaling, while high availability focuses on availability and failover. Cloud NAT provides outbound connectivity, Cloud CDN caches web content, and Cloud Scheduler executes recurring tasks. Therefore, a Cloud SQL read replica is an appropriate option for distributing read-heavy workloads.<\/span><\/p>\n

Q371. Which Google Cloud database is designed to provide a globally distributed relational database with strong consistency and horizontal scalability?<\/b><\/h3>\n

1)<\/b> Cloud Spanner<\/span>
\n<\/span>2)<\/b> Cloud Storage<\/span>
\n<\/span>3)<\/b> Memorystore<\/span>
\n<\/span>4)<\/b> Cloud Logging<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Cloud Spanner is a managed relational database designed for applications that need strong consistency, horizontal scalability, and the ability to operate across regions or globally. It combines relational database capabilities with distributed architecture, making it suitable for large-scale transactional applications requiring high availability and consistent data across locations. Cloud Storage provides object storage, Memorystore provides in-memory caching, and Cloud Logging collects and manages logs. Therefore, Cloud Spanner is the appropriate database service when an application requires a globally distributed relational database with strong consistency and scalable performance.<\/span><\/p>\n

Q372. A low-latency application needs a globally distributed NoSQL database capable of handling very large numbers of operations with predictable performance. Which service is appropriate?<\/b><\/h3>\n

1)<\/b> Cloud Bigtable<\/span>
\n<\/span>2)<\/b> Cloud DNS<\/span>
\n<\/span>3)<\/b> Cloud Scheduler<\/span>
\n<\/span>4)<\/b> Cloud Build<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Cloud Bigtable is a managed, scalable NoSQL database designed for large analytical and operational workloads that require low latency and high throughput. It is commonly used for time-series data, monitoring data, financial data, and other workloads with very large datasets and high numbers of read and write operations. Bigtable is particularly suitable when applications need scalable key-value or wide-column database capabilities. Cloud DNS manages domain name resolution, Cloud Scheduler handles scheduled tasks, and Cloud Build automates application builds. Therefore, Cloud Bigtable is the appropriate choice for large-scale, low-latency NoSQL workloads.<\/span><\/p>\n

Q373. An application stores user profiles as flexible documents and does not require a traditional relational schema. Which Google Cloud database is a suitable choice?<\/b><\/h3>\n

1)<\/b> Firestore<\/span>
\n<\/span>2)<\/b> Cloud Router<\/span>
\n<\/span>3)<\/b> Cloud CDN<\/span>
\n<\/span>4)<\/b> Cloud KMS<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Firestore is a managed NoSQL document database designed for applications that store structured information as flexible documents. It is commonly used for application data such as user profiles, preferences, application state, and other workloads where a rigid relational schema is not required. Firestore supports document-oriented data models and can integrate with application development platforms and services. Cloud Router manages dynamic routing, Cloud CDN provides content caching, and Cloud KMS manages cryptographic keys. Therefore, Firestore is an appropriate choice when an application needs a managed document database with a flexible data model.<\/span><\/p>\n

Q374. A web application frequently retrieves the same data and needs faster response times by keeping frequently accessed information in memory. Which service should be considered?<\/b><\/h3>\n

1)<\/b> Memorystore<\/span>
\n<\/span>2)<\/b> Cloud Storage Archive<\/span>
\n<\/span>3)<\/b> Cloud DNS<\/span>
\n<\/span>4)<\/b> Cloud Audit Logs<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Memorystore provides managed in-memory data stores that applications can use for caching and other low-latency data access patterns. Keeping frequently requested information in memory can reduce the number of requests sent to a primary database and improve application response times. It is particularly useful for session data, frequently accessed application data, and caching scenarios where very fast access is important. Cloud Storage Archive is designed for long-term object storage, Cloud DNS provides DNS services, and Cloud Audit Logs records administrative and access activity. Therefore, Memorystore is the appropriate service for implementing a managed in-memory cache.<\/span><\/p>\n

Q375. A company needs managed file storage that can be mounted by multiple Compute Engine VMs using the NFS protocol. Which service should be used?<\/b><\/h3>\n

1)<\/b> Filestore<\/span>
\n<\/span>2)<\/b> Cloud Storage<\/span>
\n<\/span>3)<\/b> BigQuery<\/span>
\n<\/span>4)<\/b> Cloud Pub\/Sub<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Filestore provides managed file storage that can be mounted by supported Google Cloud compute workloads using the NFS protocol. It is useful when applications require a shared file system rather than object storage or block storage. Multiple Compute Engine VMs can access the same file system according to the configured network and permissions. Cloud Storage provides object storage, BigQuery is designed for analytics, and Cloud Pub\/Sub provides asynchronous messaging. Therefore, Filestore is the appropriate service when an application requires a managed NFS-based file system that can be shared across multiple compute instances.<\/span><\/p>\n

Q376. An organization wants to move large amounts of data from another cloud provider to Google Cloud over the network without manually creating custom transfer scripts. Which service should be considered?<\/b><\/h3>\n

1)<\/b> Storage Transfer Service<\/span>
\n<\/span>2)<\/b> Cloud DNS<\/span>
\n<\/span>3)<\/b> Cloud Armor<\/span>
\n<\/span>4)<\/b> Cloud Scheduler<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Storage Transfer Service is designed to transfer data into Google Cloud Storage from supported sources, including other cloud storage environments and certain online locations. It provides managed transfer capabilities and can automate large-scale data movement without requiring an organization to build and maintain custom transfer applications. It is especially useful when data can be transferred online and the available network connection is suitable for the migration. Cloud DNS manages DNS records, Cloud Armor provides application protection, and Cloud Scheduler runs scheduled jobs. Therefore, Storage Transfer Service is the appropriate choice for managed online data migration into Cloud Storage.<\/span><\/p>\n

Q377. A company needs to transfer a very large amount of data to Google Cloud, but its internet connection is too slow to complete the transfer within the required timeframe. Which service should it consider?<\/b><\/h3>\n

1)<\/b> Transfer Appliance<\/span>
\n<\/span>2)<\/b> Cloud CDN<\/span>
\n<\/span>3)<\/b> Cloud DNS<\/span>
\n<\/span>4)<\/b> Cloud Functions<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Transfer Appliance is a physical device that can be used to move large quantities of data to Google Cloud when transferring the data over the network would take too long or be impractical. The organization loads the required data onto the appliance and ships it to Google for ingestion into the target Google Cloud environment. This approach can be useful for large-scale migrations where available network bandwidth is limited. Cloud CDN is used for content delivery, Cloud DNS handles name resolution, and Cloud Functions provides event-driven execution. Therefore, Transfer Appliance is the appropriate option for very large offline data transfers.<\/span><\/p>\n

Q378. A development team wants to automate continuous delivery of applications to Google Cloud environments after successful builds. Which service should be considered?<\/b><\/h3>\n

1)<\/b> Cloud Deploy<\/span>
\n<\/span>2)<\/b> Cloud DNS<\/span>
\n<\/span>3)<\/b> Cloud NAT<\/span>
\n<\/span>4)<\/b> Cloud Storage Versioning<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Cloud Deploy is a managed continuous delivery service designed to automate the deployment of applications to supported Google Cloud runtime environments. It can work with build and artifact systems to create a delivery pipeline where successfully built application artifacts are promoted through deployment environments. This helps development teams standardize and automate release processes rather than performing deployments manually. Cloud DNS provides DNS management, Cloud NAT supports outbound connectivity, and Cloud Storage Versioning maintains previous object versions. Therefore, Cloud Deploy is the appropriate service when a team needs managed continuous delivery and controlled application promotion.<\/span><\/p>\n

Q379. An application running in production experiences an unexpected increase in errors, and administrators want Google Cloud to automatically group related application errors for investigation. Which service should be used?<\/b><\/h3>\n

1)<\/b> Error Reporting<\/span>
\n<\/span>2)<\/b> Cloud Scheduler<\/span>
\n<\/span>3)<\/b> Cloud Storage<\/span>
\n<\/span>4)<\/b> Cloud Router<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Error Reporting helps developers and administrators identify and analyze application errors by automatically collecting and grouping certain error events. Instead of manually reviewing every individual error message, teams can use Error Reporting to identify recurring problems and investigate their frequency and impact. This is particularly useful for production applications where errors can occur across many instances or requests. Cloud Scheduler manages recurring tasks, Cloud Storage stores objects, and Cloud Router handles dynamic network routing. Therefore, Error Reporting is the appropriate service for automatically grouping and analyzing application errors in a production environment.<\/span><\/p>\n

Q380. A team needs to execute a sequence of Google Cloud services and HTTP-based operations as an automated workflow without managing servers. Which service is most appropriate?<\/b><\/h3>\n

1)<\/b> Workflows<\/span>
\n<\/span>2)<\/b> Persistent Disk<\/span>
\n<\/span>3)<\/b> Cloud DNS<\/span>
\n<\/span>4)<\/b> Cloud NAT<\/span><\/p>\n

Correct Answer: 1)<\/b><\/p>\n

Explanation:<\/b><\/p>\n

Google Cloud Workflows is a managed orchestration service that allows teams to define and execute sequences of tasks involving Google Cloud services, APIs, and HTTP endpoints. It can coordinate multiple operations and manage the flow between them without requiring the team to maintain dedicated orchestration servers. Workflows is useful for automating multi-step processes such as calling an API, waiting for a result, and then invoking another service based on the outcome. Persistent Disk provides VM storage, Cloud DNS manages name resolution, and Cloud NAT provides outbound connectivity. Therefore, Workflows is the best choice for serverless orchestration of multiple operations.<\/span><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

View Full Google Associate Cloud Engineer Exam Dumps and Practice Test Dumps   Q361. Which BigQuery feature can improve query performance by organizing table data based on one or more columns? 1) Cloud Storage Versioning 2) BigQuery clustering 3) Cloud NAT 4) Cloud Scheduler Correct Answer: 2) Explanation: BigQuery clustering organizes table data based on […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1648,1647],"tags":[],"_links":{"self":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13008"}],"collection":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/comments?post=13008"}],"version-history":[{"count":1,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13008\/revisions"}],"predecessor-version":[{"id":13010,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/posts\/13008\/revisions\/13010"}],"wp:attachment":[{"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/media?parent=13008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/categories?post=13008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.examlabs.com\/certification\/wp-json\/wp\/v2\/tags?post=13008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}