100% Free CISI ICWIM Practice Test Questions

Question 1

A company stores large amounts of data in Cloud Storage that is only accessed a few times a year for quarterly reports. The data needs to be retained for a minimum of three years for compliance purposes, but retrieval speed is not critical. Which storage class is the most cost-effective option?

A : Nearline

B : Archive

C : Coldline

D : Standard

Answer: C

Question 2

Your team is running a Dataflow streaming job to process and transform log data in real time. You notice a delay in the processed data reaching BigQuery, which suggests a potential bottleneck in the pipeline. You open the Dataflow Job UI to investigate. Which of the following steps in the Dataflow Job UI would be the most effective first step to identify where the bottleneck is occurring?

A : Enable the Debugging Agent on the Dataflow workers

B : Check the Throughput Metrics for each stage in the Job Graph

C : Adjust the auto-scaling settings in the Dataflow UI

D : View the Execution Details to check the pipeline’s windowing configuration

Answer: B

Question 3

A financial services company needs to implement a data pipeline for transactional data, which must be cleansed and validated for compliance purposes before loading into BigQuery. They also plan to conduct further analytics on the data after loading. Which data manipulation methodology is the most appropriate for these requirements?

A : ETLT (Extract, Transform, Load, Transform) to cleanse data, load it into BigQuery, and conduct additional transformations if needed.

B : ELT (Extract, Load, Transform) to load data into BigQuery and perform data cleaning afterward.

C : Batch SQL imports for compliance validation and transformation after ingestion into BigQuery.

D : ETL (Extract, Transform, Load) to ensure data quality and compliance before loading into BigQuery.

Answer: D

Question 4

A financial services company needs to implement a data pipeline for transactional data, which must be cleansed and validated for compliance purposes before loading into BigQuery. They also plan to conduct further analytics on the data after loading. Which data manipulation methodology is the most appropriate for these requirements?

A : ETLT (Extract, Transform, Load, Transform) to cleanse data, load it into BigQuery, and conduct additional transformations if needed.

B : ELT (Extract, Load, Transform) to load data into BigQuery and perform data cleaning afterward.

C : Batch SQL imports for compliance validation and transformation after ingestion into BigQuery.

D : ETL (Extract, Transform, Load) to ensure data quality and compliance before loading into BigQuery.

Answer: D

Question 5

You are tasked with designing a data pipeline that ingests daily transaction logs from Cloud Storage, performs transformations to filter and summarize the data, and loads the result into BigQuery. The pipeline needs to be managed and scheduled to run every night at midnight. Which set of Google Cloud products would best meet these requirements?

A : BigQuery ML to perform transformations, Cloud Functions for scheduling, and Cloud Storage as the final destination.

B : Cloud Composer for orchestration, Cloud Dataflow for transformations, and BigQuery as the final storage.

C : Cloud Functions to trigger, Cloud Storage for transformations, and Dataproc as the final destination.

D : Cloud Scheduler to trigger the pipeline, Pub/Sub for transformations, and BigQuery as the final storage.

Answer: B

Free Practice CISI ICWIM Exam Questions 2025