CIBC Customer Service Associate Interview Questions and Answers

Q1. About myself and my current role and responsibility
Add your answer
Q2. Achievement and experience
Add your answer

Q1. Whats is expected in the new role
Add your answer
Q2. Way to look foward what there for the employee with the organization
Add your answer

Q1. 5 ways of initializing SAS Macro variables
Ans. 
There are multiple ways to initialize SAS Macro variables.
• Using the %LET statement

• Using the %GLOBAL statement

• Using the %SYSCALL macro function

• Using the %SYSFUNC macro function

• Using the %DO loop
Answered by AI
Add your answer
Q2. Difference between Merge and Sql Join
Ans. 
Merge is a function in pandas library used to combine two dataframes based on a common column, while SQL join is used to combine tables based on a specified condition.
• Merge is a function in pandas library, while SQL join is a clause in SQL.

• Merge combines two dataframes based on a common column, while SQL join combines tables based on a specified condition.

• Merge can perform inner, outer, left, and right joins, while SQL...read more
Answered by AI
Add your answer
Q3. 5 proc statements
Add your answer

Q1. Read about what is coupling
Add your answer
Q2. What are load balancing techniques
Ans. 
Load balancing techniques distribute incoming network traffic across multiple servers to ensure no single server is overwhelmed.
• Round Robin: Distributes requests evenly among servers in a circular manner.

• Least Connections: Sends requests to the server with the fewest active connections.

• IP Hash: Uses a hash of the client's IP address to determine which server to send the request to.

• Weighted Round Robin: Assigns a weight...read more
Answered by AI
Add your answer
Q3. Design a trading system
Ans. 
Design a trading system for buying and selling stocks
• Define the criteria for selecting stocks to buy/sell

• Implement risk management strategies to protect against losses

• Set up automated trading algorithms to execute trades based on predefined rules

• Monitor market trends and adjust trading strategies accordingly
Answered by AI
Add your answer
Q4. Optimise database read
Add your answer
Q5. Design high volume data intensive applications
Ans. 
Designing high volume data intensive applications involves optimizing data storage, retrieval, and processing for large amounts of data.
• Utilize distributed computing frameworks like Hadoop or Spark for processing large datasets

• Implement data partitioning and sharding to distribute data across multiple servers for scalability

• Use caching mechanisms to reduce latency in data retrieval

• Optimize database queries and indexes ...read more
Answered by AI
Add your answer

Q1. Explain Black and Scholes model in detail
Ans. 
Black-Scholes model is a mathematical model used to calculate the theoretical price of European-style options.
• Developed by Fischer Black, Myron Scholes, and Robert Merton in 1973

• Assumes stock prices follow a lognormal distribution

• Factors in the option's strike price, time to expiration, risk-free interest rate, and volatility of the underlying asset

• Helps in determining the fair value of options and other derivatives

• Use...read more
Answered by AI
Add your answer

Q1. Basic structured query language
Add your answer
Q2. Unix commands and issues
Add your answer

Logical reasoning permutations combination general knowledge and Writing Skills.

Any current tropics in india.

Q1. General introduction with questions Related to your studies, which is critical to recall and typing speed test.
Add your answer

Q1. They tried to reject as worst manager will make you down and leave the room on lowest payroll.
Add your answer
Q2. Introduction round
Add your answer
Q3. If hired then at very low wage rate as per Gurugram wage rate
Add your answer
Q4. Only they will convince you to join other organisations. Means they will reject you. If convincing power is more you will be in.
Add your answer