Free CISI ICWIM Exam Questions

You have just completed training a machine learning model on customer behavior data. Your next step is to evaluate its performance to decide if it’s ready for deployment. Which two evaluation metrics are critical for assessing the quality of a model designed to predict customer churn? (Select two)

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?

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?

An organization wants to keep track of different versions of their customer churn prediction model, ensuring that each version’s metadata, performance metrics, and deployment status are easily accessible. What should they prioritize in Vertex AI Model Registry to manage these requirements?

Your team is loading data into BigQuery from various sources, including CSV files, JSON logs, and a relational database. During ingestion, you notice mismatched schemas, inconsistent null handling, and duplicate records. What should you do to identify and resolve these issues before loading the data?