GCP Google Cloud Professional Data Engineer Practice Questions At Ceralith Commerce, you are deploying a MySQL database workload to Cloud SQL.
GCP Google Cloud Professional Data Engineer Practice Questions
0% Completed
Premium Set: 1 [ + Detailed Explanations] Free Preview
At Westriq Processing, you manage a Managed Service for Apache Spark cluster.
Reading
At Brinlora Analytics, you want to schedule a number of sequential load and transformation jobs.
Reading
At Havorixa Platforms, you have thousands of Apache Spark jobs running in an on-premises Apache Hadoop cluster.
Reading
At Kelvara Business Intelligence, you use a SQL-based visualization tool with data stored in BigQuery.
Reading
At Navorent Governance, your organization requires newly created supported Google Cloud resources to be limited to the europe-west3 region.
Reading
At Mavelynx Data, you recently deployed several processing workflows into a Managed Service for Apache Airflow Gen 2 environment.
Reading
At Brinlume Retail, your company is implementing a data warehouse in BigQuery.
Reading
At Norvixa Marketing, terabytes of customer-behavior data stream from Google Analytics into BigQuery every day.
Reading
At Orvelis Analytics, you are a BigQuery administrator supporting data consumers who run ad hoc queries and downstream reports in tools such as Looker.
Reading
At Axionera Economic Consulting, you help companies identify economic trends as they happen.
Reading
At Ilyvora Streaming, a Dataflow pipeline writes aggregated order data to a 4 GB Basic Tier Memorystore for Redis instance.
Reading
At Joventra Health, healthcare data is owned and managed by separate teams across multiple storage services.
Reading
At Navoris Capital, you analyze a company's stock price from a Pub/Sub stream with Dataflow.
Reading
At Bidlume Auctions, your globally distributed auction application allows users to bid on items.
Reading
At Delphiron Retail, you want to integrate online ordering with voice-based assistants and smart-home devices.
Reading
At Orlixia Manufacturing, your company produces 20,000 files every hour.
Reading
At Luminex Messaging, you are preparing to deploy new code for a subscriber to a Pub/Sub subscription.
Reading
At Lumorix Messaging, you are designing an event-driven clickstream system with Pub/Sub and a consumer application that uses a push subscription.
Reading
At Kelvarix Reporting, weekly executive reports are generated from data stored in BigQuery.
Reading
At Jovarin Financial, customers register online and their registration events are published to Pub/Sub before being loaded into BigQuery.
Reading
At Orvanta Applications, you are designing a pipeline that publishes application events to a Pub/Sub topic.
Reading
At Plendora Foods, you are designing the database schema for a machine learning-based food ordering service that will predict what users want to eat.
Reading
At Iverona Marketing, you administer shared BigQuery datasets that contain views used by several teams.
Reading
At Lendorix Media, you need to modernize an existing on-premises data platform.
Reading
At Nuvatrix Devices, you are choosing a NoSQL database to handle telemetry submitted by millions of Internet-of-Things devices.
Reading
At Xelvanta Shipping, handheld scanners read shipping labels and send tracking events to Kafka.
Reading
At Cormeva Logistics, you operate vehicle sensors around the world and currently use small local data centers to collect their events.
Reading
At Brinorix Data, you are designing a Dataflow pipeline that reads from Cloud Storage and writes to BigQuery.
Reading
At Avelora Financial, you are planning to use Dialogflow CX to create a customer-service chatbot for the company's mobile application.
Reading
At Mavorenta Analytics, you designed a BigQuery warehouse for sales analysis.
Reading
At Zenvoria Insights, you use BigQuery as your data warehouse.
Reading
At Brinovex Partners, you use a BigQuery dataset for analysis and want to provide third-party companies with access to the same dataset.
Reading
At Arclovia IoT, you are building a streaming pipeline from Pub/Sub through Dataflow to BigQuery.
Reading
At Teralynx Data, your organization has been collecting and analyzing data in BigQuery for six months.
Reading
At Orlentra Enterprises, your organization is modernizing its IT services on Google Cloud.
Reading
At Havorent Security, your organization has two Google Cloud projects, Project A and Project B.
Reading
At Zorvexa Streaming, a Node.js subscriber pulls messages from Pub/Sub, processes them, and writes results to BigQuery.
Reading
At Aerovanta Commerce, you use Pub/Sub to ingest clickstream data into Google Cloud for analytics.
Reading
At Quorista Analytics, you are implementing security best practices for a data pipeline.
Reading
At Mavorix Realty, you are preparing 6 TB of home-sales data for machine learning.
Reading
At Aerovexa Products, you migrated a data backend for an application that serves 10 PB of historical product data for analytics.
Reading
At Joventra Pipelines, you have a production streaming pipeline that consumes data from a Pub/Sub subscription.
Reading
At Yondriva Data, you operate three data-processing workflows.
Reading
At Halverix Logistics, live package-tracking events are sent through Apache Kafka and loaded into BigQuery.
Reading
At Kestriva Retail, you are migrating a purchase table to BigQuery.
Reading
At Mailvanta Labs, you are training a spam classifier and notice that the model is overfitting the training data.
Reading
At Bravonix Research, you have three years of historical data in BigQuery and a pipeline that appends new data every day.
Reading
At Velquanta Systems, your company is loading comma-separated values (CSV) files into BigQuery.
Reading
At Inveriq Media, your company runs a large on-premises Hadoop environment that uses Spark, Hive, and HDFS.
Reading
At Auralith Systems, your company has a hybrid and multi-cloud initiative.
Reading
Premium Set: 2 [ + Detailed Explanations] Free Preview
At Jovarix Analytics, you need to copy time-series transaction data into BigQuery for a data-science team.
Reading
At Cendoris Operations, you have uploaded five years of log data to Cloud Storage.
Reading
At Iverixa Streaming, you have an Apache Beam pipeline running on Dataflow that reads from a Pub/Sub topic and writes output to Cloud Storage.
Reading
At Doventis Systems, you are integrating an internal IT application with BigQuery so users can submit BigQuery queries through the application's interface.
Reading
At Elarion Holdings, you need to configure BigQuery access for several departments.
Reading
At Lumorex MultiCloud, your organization stores data in both Cloud Storage and Amazon S3, with all relevant datasets located in United States regions.
Reading
At Gavorin Libraries, you are migrating an application that tracks books and book attributes such as author and publication year from an on-premises relational warehouse to BigQuery.
Reading
At Fyntrava Mobile, you have enabled the integration between Google Analytics for Firebase and BigQuery.
Reading
At Deltovara Messaging, you are designing a streaming data-processing pipeline.
Reading
At Kelorin Research, you are designing a cloud-native historical data-processing system with these requirements.
Reading
At Hynovex Analytics, you are architecting a data-transformation solution for BigQuery.
Reading
At Brinova Events, your company receives both batch-based and streaming event data.
Reading
At Quakentia Research, you architect a system to analyze seismic data.
Reading
At Elarvanta Security, a customer-managed encryption key in Cloud Key Management Service that was used to encrypt Cloud Storage objects has been exposed.
Reading
At Havorent Storage, you are designing an application whose pipelines read raw data from one Cloud Storage bucket and write processed data to another bucket.
Reading
At Kelvorix Retail, you have a BigQuery table containing millions of sales rows and partitioned by date.
Reading
At Cendrix Labs, you have a two-dimensional classification dataset with numerical features X and Y.
Reading
At Gavorin Financial, transactional data is currently stored in an on-premises PostgreSQL database.
Reading
At Gavorix Streaming, you operate a Dataflow streaming pipeline that aggregates events from a Pub/Sub subscription within windows and writes the resulting aggregates to a Cloud Storage bucket.
Reading
At Ivarent Warehousing, you are migrating your data warehouse to Google Cloud and decommissioning the on-premises data center.
Reading
At Kelmorix Data Exchange, different teams in your organization store customer and performance data in BigQuery.
Reading
At Ferlunia AI, you are building a real-time prediction pipeline that receives files that can contain personally identifiable information, stores them in Cloud Storage, and eventually loads derived data into BigQuery.
Reading
At Cartovexa Retail, an online retailer runs its application on App Engine.
Reading
At Inveroxa Agriculture, you have a BigQuery table named sensors that is approximately 500 MB and stores 5,000 sensor records with columns such as id, name, and location.
Reading
At Lumivera Analytics, you have approximately one petabyte of analytical data.
Reading
At Lumerin Pipelines, you submit a new Dataflow batch job.
Reading
At Jorvexa Real Estate, you are preparing data that a machine-learning team will use to train a model with BigQuery ML.
Reading
At Lumetrix Games, you launched a gaming application almost three years ago.
Reading
At Campanexa Media, your company is building campaign data pipelines from Pub/Sub streaming data.
Reading
At Elqora Analytics, you are building a Google Cloud data pipeline and need a visual, low-code method to prepare data for a logistic regression workflow.
Reading
At Aerovanta Analytics, your analytics team wants to build a simple statistical model to determine which customers are most likely to work with your company again based on several metrics.
Reading
At Jovelyra Markets, you use Bigtable to store and serve stock-market data for several major market indices.
Reading
At Fendoria Processing, an upstream process writes data to Cloud Storage.
Reading
At Kelvoris Reporting, you are maintaining an existing report-only BigQuery warehouse that uses the BigQuery Storage Write API (REST) for streaming ingestion into a staging table.
Reading
At Elarvix Security, you want to encrypt customer data stored in BigQuery.
Reading
At Drelvanta Analytics, you want to rebuild a batch pipeline for structured data on Google Cloud.
Reading
At Fyntrava Markets, you operate an application that stores stock trades in Bigtable and calculates the average stock price for a selected company over an adjustable time range.
Reading
At Corvixa Finance, your company is migrating an on-premises data warehouse to BigQuery.
Reading
At Cerlovia Streaming, your infrastructure team has established Cloud Interconnect connectivity between Google Cloud and your on-premises network.
Reading
At Evorixa Data, you are testing a Dataflow batch pipeline that ingests and transforms text files.
Reading
At Grelvanta Data Mesh, you are designing a data mesh by using Knowledge Catalog to manage data stored in BigQuery and Cloud Storage.
Reading
At Jorvanta Data Mesh, you manage a Knowledge Catalog lake with raw and curated zones.
Reading
At Denvorix Data Mesh, you migrated an on-premises HDFS data lake to Cloud Storage.
Reading
At Hynovex Digital, you need to assign each new website user a globally unique identifier by calling an external service from an Apache Beam pipeline.
Reading
At Fenvorix Analytics, your data-analyst team runs ad hoc BigQuery queries and scheduled SQL pipelines in a project assigned to a reservation with 2,000 slots.
Reading
At Dovelyra Data, you are planning to load existing on-premises data into BigQuery.
Reading
At Lumeryn AI, you are developing a model to identify the factors that lead to sales conversions for your customers.
Reading
At Ceralith Commerce, you are deploying a MySQL database workload to Cloud SQL.
Reading
At Iventara Mobility, you use Firestore in Datastore mode to ingest vehicle telemetry in real time.
Reading
At Helioxen Devices, you currently send telemetry from globally distributed IoT devices to a single on-premises Kafka cluster in a US data center.
Reading
Premium Set: 3 [ + Detailed Explanations]
At Cendorva Commerce, you are developing a deep-learning model that predicts a customer's likelihood of purchasing from your ecommerce site.
Reading
At Norvexa Manufacturing, your company purchases as many as 750 different component types from different suppliers.
Reading
At Halcyrix Data, you are selecting services to transform JSON messages from Pub/Sub and write the results to BigQuery.
Reading
At Norvexa Privacy, a BigQuery dataset contains customer street addresses.
Reading
At Mavorina Privacy, you are preparing an organization-wide analytical dataset.
Reading
At Grendoris Apps, you are building a new application that continuously generates data throughout the day.
Reading
At Novalith Capital, your financial-services company is moving 50 TB of financial time-series data to Google Cloud.
Reading
At Kenvoria Publishing, you are developing an application on Google Cloud that should automatically generate subject labels for users' blog posts.
Reading
At Pendorix AI, you are solving a natural-language regression problem with 100 million labeled examples.
Reading
At Pryntara Infrastructure, a BigQuery table named dataset.inventory_vm stores virtual-machine inventory.
Reading
At Celyrion Chemicals, customer orders require manual review.
Reading
At Invaris Media, your infrastructure includes a set of YouTube channels.
Reading
At Asterwyn Analytics, you use BigQuery as your centralized analytics platform.
Reading
At Orlivena Apps, your startup runs a web application for customers in a single Asian region. Before receiving new funding, your priority is to minimize cost.
Reading
At Doventra Telecom, you are designing a data warehouse in BigQuery to analyze sales data.
Reading
At Ceralynx Legal, you have important legal-hold documents in a Cloud Storage bucket.
Reading
At Norvexa Applications, multiple applications with dynamically changing public IP addresses must connect to a Cloud SQL instance by using its public IP address.
Reading
At Kelvorin Web Analytics, you are using Dataflow to build a streaming pipeline that analyzes website click activity from Pub/Sub.
Reading
At Orbinex Health, your organization maintains a BigQuery dataset containing user-level data.
Reading
At Genvora Medical Analytics, your company needs to retrieve very large result sets from an existing medical-information system containing more than 10 TB of data and store those results in new tables for additional analysis.
Reading
At Brivanta Retail, the marketing team regularly provides updates for a portion of the customer dataset.
Reading
At Maventra Cloud Services, a customer requests daily reports showing use of Google Cloud compute resources and the identities responsible for that activity.
Reading
At Lumericore Data, you are designing storage for 20 TB of CSV input data in a Google Cloud data pipeline.
Reading
At Jorvexa Research, you are designing storage for very large text datasets in a Google Cloud data pipeline.
Reading
At Briventa Travel, the company's data platform ingests CSV dumps of booking data and user-profile data from upstream sources into Cloud Storage.
Reading
At Orlithic Vision, your team has built a specialized TensorFlow image-recognition model whose training loop is dominated by custom C++ TensorFlow operations that perform large matrix multiplications.
Reading
At Feralune Streaming, you are running a Dataflow streaming pipeline with Streaming Engine and Horizontal Autoscaling enabled.
Reading
At Joventra Customer Data, you are designing a managed data lake on Google Cloud for large volumes of customer-interaction data arriving from websites.
Reading
At Avenora Airlines, you need to store weather data in a BigQuery table.
Reading
At Mavorin Finance, you are designing storage for two relational tables that are part of a 10 TB database on Google Cloud.
Reading
At Gendorix Database Services, you have an Oracle database deployed on a VM in a Virtual Private Cloud network.
Reading
At Ferlixa Markets, you are building a platform that shares real-time financial-market data with customers.
Reading
At Avenlora Dataworks, your team is building a data lake platform on Google Cloud.
Reading
At Draxenor Applications, a United States-based company operates an application that assesses and responds to user actions.
Reading
At Doventra Retail, you are implementing a chatbot to streamline customer service for an online retailer.
Reading
At Orlinexa Migration, you are migrating a large number of files from a public HTTPS endpoint to Cloud Storage.
Reading
At Elvoria Aerospace, an aerospace company uses a proprietary data format to store flight data.
Reading
At Graventa Media, you are developing a recommendation application on Google Cloud that should display new videos to customers based on their previous viewing history.
Reading
At Ferluma Streaming, you stream data through Kafka into a Redis cluster, and both clusters run on Compute Engine VMs.
Reading
At Iverona Health Finance, you are defining the governance strategy for a BigQuery table that contains both medical and financial information.
Reading
At Havorent Retail, your company is concerned about its BigQuery analytical spend. Several frequently executed queries repeatedly calculate the same aggregation by store ID over continuously updated sales-volume data.
Reading
At Ordelia Travel, your company operates in three business domains: airlines, hotels, and ride-hailing.
Reading
At Bravelyra Analytics, you are loading CSV files from Cloud Storage into BigQuery.
Reading
At Norevix Visualization, the organization has a Google Cloud folder named Visualization containing two projects.
Reading
At Elvaris Pipelines, you are deploying a Dataflow batch pipeline that reads from Cloud Storage, transforms the data, and writes the results to BigQuery.
Reading
At Asteronix Logistics, you need to migrate 1 PB of data from an on-premises data center to Google Cloud.
Reading
At Elvarion AI, a data scientist has created a BigQuery ML model.
Reading
At Brivexa Insights, you need to query data from a particular BigQuery table several times each day.
Reading
At Cenvoria Group, your organization is rapidly expanding its use of Google Cloud.
Reading
At Ferlunex Brokerage, an online brokerage needs a secure high-volume queuing architecture that triggers trade-processing jobs.
Reading
Premium Set: 4 [ + Detailed Explanations]
At Ravelynx Analytics, you receive CSV data files monthly from a third party.
Reading
At Iventora Lakehouse, you plan to use Cloud Storage as part of a data-lake solution.
Reading
At Solvexa AI, your neural network model is taking several days to train.
Reading
At Trelvion Data, you are responsible for writing your company's ETL pipelines to run on an Apache Hadoop cluster.
Reading
At Inveroxa Metrics, a Dataflow job aggregates time-series metrics and writes them to Bigtable.
Reading
At Norellix Platforms, you need to migrate an on-premises Redis database to Memorystore for Redis.
Reading
At Maventra Warehousing, you want to migrate an existing Teradata data warehouse to BigQuery.
Reading
At Iverion Services, you are designing a system that requires an ACID-compliant relational database.
Reading
At Jorvexa Retail, you use BigQuery with a regional dataset that includes a table containing daily sales volumes.
Reading
At Kelmora Platforms, you are building a data pipeline that connects two classes of applications: job generators and job runners.
Reading
At Gavorin Automation, you use Workflows to call an API that returns a 1 KB JSON response, apply complex business logic to that response, wait until the logic is complete, and then start a load from a Cloud Storage file into BigQuery.
Reading
At Orvexa Pipelines, you maintain ETL pipelines.
Reading
At Jorvexa Data Integration, you have several file-based data sources, including Apache Parquet and CSV.
Reading
At Halynta Retail, you administer a BigQuery environment that uses on-demand pricing.
Reading
At Belvaris Group, you lead business intelligence for a large enterprise with multiple business units that have different priorities and budgets.
Reading
At Pheronix AI, a TensorFlow training workload runs on n2-standard-32 Compute Engine VMs and takes approximately two days to finish.
Reading
At Quorvanta Analytics, you run a BigQuery project with on-demand pricing and execute a change data capture (CDC) process that ingests data.
Reading
At Kelvorin Business Analytics, business users need a way to clean and prepare data before analyzing it.
Reading
At Elarvix Engineering, you want to migrate an Apache Spark 3 batch job from an on-premises environment to Google Cloud.
Reading
At Joventra Research, several scheduled Spark jobs run on a Managed Service for Apache Spark cluster.
Reading
At Lumeryn Reporting, your company uses Looker Studio connected to BigQuery for reporting.
Reading
At Kelvanta Consumer Analytics, you are preparing an organization-wide analytical dataset.
Reading
At Lavorent Commerce, you need to create a Spanner transaction table that stores product-sales records.
Reading
At Kendoris Insights, you use BigQuery and Looker Studio to create a customer-facing dashboard that displays large quantities of aggregated data.
Reading
At Renvora Compliance, government regulations in your industry require you to maintain an auditable record of access to certain types of data.
Reading
At Lumeris Analytics, you run BigQuery jobs in two projects: • The production project runs high-priority jobs with strict completion-time SLAs.
Reading
At Norvexa Analytics, each analytics team runs BigQuery jobs in its own Google Cloud project.
Reading
At Lumivara Bank, government regulations require protection of customers' personally identifiable information (PII).
Reading
At Avenquor Analytics, you migrated ETL jobs to BigQuery and need to verify that the migrated jobs produce the same output as the original jobs.
Reading
At Orivant Streamworks, you operate a production Dataflow streaming pipeline.
Reading
At Vantorix Media, your company maintains a hybrid deployment with Google Cloud, where analytics are performed on anonymized customer data.
Reading
At Norelixa Migration, your company is migrating a large on-premises data warehouse to BigQuery.
Reading
At Dovantis Group, you are migrating an on-premises data warehouse to BigQuery.
Reading
At Brivorix Commerce, your large ecommerce company uses BigQuery for its data-warehousing needs.
Reading
At Auralenix Financial, your financial services company has a critical daily reconciliation process that involves several distinct steps.
Reading
At Mavoris Governance, your company has raw and processed data distributed across multiple Cloud Storage buckets and BigQuery datasets.
Reading
At Orventa Platforms, an on-premises platform generates approximately 100 GB of data every day in millions of structured newline-delimited JSON text files.
Reading
At Havorix Industries, you have 15 TB of data in an on-premises data center that must be transferred to Google Cloud every week.
Reading
At Norlixa Governance, your team must encrypt all BigQuery data by using encryption keys controlled by the data-governance team.
Reading
At Orvanta Engineering, your company uses separate Google Cloud projects for development, staging, and production.
Reading
At Renvoria Data, you are designing a fault-tolerant architecture for data stored in a regional BigQuery dataset.
Reading
At Jynvara Platforms, you are implementing open-source workflow scheduling for data pipelines and need the environment to integrate with Google Kubernetes Engine and a Shared VPC.
Reading
At Fynora Data, you are configuring networking for a Dataflow job.
Reading
At Hoventra Workflows, you are deploying an Apache Airflow DAG in a Managed Service for Apache Airflow Gen 2 environment.
Reading
At Redvanta Compute, you have a data-processing application that runs on Google Kubernetes Engine (GKE).
Reading
At Quellora AI, you want to create a machine-learning model with BigQuery ML and host the model on a Gemini Enterprise Agent Platform endpoint.
Reading
At Iverona Integration, you have several file-based data sources in your on-premises environment and in the cloud.
Reading
At Merovix Holdings, data analysts currently have the Owner basic role in the Google Cloud projects they manage.
Reading
At Havorix Streaming, a Dataflow streaming pipeline reads messages from Pub/Sub and writes results to a BigQuery dataset located in the EU multi-region.
Reading
At Quorvanta Archives, you need to move 2 PB of historical data from an on-premises storage appliance to Cloud Storage within six months, and your outbound network capacity is constrained to 20 Mb/sec.
Reading
Premium Set: 5 [ + Detailed Explanations]
At Zenvorix IoT, you operate an IoT pipeline built around Apache Kafka that normally receives approximately 5,000 messages per second.
Reading
At Kelvoria Streamworks, you are designing an Apache Beam pipeline on Dataflow to enrich continuously arriving Pub/Sub events with static reference data stored in BigQuery.
Reading
At Telmora Sensors, you collect IoT sensor data from millions of devices worldwide and store it in BigQuery.
Reading
At Suntrivix Ads, you need advertising data to serve AI models and to retain historical data for analytics.
Reading
At Aqualynx Caching, you use a Standard Tier Memorystore for Redis instance in production.
Reading
At Jorvanta Services, you use Bigtable for a latency-sensitive production application with a heavy mixture of reads and writes.
Reading
At Yendarix Governance, you have a BigQuery dataset named customers.
Reading
At Velnoria Governance, your organization's data assets are stored in BigQuery, Pub/Sub, and a PostgreSQL instance running on Compute Engine.
Reading
At Bravion Partners, you have a BigQuery dataset protected with customer-managed encryption keys (CMEK).
Reading
At Elarix Digital, you need to load multiple terabytes of clickstream data into BigQuery.
Reading
At Teralynx Retail, you are creating a BigQuery data model for retail transaction data.
Reading
At Auralynx Security, a BigQuery table receives data directly from a Pub/Sub BigQuery subscription.
Reading
At Kelvora Platforms, you need to orchestrate a simple sequential pipeline consisting of a batch Dataflow job, followed by a BigQuery query job, followed by a Gemini Enterprise Agent Platform batch inference job.
Reading
At Xorvanta Data, your organization's data lake uses BigQuery for storage, and Dataflow ingestion pipelines read from Pub/Sub and write to partitioned BigQuery tables.
Reading
At Braventa Messaging, your company is selecting a centralized event-ingestion and delivery system.
Reading
At Solviora Dataworks, you want to migrate an on-premises Hadoop system to Managed Service for Apache Spark.
Reading
At Hoventra Bank, you have a labeled historical dataset containing loan applications that were approved, together with whether each granted loan later defaulted.
Reading
At Elvarix Data, your team develops and maintains ETL pipelines.
Reading
At Yavellix Pipelines, a Dataflow pipeline reads data from Cloud Storage and writes results to BigQuery.
Reading
At Varelium Insights, you are migrating a data warehouse to BigQuery.
Reading
At Cendoria Research, your team runs a complex analytical BigQuery query every day that processes multiple terabytes of data.
Reading
At Ventariq Shipping, live package-tracking events are consumed from Kafka and stored in BigQuery.
Reading
At Xendora Retail, you maintain critical sales data in a BigQuery multi-region dataset.
Reading
At Xandoria Advertising, you developed Spark ML models on-premises to predict advertisement click-through rates.
Reading
At Yavoren Shipping, a global shipping company needs to train a model on 40 TB of data to predict which ships in each geographic region are likely to cause delivery delays on a given day.
Reading
At Jovaria Customer Experience, you are building a Dataflow pipeline to ingest customer feedback.
Reading
At Fendoria Homes, you are training a fully connected neural network to predict housing prices.
Reading
At Ivernova Analytics, you are designing a BigQuery table for a very large clickstream dataset.
Reading
At Wexorin Data, you want to build a managed Hadoop-based data lake.
Reading
At Fynlora Data Lake, your Cloud Storage data lake has separate buckets for raw, processed, and historical data.
Reading
At Zorentha Support, you have a BigQuery customer-order table containing data for approximately 10 million customers and totaling about 10 PB.
Reading
At Lumorex Data, a pipeline writes data to Bigtable using well-designed row keys.
Reading
At Bravelyth Research, you created a Google Cloud analytics environment so that data scientists can explore data without impacting the on-premises Apache Hadoop system.
Reading
At Teralux Systems, you are implementing several batch jobs that must run on a schedule.
Reading
At Iverexa Software, you need to migrate a 2 TB relational database to Google Cloud.
Reading
At Lumivex Analytics, a data analyst needs to load 200 CSV files averaging 15 MB each from a Cloud Storage bucket into BigQuery every day.
Reading
At Ulveriq Streaming, you created a new version of a Dataflow streaming ingestion pipeline that reads from Pub/Sub and writes to BigQuery.
Reading
At Gavorent Research, your data-science team needs to perform interactive SQL queries on large datasets stored in Apache Parquet format in Cloud Storage.
Reading
At Draxelia Research, you migrated an Apache Hadoop workload from an on-premises cluster to Managed Service for Apache Spark with data in Cloud Storage.
Reading
At Zorvexa Platforms, you maintain Apache Airflow DAG code in a Git repository.
Reading
At Westralis Data, your organization is implementing a data-mesh operating model.
Reading
At Solvanta Sensors, you are building a streaming Dataflow pipeline that ingests noise measurements from hundreds of sensors near construction sites across a city.
Reading
At Ulvexia Media, a live television show asks viewers to cast votes from their mobile phones during a three-minute voting period.
Reading
At Glynvora Systems, you run MariaDB databases on Compute Engine VM instances and need monitoring and alerting with Google Cloud Observability.
Reading
At Helyntix Media, you analyze user clickstream data to personalize content recommendations.
Reading
At Avenlith Services, you plan to deploy Cloud SQL for MySQL.
Reading
At Wendaris Analytics, you need to create a SQL pipeline.
Reading
At Doventra Knowledge Systems, your company wants to implement a Retrieval-Augmented Generation (RAG) system that allows employees to query an extensive knowledge base of internal documents such as policy manuals and project reports.
Reading
At Corvanta Media, you have an on-premises Apache Kafka cluster whose topics contain web-application logs.
Reading
At Umbriq Shipping, a shipping company has distribution centers where packages move along conveyor lines for routing.
Reading
Premium Set: 6 [ + Detailed Explanations]
At Evorlynx Manufacturing, machines in a car factory publish measurement messages to a Pub/Sub topic.
Reading
At Ceralune Analytics, you store relational analytical data in BigQuery in United States locations.
Reading
At Asterivon Analytics, you monitor and optimize BigQuery for your team.
Reading
At Noveriq Archives, you keep historical structured files in Cloud Storage.
Reading
At Genvoria Bank, a large bank operates throughout North America and needs a database for bank-account transactions.
Reading
At Fynvora Sensors, you have a network of 1,000 sensors. Each sensor generates one time-series metric per second with a timestamp.
Reading
At Vexoria Labs, you want to automate a multi-step data pipeline on Google Cloud.
Reading
At Brinovara Financial, your company stores vital operational sales data in a BigQuery dataset in us-central1.
Reading
At Fynlora Retail, you are building a logistic regression model in BigQuery ML to predict whether a customer is likely to purchase your company's products.
Reading
At Teralume Finance, you store critical data in BigQuery.
Reading
At Clyverin Data, you are planning to migrate an on-premises Apache Hadoop deployment to Google Cloud.
Reading
At Brinexora Financial, you are migrating an on-premises data warehouse to BigQuery.
Reading
At Fynloria Media, a web server sends click events to a Pub/Sub topic.
Reading
At Pryntoria Compliance, your organization stores highly sensitive employee data in BigQuery.
Reading
At Ulverna Data, you used BigQuery data preparation to create a reusable set of cleansing and transformation steps from a sample of a BigQuery table.
Reading
At Aerolith Data Systems, you need to choose a database for a new project that has the following requirements:
Reading
At Quendora Sensors, you need to ingest minute-resolution readings from 50,000 sensors into a BigQuery table.
Reading
At Evarin Data Operations, you have data pipelines running on BigQuery, Dataflow, and Managed Service for Apache Spark.
Reading
At Ceralynx Retail, you are integrating a legacy on-premises MySQL database into a new Google Cloud data warehouse.
Reading
At Ordelix Benchmarks, your team has created several curated BigQuery datasets containing anonymized industry benchmark data.
Reading
At Cendorix Telemetry, you need to choose a database to store time-series CPU and memory usage for millions of computers.
Reading
At Elvarion Lakehouse, you created a BigQuery external table over Apache Hive-partitioned data in a Cloud Storage bucket containing a very large number of files.
Reading
At Brivanta Commerce, a mid-sized enterprise needs to move its operational transaction database from an on-premises environment to Google Cloud.
Reading
At Prenalix Analytics, you have a query that filters a BigQuery table by timestamp and ID columns.
Reading
At Doventra Fraud Analytics, you are developing a fraud-detection model using BigQuery ML.
Reading
At Brinovexa Streaming, you run a Dataflow streaming pipeline that uses hopping windows to group arriving events.
Reading
At Syntarion Retail, you need to create a near-real-time inventory dashboard that reads inventory data from BigQuery.
Reading
At Raventrix Health, you need to copy millions of sensitive patient records from an on-premises relational database to BigQuery.
Reading
At Denvorix Research, your data-science team has a variety of structured files in Cloud Storage that it wants to use for model development.
Reading
At Gavorixa Retail, you are preparing data to serve a sales-demand prediction model.
Reading
At Deltanox Archives, you want to archive highly sensitive data in Cloud Storage.
Reading
At Davoriq Customer Analytics, a BigQuery environment contains customer records with sensitive columns such as names and addresses.
Reading
At Cendorix Commerce, customer-order data is stored in Bigtable.
Reading
At Fynlora Payments, you are building a system to process financial transactions.
Reading
At Drelvanta Mobility, you are designing a real-time system for a ride-hailing application.
Reading
At Celyntis Data, an Apache Beam pipeline running on Dataflow in Project A uses JdbcIO to connect to a Cloud SQL for PostgreSQL instance in Project B.
Reading
At Evoranta Data, you are building an ELT solution in BigQuery by using Dataform.
Reading
At Norevanta Processing, you are designing a stateful Dataflow pipeline that reads data from Cloud Storage and writes transformed data to BigQuery.
Reading
At Alveriq Data Systems, you orchestrate ETL pipelines by using Managed Service for Apache Airflow.
Reading
At Denvoria AI, your team is solving a binary-classification problem.
Reading
At Elvaron Database Services, a Cloud SQL for PostgreSQL primary instance runs in Region 1 and has cross-region read replicas in Region 2 and Region 3.
Reading
At Orixenta Logistics, your company needs to upload historical data from on-premises systems to Cloud Storage.
Reading
At Grelvoria Archives, you have 100 GB of outdated data stored in a BigQuery table.
Reading
At Grelvanta Analytics, your organization stores customer data in an on-premises Apache Hadoop cluster in Parquet format.
Reading
At Elarvion Media, your organization has thousands of images stored in Cloud Storage.
Reading
At Drelvanta Data, a Dataflow streaming job reads messages from a message bus that does not itself provide exactly-once delivery.
Reading
At Cendoria Processing, you are designing a Dataflow batch pipeline.
Reading
At Evoralis Security, you need to deploy additional dependencies to all nodes of a Managed Service for Apache Spark cluster during startup by using an existing initialization action.
Reading
At Aerovinta Analytics, you want to store your team's shared tables in a single BigQuery dataset so that the data is easily accessible to several analysts.
Reading
At Meridaxa Social, you need to analyze hundreds of thousands of social-media posts once per day at the lowest cost and with the fewest processing steps.
Reading
Announcements Reviews Live Classes Course Info
PreviousNext

Action Disabled

<strong>Please enable JavaScript in your browser settings and refresh this page.</strong>

error:

Printing Disabled

Exporting or saving lessons as PDF is not permitted.
Please study online in your KloudExams account.

KLOUDExams • Protected