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 preparing to ingest historical transaction data stored in Cloud Storage into BigQuery. The team requires an open-source, columnar storage format that is natively supported for automated data loading using the BigQuery Data Transfer Service.
Which file format should the team use?
Apache Parquet is an open-source, columnar storage file format designed for efficient data storage and retrieval in big data analytics ecosystems. Unlike row-oriented formats that store entire records sequentially, Parquet organizes data by columns, allowing analytics engines to read only the specific fields necessary to evaluate a query.

Parquet is the standard choice for analytical data lakes on Google Cloud because it combines broad ecosystem compatibility, native BigQuery loading support, compact storage size, and high-performance read efficiency for analytics workloads.
HDF5 (Hierarchical Data Format 5) is a specialized binary data format designed to manage and store extremely large, complex, multidimensional scientific datasets, numerical arrays, and sensor telemetry.
h5py or xarray), converting the data into tabular formats (such as Parquet or CSV), and then writing to BigQuery.The workload involved storing complex multidimensional array data for scientific simulation models, geospatial satellite imagery cubes, or physics simulations processed on Compute Engine virtual machines with high-performance numerical computing libraries.
YAML is a human-friendly, text-based data serialization standard commonly used for application configuration files, CI/CD pipelines, and infrastructure-as-code definitions (such as Kubernetes manifests).
The team needed to define pipeline configuration parameters, specify deployment manifests for containerized workloads in Google Kubernetes Engine (GKE), or structure metadata files for orchestration tools.
Extensible Markup Language (XML) is a text-based, tag-based markup language used primarily for encoding documents and structured configuration data in a human-readable and machine-readable format.
The scenario required transferring legacy enterprise application configuration files or integrating with SOAP-based web service payloads that necessitate document validation using XML Schema Definitions (XSD).
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