Free CISI ICWIM Exam Questions

Your team wants to generate a report using BigQuery to identify top-selling products. They want to see the product name along with its total sales, sorted in descending order of total sales. Which SQL query best fits this requirement?

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?

You are working with a client who wants to extract data from various public APIs and load it into a Google Cloud service. The data should be stored in a highly durable, scalable, and cost-effective manner. Additionally, the data might later be integrated with BigQuery for advanced analytics. Which service would be best suited for the initial storage of this data?

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 financial institution needs to prepare data from different transactional systems for machine learning. The data needs initial filtering and validation before loading into BigQuery, where additional, complex transformations will be applied. Which data processing methodology best suits this requirement?