Free CISI ICWIM Exam Questions

Question 1

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

Question 2

A financial services company processes data on stock trades and needs a pipeline to automate data ingestion, transformation, and loading every hour. They require a solution with fine-grained scheduling capabilities, dependency management between tasks, and automatic retries in case of failure. The company also wants to monitor job status and receive alerts when issues occur. Which Google Cloud service best meets these requirements?

A : Cloud Composer, as it provides advanced scheduling, dependency management, and monitoring features.

B : Workflows, as it enables task dependencies and offers robust monitoring and alerting features.

C : Scheduled queries in BigQuery, as they offer automatic scheduling and built-in monitoring.

D : Dataproc Workflow Templates, as they allow scheduling and monitoring without additional configuration.

Answer: A

Question 3

A company wants to migrate a large dataset of historical data from its on-premises storage to Cloud Storage. The dataset is around 100 TB, and the company has a limited network bandwidth, which would make online transfer highly time-consuming and resource-intensive. They need a solution that allows them to quickly and securely transfer this data to Google Cloud without causing disruptions to their ongoing operations. Which data transfer tool should the company choose?

A : Transfer Appliance

B : BigQuery Data Transfer Service

C : Cloud Data Fusion

D : Storage Transfer Service

Answer: A

Question 4

Your marketing team wants a Looker dashboard that shows customer engagement trends over time, including metrics like average session duration, total page views, and click-through rate (CTR) for campaigns. They also want to be able to see specific data for individual campaigns and share their findings easily with other team members. Which of the following would best meet these requirements?

A : Set up a Looker Explore page with a custom view for each metric and suggest that team members create their own dashboards from there.

B : Add a single tile to the dashboard that shows average session duration, total page views, and CTR in a single view, but disable sharing to keep the data secure.

C : Create individual dashboards for each metric and share each dashboard separately with the marketing team members to give them flexibility.

D : Create a dashboard with separate tiles for each metric and add a “Campaign” filter. Configure the dashboard to allow “Schedule & Share” functionality so the team can share insights.

Answer: D

Question 5

A company wants to migrate a large dataset of historical data from its on-premises storage to Cloud Storage. The dataset is around 100 TB, and the company has a limited network bandwidth, which would make online transfer highly time-consuming and resource-intensive. They need a solution that allows them to quickly and securely transfer this data to Google Cloud without causing disruptions to their ongoing operations. Which data transfer tool should the company choose?

A : Transfer Appliance

B : BigQuery Data Transfer Service

C : Cloud Data Fusion

D : Storage Transfer Service

Answer: A