Free Practice CISI ICWIM Exam Questions 2025

Stay ahead with 100% Free International Certificate in Wealth & Investment Management ICWIM Dumps Practice Questions

Page: 1 / 20

Total 100 Questions | Updated On: Apr 09, 2025

Add To Cart

Question 1

Having prepared recommendations via a report, why would an adviser suggest a face-to-face meeting with their client?

A : In order to collect fees prior to implementation of the recommendations

B : To establish the client’s tax position

C : So that the client can review the adviser’s qualifications

D : To afford the opportunity to clear up any misunderstandings

Answer: D

Question 2

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 3

A firm acting as agent makes money by:

A : Profiting from the spread

B : Providing advice

C : Charging their client a commission

D : Trading against its own order book

Answer: C

Question 4

Your organization is using Cloud SQL to manage a production database, and you need to implement a disaster recovery strategy to ensure minimal downtime and data loss in case of a regional failure. What is the best approach to ensure high availability and disaster recovery?

A : Enable automatic backups on a single-zone primary instance.

B : Use a multi-region Cloud Storage bucket for database backups.

C : Set up a primary instance in one region and a read replica in a different region.

D : Configure a primary instance in one zone and a read replica in the same zone.

Answer: C

Question 5

A financial services company needs to implement a data pipeline for transactional data, which must be cleansed and validated for compliance purposes before loading into BigQuery. They also plan to conduct further analytics on the data after loading. Which data manipulation methodology is the most appropriate for these requirements?

A : ETLT (Extract, Transform, Load, Transform) to cleanse data, load it into BigQuery, and conduct additional transformations if needed.

B : ELT (Extract, Load, Transform) to load data into BigQuery and perform data cleaning afterward.

C : Batch SQL imports for compliance validation and transformation after ingestion into BigQuery.

D : ETL (Extract, Transform, Load) to ensure data quality and compliance before loading into BigQuery.

Answer: D

Page: 1 / 20

Total 100 Questions | Updated On: Apr 09, 2025

Add To Cart