Question 1

A company collects customer interaction data in a JSON format and plans to load this data into BigQuery for analysis. The data includes nested fields such as customer details, purchase history, and support interactions. They need a format that maintains the nested structure, supports schema evolution, and provides fast query performance. What format should they convert their JSON data into before loading it into BigQuery?

Options :

A : CSV

B : Apache Parquet

C : Apache Avro

D : JSON

Answer: C

Question 2

Which of the following metrics is most appropriate for evaluating a binary classification model when the dataset has an imbalanced distribution of classes?

Options :

A : Precision

B : Accuracy

C : F1 Score

D : Recall

Answer: C

Question 3

Your team uses Cloud SQL to manage an application database that requires both high availability and disaster recovery. Which of the following configurations will best support these requirements?

Options :

A : Enable automated backups and choose a Multi-Zone configuration.

B : Configure a read replica in a different region.

C : Choose Coldline Storage for backups.

D : Use the standard Cloud SQL instance configuration without any additional settings.

Answer: A

Question 4

You are asked to create a Looker dashboard to help the sales team understand quarterly sales performance across regions. They want to see both total sales and the number of new customers by region, with filters to view specific quarters. Which approach best fulfills this requirement?

Options :

A : Create one chart with a combined line and bar visualization for total sales and new customer count by region. Apply a quarter filter to the chart itself.

B : Use two separate charts: one for total sales by region and another for new customers by region. Apply a dashboard filter for the quarter, which will affect both charts simultaneously.

C : Create a dashboard with one tile showing total sales by month and another showing total customers by region. Apply filters for region and month, but exclude a quarter filter.

D : Create a single table chart that includes total sales, new customer count, and region columns. Set the dashboard filters to allow selection of specific regions.

Answer: B

Question 5

A healthcare organization needs to integrate data from various sources, including patient management systems, IoT devices, and electronic health records (EHRs). They want to process this data for immediate insights as well as store it in a structured data warehouse for long-term analysis. Given the sensitivity of the data and the need to perform some transformations on raw data, which of the following data processing approaches would be most suitable for this scenario?

Options :

A : Real-Time Streaming with ELT

B : ETL (Extract, Transform, Load)

C : Batch Processing with ELT

D : ELT (Extract, Load, Transform)

Answer: B

Higher Test Marks with Free Online Associate-Data-Practitioner Exam Practice

Buying Options: