Google Cloud Associate Data Practitioner - Full Practice Exam 1

1. A batch workflow should trigger promptly when its required file arrives rather than polling continuously on a fixed schedule. Which approach best fits?
2. A BigQuery workload frequently filters large tables by customer identifier within broad date partitions. Which approach best fits?
3. A business event must independently reach billing, analytics, and customer-notification consumers. Which approach best fits?
4. A company needs to move existing large object collections from a supported source to Cloud Storage on a repeatable managed schedule. Which approach best fits?
5. A daily pipeline must wait until its upstream source import succeeds before running transformations. Which approach best fits?
6. A dashboard is technically correct but mixes currencies without conversion and labels the result as one comparable revenue measure. Which approach best fits?
7. A dashboard should count each customer once even when a customer placed several orders. Which approach best fits?
8. A data platform must discover likely personal-information fields before analysts receive access. Which approach best fits?
9. A data team needs to find unexpected null rates and value distributions before choosing transformations. Which approach best fits?
10. A data team needs to ingest new business events as they occur, with producers and consumers decoupled. Which approach best fits?
11. A database contains highly sensitive fields that only a limited reviewer group should read, while other users may query ordinary columns. Which approach best fits?
12. A database must continuously replicate supported source changes into an analytical pipeline after an initial snapshot, with limited source downtime. Which approach best fits?
13. A dataset has duplicate business records caused by retries, and each event carries a stable unique identifier. Which approach best fits?
14. A dataset needs an identifiable steward, documented meaning, provenance, and quality expectations. Which approach best fits?
15. A division calculation must avoid failing when the denominator is zero and should return a documented missing result. Which approach best fits?
16. A financial system requires relational transactions, strong consistency, and horizontal database scaling across regions. Which approach best fits?
17. A legacy application requires an NFS-mounted shared file system that several Compute Engine VMs can access concurrently. Which approach best fits?
18. A monthly comparison must include months with zero activity rather than omitting them from the chart. Which approach best fits?
19. A partitioned BigQuery table stores daily transactions. A report only needs a narrow date range and should avoid unnecessary scanned partitions. Which approach best fits?
20. A pipeline joins order records to customers, but some orders refer to nonexistent customer identifiers. Which approach best fits?
21. A pipeline needs a clear operational owner and alerts when expected outputs are late. Which approach best fits?
22. A pipeline step calls an external service that sometimes returns transient errors. A timeout may occur after the external action succeeds. Which two practices make retries safer? Select 2 answers.
23. A pipeline step occasionally fails with a transient service error. Repeating it is safe because its outputs are idempotent. Which approach best fits?
24. A pipeline's output schema changes in a way that may break independent downstream consumers. Which approach best fits?
25. A privacy request requires removal of eligible personal records, but some records are subject to a lawful retention requirement. Which approach best fits?
26. A query joins two tables with multiple matching rows per key and unexpectedly multiplies the sales total. Which approach best fits?
27. A query must filter aggregated groups to regions whose total sales exceed a threshold. Which approach best fits?
28. A report describes total sales accurately but must help users see change over time. Which approach best fits?
29. A report needs one row per region with the total sales amount rather than every underlying transaction. Which approach best fits?
30. A report repeatedly performs the same eligible expensive aggregation, and bounded refresh behavior is acceptable. Which approach best fits?
31. A required transaction amount must be nonnegative and expressed in a known currency. The schema only checks that the amount is numeric. Which approach best fits?
32. A source stores numeric amounts as strings, including malformed text. Analysts need typed values without an entire transformation failing on one bad record. Which approach best fits?
33. A SQL-focused team needs reusable warehouse transformations with dependency management and tests close to BigQuery data. Which approach best fits?
34. A stream processor needs an estimate of progress in event time to decide when windows can be considered sufficiently complete. Which approach best fits?
35. A streaming pipeline must aggregate by business event time and account for records that arrive after the usual window completion. Which two configuration decisions directly address these requirements? Select 2 answers.
36. A streaming pipeline must aggregate records by when the business event occurred, even when network delays change arrival order. Which approach best fits?
37. A team needs to rerun an old date partition without duplicating all the previously written records. Which approach best fits?
38. A team writes Apache Beam transformations and wants managed execution for both batch and streaming pipelines. Which approach best fits?
39. A telemetry service performs enormous volumes of low-latency key-based reads and writes. Its wide-column data model does not require relational joins. Which approach best fits?
40. A training dataset includes fields that would only become available after the prediction outcome. Evaluation accuracy looks unrealistically high. Which approach best fits?
41. A transformation should be tested against malformed records and boundary values before production data is processed. Which approach best fits?
42. A VM needs a bootable block device for its operating system and an application that expects a local filesystem on attached storage. Which approach best fits?
43. A web request must return quickly while a background task calls a specific worker endpoint with controlled retries and rate limits. Which approach best fits?
44. An analyst claims that a marketing campaign caused growth solely because both rose together in observational data. Which approach best fits?
45. An analyst needs a cost estimate before executing a large on-demand BigQuery query. Which approach best fits?
46. An analyst needs the most recent order for each customer while keeping its associated columns. Which approach best fits?
47. An analyst receives an occasional small supported CSV file and needs to append it to a BigQuery table without building a permanent streaming pipeline. Which approach best fits?
48. An analyst wants all customers listed, including those with no orders, while attaching matching order details when present. Which approach best fits?
49. An application stores images and exported files accessed by object name over APIs. It does not require a mounted file system. Which approach best fits?
50. An enterprise already has a substantial Apache Spark workload and wants a managed Google Cloud execution environment without rewriting it in Beam. Which approach best fits?
51. An existing PostgreSQL transactional application needs a managed database with minimal engine changes. It does not need worldwide horizontal relational scaling. Which approach best fits?
52. An incoming CSV uses local date formats inconsistently. A pipeline must reliably interpret the values and report invalid rows. Which approach best fits?
53. An orchestration system schedules a streaming job, but an engineer assumes the orchestrator itself transforms every incoming event. Which approach best fits?
54. Analysts need consistent joinable replacements for customer identifiers without access to the original values. Which approach best fits?
55. Analysts should query approved datasets without permission to change production ingestion configuration. Which approach best fits?
56. Different systems represent missing customer values as blanks, NULL, and a literal unknown marker. Reports must apply one documented meaning. Which approach best fits?
57. Disaster-recovery objects are read about once a quarter and kept well beyond 90 days. Retrieval fees are acceptable. Which approach best fits?
58. Executives compare revenue across teams, but each dashboard implements a different calculation. Which approach best fits?
59. Files are expected to be read about once a month and retained for more than 30 days. The team accepts access charges to reduce storage cost. Which approach best fits?
60. Frequently read objects need low access latency and no cold-storage minimum-duration economics. Which Cloud Storage class best fits?

Comments — 0