Medium CDL practice questions

A financial services company is moving sensitive workloads to Google Cloud. Their compliance team wants a way to see near-real-time logs whenever a Google support or engineering employee accesses their content, including the reason for that access, so they can independently verify that provider staff are not viewing data without justification. Which Google Cloud capability directly meets this requirement?

A company's finance team notices that their Compute Engine spending has grown steadily, and they suspect many VMs are oversized or idle. The cloud operations team wants an automated way to receive specific, data-driven suggestions to reduce costs without manually inspecting every resource. Which Google Cloud capability should they use?

A financial services company runs a demanding PostgreSQL-based application that mixes high-volume transactional workloads with frequent complex analytical queries on the same operational data. They want a fully managed Google Cloud database that stays PostgreSQL-compatible, delivers superior transactional performance, and accelerates analytical queries without forcing a rewrite of their existing application. Which service best fits these needs?

A retail company has a monolithic inventory system running on-premises. The digital team wants to let external mobile and partner developers consume inventory data without exposing the legacy backend directly, while adding rate limiting, authentication, and usage analytics. Which Google Cloud product best addresses this need?

A financial services company has built several internal services that partner organizations now want to consume programmatically. Leadership wants to expose these services externally with consistent security, usage quotas per partner, developer onboarding through a self-service portal, and the ability to track and eventually charge for API consumption. Which Google Cloud product best meets these requirements?

A retail company has built several backend microservices that expose data to internal teams and a few external partners. Leadership is concerned about inconsistent security enforcement, no visibility into which teams call which services, and difficulty enforcing rate limits across the different APIs. They want a single layer to manage, secure, and monitor all of their APIs without rewriting the backends. Which Google Cloud product should they adopt?

A retail company wants to build a custom image classification model to sort product photos into their own proprietary catalog categories. Their team has labeled training data but has no machine learning engineers or coding expertise, and they want to train the model without writing code. Which Google Cloud approach best fits their needs?

A retail analytics team has built interactive dashboards on top of a BigQuery dataset. As adoption grows, business users complain that the dashboards feel slow when many people filter and drill down at the same time. The team wants to accelerate these repeated, interactive queries without redesigning their tables or moving data to another system. Which Google Cloud capability best addresses this need?

A retail analytics team wants to automatically load their Google Ads and YouTube marketing report data into their BigQuery data warehouse on a recurring daily schedule, without building or maintaining any custom ingestion code. Which Google Cloud capability best meets this need?

A retail analytics team wants to enrich their sales data with demographic and weather information to understand regional buying patterns. They do not want to source, license, and load this external data themselves, and they want to join it directly with their existing tables using SQL. Which Google Cloud capability best meets this need?

A retail analytics team already stores several years of sales history in BigQuery. Data analysts who are proficient in SQL want to build and run a product-demand forecasting model, but the company has no dedicated machine learning engineers and wants to avoid moving the data to a separate ML platform. Which Google Cloud capability best meets these needs?

A retail company has years of sales transaction data spread across multiple systems. The analytics team wants to run large, complex SQL queries across petabytes of historical, structured data to identify purchasing trends. They do not want to provision, manage, or scale any servers, and they want fast query performance without database administration overhead. Which Google Cloud service best fits this need?

A retail company stores its historical sales data in BigQuery. The marketing analytics team needs to run their own exploratory queries against this data without copying it, and the finance team wants to query the same tables independently. Leadership wants a solution that keeps a single authoritative copy of the data while enabling multiple teams to analyze it concurrently. Which approach best supports making this data useful and accessible across teams?

A logistics company wants operations managers to see near real-time package scan data in their analytics dashboards. Delivery events arrive continuously from thousands of handheld scanners, and analysts want to query the latest events within seconds of them being generated, without waiting for scheduled batch loads. Which approach best supports making this data useful and immediately queryable?

A logistics company collects millions of GPS and sensor readings per second from its delivery fleet. Engineers need a Google Cloud database that offers extremely low latency and high write throughput for this time-series data, and they plan to run analytical scans over massive volumes of these records. Which Google Cloud managed database best fits this workload?

A finance manager at a retail company is concerned that several project teams keep exceeding their allocated monthly cloud spend without anyone noticing until the invoice arrives. She wants a proactive way to be automatically notified as spending approaches predefined thresholds, without hard-stopping the workloads. Which Google Cloud capability best addresses this need?

A hospital's finance committee is reviewing a proposal to keep running its patient records system in an owned, on-premises data center rather than migrating to the cloud. The CFO argues that the on-premises approach gives the organization one specific financial advantage the cloud cannot easily match. Which characteristic of the on-premises capital expenditure model is the CFO most likely referring to?

A retail company's CFO is evaluating a move from on-premises data centers to Google Cloud. Currently, the company makes large upfront purchases of servers and networking hardware every few years, which it depreciates over time. The CFO wants to understand how the cloud will change the company's financial model. Which statement best describes the primary financial shift the company will experience?

A financial services company discovers that an attacker altered several transaction records in a database without authorization. Leadership asks which principle of the CIA triad was violated in this incident. Which principle was primarily compromised?

A retail company's leadership is frustrated that launching a new online promotion feature takes their IT team six months because they must forecast demand, order servers, wait for delivery, and configure hardware before development can even begin. A competitor recently released a similar feature in three weeks. Which characteristic of cloud technology most directly addresses this business problem and explains why cloud is transforming how the company competes?

A retail company runs three separate business units, each with its own Google Cloud projects. Finance wants a single monthly invoice for all business units while still being able to see the individual spend attributed to each unit. Which approach best meets these requirements?

A finance team at a retail company wants to perform detailed, custom analysis of their Google Cloud spending, breaking costs down by label, service, and project over the past year, and joining this data with their internal budgeting spreadsheets. The built-in Cloud Billing reports do not offer the granular, query-based flexibility they need. What should they configure to enable this level of cost analysis?

A retail company runs a promotional flash sale twice a year, during which website traffic spikes to nearly 20 times its normal level for only a few hours. The rest of the year, traffic is steady and predictable. Their on-premises data center was sized to handle these peaks, leaving most servers idle throughout the year. Leadership wants to understand which fundamental characteristic of cloud technology most directly addresses this problem and enables business transformation. Which characteristic should you highlight?

A retail company stores product photos in a Cloud Storage bucket. Whenever a new image is uploaded, they need to automatically generate a thumbnail. The workload is sporadic and event-driven, and the team wants to write only a small piece of code without managing any servers or containers. Which Google Cloud service best fits this requirement?

A retail company runs a small, single-purpose function that validates a shipping address whenever a customer submits a checkout form. Traffic is unpredictable and spiky, and the team wants to write only the function logic without managing servers, containers, or scaling configuration. They also want costs to be zero when there is no traffic. Which Google Cloud service best fits this need?