A retail company wants to build a data platform that allows different business units to own and manage their own data while enabling cross-domain data sharing. Which architectural approach best aligns with these requirements?
Gcp De Designing Systems
Question · Medium
Your organization needs to share datasets with external partners while maintaining control over data access and usage. Which Google Cloud solution provides a secure data exchange marketplace for this purpose?
Question · Easy
Chapter 1: Security, IAM, and Data Protection
1.1 Cloud IAM, Service Accounts, and Resource Hierarchy in GCP Data Systems
Study guide
A company needs to build a data platform that can query data stored in Google Cloud Storage, Amazon S3, and Azure Data Lake Storage using BigQuery without moving the data. Which service enables this capability?
Tech Exam Prep Podcast
Listen on Spotify
Podcast
You are designing a data lake architecture that needs to provide unified data management across data lakes and data warehouses with fine-grained access control. Which Google Cloud service should you use?
Your team needs to create a storage layer that allows BigQuery to query data in Cloud Storage with fine-grained access control at the row and column level. Which technology enables this?
When designing a data processing system for a global company, which factor is MOST important to consider for minimizing latency for international users?
1.2 Data Encryption, Key Management (CMEK), and Cloud KMS
A financial services company needs to design a data pipeline that processes transactions in real-time for fraud detection while also maintaining historical records for regulatory reporting. Which architecture pattern is most appropriate?
Question · Hard
Which of the following is a key principle of data mesh architecture?
Your company wants to implement a data platform that allows data analysts to discover, understand, and access data assets across the organization through a centralized catalog. Which Google Cloud service provides this capability?
When designing a data pipeline for a use case that requires processing data from IoT devices with sub-second latency requirements, which processing pattern should you choose?
1.3 Sensitive Data Protection: Cloud DLP, De-identification, and Masking
You need to ingest change data capture (CDC) events from an Oracle database into BigQuery with minimal latency. Which Google Cloud service is purpose-built for this use case?
Gcp De Ingesting Processing
Your application needs to process messages from Pub/Sub and perform windowed aggregations on streaming data. Which Apache Beam runner should you use in production?
You need to orchestrate a complex data pipeline that involves multiple steps: extracting data from Cloud SQL, transforming it with Dataflow, and loading it into BigQuery. Which service should you use for workflow orchestration?
Your team needs to build ETL pipelines using a visual interface without writing code. The solution should support data quality checks and lineage tracking. Which Google Cloud service meets these requirements?
Chapter 2: Reliability and Compliance Architecture
2.1 High Availability, Regional vs Multi-Regional Deployments, and Disaster Recovery
In Dataflow, what is the purpose of a FixedWindow transform in a streaming pipeline?
You are using Pub/Sub to ingest messages from multiple producers. Consumers need to process messages at their own pace without affecting other consumers. Which subscription type should you use?
Which Dataflow feature automatically scales the number of worker instances based on pipeline throughput?
You need to implement a data quality check that validates incoming data against predefined rules and routes invalid records to a dead-letter queue. Which approach is most suitable in a Dataflow pipeline?
2.2 Data Residency, Sovereignty, and Regulatory Compliance (HIPAA, GDPR)
Which Pub/Sub message ordering guarantee is provided when using ordering keys?
You are designing a batch data processing pipeline that runs daily. The pipeline needs to handle late-arriving data from the previous day and incorporate it into the correct partition. Which approach should you use?
What is the primary advantage of using Apache Beam for data processing compared to writing custom data processing code?
You need to schedule a Dataflow pipeline to run daily at 2 AM. Which service should you use for scheduling?
2.3 Modern Data Architecture Patterns: Data Mesh, Lakehouse, and Modern Data Stack
In Dataflow, what does the concept of "watermark" represent in streaming pipelines?
You are using Dataform to manage SQL-based data transformations in BigQuery. Which feature allows you to define dependencies between different SQL scripts?
Your streaming pipeline needs to join a high-volume event stream with relatively static reference data that changes daily. Which pattern is most efficient?
You need to store petabytes of structured data for analytical queries with high concurrency. Users will run complex SQL queries including joins and aggregations. Which storage solution is most appropriate?
Gcp De Storing Data
Chapter 3: Cross-Cloud and Federated Governance
3.1 BigLake Architecture: Unified Multicloud Storage and Fine-Grained Access Control
Your application requires a globally distributed database with strong consistency, horizontal scalability, and support for SQL queries. Which Google Cloud database should you use?
You need to store large volumes of time-series data with very high write throughput and low-latency reads by key prefix. Which storage service is best suited for this use case?
In BigQuery, which technique reduces query costs and improves performance when querying large tables?
You need to store files of various formats (images, CSV, JSON) for data processing pipelines. Which storage class in Cloud Storage is most cost-effective for data that is accessed less than once per month?
3.2 BigQuery Omni: Multicloud Analytics Across AWS S3, Azure ADLS, and Google Cloud
Your application requires a fully managed relational database with automatic backups, point-in-time recovery, and support for PostgreSQL. Which service should you use?
When designing a BigQuery table schema for optimal query performance, which practice should you follow?
You need a NoSQL document database with real-time sync capabilities for mobile and web applications. Which database service is most appropriate?
Which BigQuery feature automatically reclaims storage space from deleted or modified rows in time-partitioned tables?
3.3 Analytics Hub and Federated Computational Governance
You need to cache frequently accessed data from Cloud SQL to reduce database load and improve application response times. Which service should you use?
You need to create a dashboard that visualizes BigQuery data and allows business users to explore data through interactive filtering. Which Google Cloud tool is most appropriate?
Gcp De Preparing Analysis
In BigQuery, which SQL clause allows you to define a window for running calculations (like moving averages) over a set of rows related to the current row?
You need to train a machine learning model directly within BigQuery using SQL, without moving data to a separate ML platform. Which BigQuery feature enables this?
Loading more…