Free CISI ICWIM Exam Questions

A retail company wants to implement a data warehouse on Google Cloud to store large volumes of historical transaction data from multiple stores. The data will be used to perform analytics, generate insights, and support dashboards with complex queries involving aggregations, filtering, and joining large tables. The solution should be cost-effective for storing historical data and optimized for analytics. Which storage solution would be the best choice?

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 retail business analyst needs to create a dashboard in Looker to monitor the weekly sales performance across various product categories. The business stakeholders require a single-view dashboard that shows key performance metrics such as total revenue, average order value, and weekly growth rates. Which action should the analyst take to best meet these business requirements in Looker?

A retail company is using a variety of SaaS applications, including Google Ads and Salesforce, to collect and manage customer data. They want to extract data from these applications and load it directly into BigQuery on a daily basis for analytics purposes. The data must be automatically updated without manual intervention. Which Google Cloud service would best suit this requirement?

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?