Skip to main content

Question 101 to 150

Question 101

You need to copy millions of sensitive patient records from a relational database to BigQuery. Th...

Question 102

You need to create a near real-time inventory dashboard that reads the main inventory tables in y...

Question 103

You have a data stored in BigQuery. The data in the BigQuery dataset must be highly available. Yo...

Question 104

You used Dataprep to create a recipe on a sample of data in a BigQuery table. You want to reuse t...

Question 105

You want to automate execution of a multi-step data pipeline running on Google Cloud. The pipelin...

Question 106

You are managing a Cloud Dataproc cluster. You need to make a job run faster while minimizing cos...

Question 107

You work for a shipping company that uses handheld scanners to read shipping labels. Your company...

Question 108

You have developed three data processing jobs. One executes a Cloud Dataflow pipeline that transf...

Question 109

You have Cloud Functions written in Node.js that pull messages from Cloud Pub/Sub and send the da...

Question 110

You are creating a new pipeline in Google Cloud to stream IoT data from Cloud Pub/Sub through Clo...

Question 111

You have historical data covering the last three years in BigQuery and a data pipeline that deliv...

Question 112

You operate a logistics company, and you want to improve event delivery reliability for vehicle-b...

Question 113

You are a retailer that wants to integrate your online sales capabilities with different in-home ...

Question 114

Your company has a hybrid cloud initiative. You have a complex data pipeline that moves data betw...

Question 115

You use a dataset in BigQuery for analysis. You want to provide third-party companies with access...

Question 116

Your company is in the process of migrating its on-premises data warehousing solutions to BigQuer...

Question 117

You are designing a data processing pipeline. The pipeline must be able to scale automatically as...

Question 118

You need to set access to BigQuery for different departments within your company. Your solution s...

Question 119

You operate a database that stores stock trades and an application that retrieves average stock p...

Question 120

You are operating a Cloud Dataflow streaming pipeline. The pipeline aggregates events from a Clou...

Question 121

You currently have a single on-premises Kafka cluster in a data center in the us-east region that...

Question 122

You decided to use Cloud Datastore to ingest vehicle telemetry data in real time. You want to bui...

Question 123

You need to create a data pipeline that copies time-series transaction data so that it can be que...

Question 124

You are designing a cloud-native historical data processing system to meet the following conditio...

Question 125

You have a petabyte of analytics data and need to design a storage and processing platform for it...

Question 126

You work for a manufacturing company that sources up to 750 different components, each from a dif...

Question 127

You are working on a niche product in the image recognition domain. Your team has developed a mod...

Question 128

You work on a regression problem in a natural language processing domain, and you have 100M label...

Question 129

You use BigQuery as your centralized analytics platform. New data is loaded every day, and an ETL...

Question 130

The marketing team at your organization provides regular updates of a segment of your customer da...

Question 131

As your organization expands its usage of GCP, many teams have started to create their own projec...

Question 132

Your United States-based company has created an application for assessing and responding to user ...

Question 133

A data scientist has created a BigQuery ML model and asks you to create an ML pipeline to serve p...

Question 134

You are building an application to share financial market data with consumers, who will receive d...

Question 135

You are building a new application that you need to collect data from in a scalable way. Data arr...

Question 136

You are running a pipeline in Dataflow that receives messages from a Pub/Sub topic and writes the...

Question 137

You have a data pipeline with a Dataflow job that aggregates and writes time series metrics to Bi...

Question 138

You have several Spark jobs that run on a Cloud Dataproc cluster on a schedule. Some of the jobs ...

Question 139

You are building a new data pipeline to share data between two different types of applications: j...

Question 140

You need to create a new transaction table in Cloud Spanner that stores product sales data. You a...

Question 141

Data Analysts in your company have the Cloud IAM Owner role assigned to them in their projects to...

Question 142

Each analytics team in your organization is running BigQuery jobs in their own projects. You want...

Question 143

You are operating a streaming Cloud Dataflow pipeline. Your engineers have a new version of the p...

Question 144

You need to move 2 PB of historical data from an on-premises storage appliance to Cloud Storage w...

Question 145

You receive data files in CSV format monthly from a third party. You need to cleanse this data, b...

Question 146

You want to migrate an on-premises Hadoop system to Cloud Dataproc. Hive is the primary tool in u...

Question 147

You are implementing several batch jobs that must be executed on a schedule. These jobs have many...

Question 148

You work for a shipping company that has distribution centers where packages move on delivery lin...

Question 149

You are migrating your data warehouse to BigQuery. You have migrated all of your data into tables...

Question 150

You want to build a managed Hadoop system as your data lake. The data transformation process is c...