Free CISI ICWIM Exam Questions

Question 1

Which two advantages does using pretrained Google Large Language Models (LLMs) via a remote connection in BigQuery offer when working with natural language processing (NLP) tasks? (Select two)

A : Google LLMs enable the immediate use of sophisticated NLP capabilities without requiring model development or training expertise.

B : Google LLMs are primarily suited for numerical data processing, making them less ideal for NLP within BigQuery.

C : BigQuery provides built-in support for custom Python packages, allowing advanced NLP operations on Google LLMs directly.

D : Custom layers can be added to pretrained LLMs directly in BigQuery for domain-specific tuning.

E : Integration with BigQuery ML allows users to query and process large datasets using Google LLMs at scale.

Answer: A,E

Question 2

A data analyst at a marketing firm wants to leverage a pretrained Google large language model (LLM) in BigQuery to analyze customer feedback data stored in a BigQuery table. They aim to classify sentiment (positive, neutral, negative) based on the textual feedback without having to train a model from scratch. Which approach should the analyst take to implement this with the least setup and configuration?

A : Integrate with Vertex AI to call a pretrained Google language model for sentiment analysis and run predictions within BigQuery.

B : Access a pretrained Google LLM directly in BigQuery ML using the ML.PREDICT function and specify the sentiment classification task on the feedback column.

C : Create a BigQuery remote function to call an external API that connects to Google’s LLMs for natural language processing, then analyze the feedback data.

D : Use BigQuery ML to create a custom sentiment classification model, train it on labeled feedback data, and deploy it to the BigQuery environment.

Answer: B

Question 3

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 4

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 : Use a LookML model to create dimensions and measures for revenue, average order value, and growth rates, then save these as separate Looks and embed them in the dashboard.

B : Import a Looker Block that includes pre-built dashboards for sales metrics and customize the visualizations according to the business requirements.

C : Export raw sales data from Looker and upload it to an external visualization tool like Tableau for further customization.

D : Create a new dashboard directly in Looker, add tiles with visualizations for each metric, and use filters to allow users to select different time ranges.

Answer: B

Question 5

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