Prepare and test your skills
Prepare and test your skills
Free sample question, answered and explained below. The Associate Data Practitioner practice bank has 1,156 more like it. Try 10 free: instant score, no account.
A data analytics team is ingesting e-commerce transaction records from Cloud Storage into BigQuery. Each transaction record contains complex hierarchical information, including nested customer contact details and a repeated list of purchased product line items.
Which file format should the team use to load this data while natively preserving its nested and repeated data structure?
Standard formatted JSON (often structured as a single outer JSON array containing multiple JSON objects separated by commas and spread across multiple indented lines) is the standard format used for configuration files, document stores, and RESTful web API responses.
The requirement called for storing a human-readable application configuration file or exchanging single REST API payload payloads where distributed, high-throughput bulk analytical ingestion is not required.
Comma-Separated Values (CSV) is a flat, text-based data storage format where each row represents a single record, and fields within each row are separated by a delimiter (typically a comma). CSV is widely used across spreadsheet applications, relational database exports, and traditional batch ETL processes due to its simplicity and human readability.
The transaction dataset were strictly tabular with flat scalar fields (such as transaction_id, date, total_amount) where each record represents a single line of data with no nested sub-objects or repeated arrays.
Newline-delimited JSON (often referred to as ndjson or JSON Lines) is a semi-structured, text-based data interchange format where each individual line in a file contains a complete, valid JSON object. In data analytics and ingestion platforms like BigQuery, newline-delimited JSON is the standard JSON format used for batch data loads and streaming ingestion because each record is self-contained and separated by a newline character (\n).
"items": [...]), which BigQuery represents as REPEATED (ARRAY) fields. This allows multiple purchased items to be stored directly inside a single transaction record without requiring denormalization or separate child tables.
Unlike flat, tabular formats such as CSV that only represent two-dimensional rows and columns, newline-delimited JSON allows complex, multi-tiered business objects to be ingested into BigQuery in their natural structure. This avoids the overhead of flattening arrays or maintaining multiple related tables, making it the ideal choice for hierarchical transaction logs.
Plain unstructured text files (TXT) store raw, unformatted text strings without any predefined data model, field delimiters, or standardized object notation. They are commonly generated by legacy server daemons, syslog mechanisms, and simple application print logs.
The objective was to store raw, unstructured system diagnostic outputs or application console logs in Cloud Storage for archival or freeform string pattern matching.
Answer them yourself and get your score the moment you finish. No account needed.
Full access includes
Keep the momentum going with these hand-picked practice scenarios
Last updated