Affine Power BI Developer Interview Questions and Answers

Q1. When would you use Parameters and constant in m query.
Ans. 
Parameters are used for dynamic values that can be changed, while constants are used for fixed values in M query.
• Use parameters for values that may change frequently, such as dates or file paths

• Use constants for values that are fixed, such as column names or static calculations
Answered by AI
Add your answer
Q2. Some questions related to the projects I have worked on.
Add your answer
Q3. Some wueations related to the Banking sector overview and KPI'S
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions on CSS and Jquery mainly.

Q1. What is the CSS box model?
Ans. 
The CSS box model is a design and layout concept that defines the structure and sizing of elements on a web page.
• It consists of content, padding, border, and margin around an element.

• Content area is where text and images are displayed.

• Padding is the space between the content and the border.

• Border is the line that goes around the padding and content.

• Margin is the space outside the border.

• Example: div { width: 200px; pad...read more
Answered by AI
Add your answer
Q2. How do you select all div elements using jQuery?
Ans. 
To select all div elements using jQuery, use the selector $('div').
• Use the jQuery selector $('div') to select all div elements on the page.

• You can also use the find() method to select div elements within a specific parent element.

• To perform actions on the selected div elements, use jQuery methods like css(), text(), or addClass().
Answered by AI
Add your answer
Q3. How can you change the background color of all items in JavaScript?
Ans. 
You can change the background color of all items in JavaScript by selecting all elements and setting their background color property.
• Select all elements using document.querySelectorAll()

• Loop through the selected elements and set their style.backgroundColor property

• Example: document.querySelectorAll('.item').forEach(item => item.style.backgroundColor = 'blue');
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Technical Interview round with questions on Java mainly.

Q1. What are the uses of the final keyword in Java?
Ans. 
The final keyword in Java is used to define constants, prevent method overriding, and make a class immutable.
• Final variables cannot be reassigned once initialized

• Final methods cannot be overridden in subclasses

• Final classes cannot be extended
Answered by AI
Add your answer
Q2. What is the Front Controller in Spring MVC?
Ans. 
Front Controller in Spring MVC is a design pattern that handles all requests and acts as a central point of control.
• Front Controller is a servlet in Spring MVC that receives all requests and then dispatches them to the appropriate handlers.

• It helps in centralizing request handling logic, improving code organization and reducing duplication.

• Front Controller can perform tasks like authentication, logging, exception handl...read more
Answered by AI
Add your answer
Q3. What is the annotation for request mapping in Java?
Ans. 
The annotation for request mapping in Java is @RequestMapping.
• @RequestMapping annotation is used to map web requests to specific handler methods in Spring MVC.

• It can be applied at class level or method level to specify the URL path that the controller will handle.

• You can also specify HTTP request methods, headers, parameters, and more using @RequestMapping.
Answered by AI
Add your answer
Q4. What is the annotation used for a controller in Java?
Ans. 
The annotation used for a controller in Java is @RestController.
• Used to define a class as a controller in Spring MVC

• Automatically serializes return objects into JSON/XML responses

• Equivalent to @Controller + @ResponseBody annotations
Answered by AI
Add your answer

Round duration - 30 minutes
Round difficulty - Easy

This was a typical HR round.

It was basic test. online.

2 questions on arrays. online.

The general topic. Be point to point

Q1. SQL and Python questions. online. screen sharing
Add your answer

Round duration - 90 minutes
Round difficulty - Easy

Q1. 
Reverse Linked List Problem Statement
Given a singly linked list of integers, return the head of the reversed linked list.
Example:
Initial linked list: 1 -> 2 -> 3 -> 4 -> NULL
Reversed link...read more
Ans. 
Reverse a singly linked list of integers and return the head of the reversed linked list.
• Iterate through the linked list and reverse the pointers to point to the previous node instead of the next node.

• Use three pointers to keep track of the current, previous, and next nodes while reversing the linked list.

• Update the head of the reversed linked list as the last node encountered during the reversal process.
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Q1. You have a puzzle involving 4 liters of water. Can you describe the details of this puzzle?
Add your answer

Round duration - 40 minutes
Round difficulty - Easy

Q1. You were given CSS code and asked to debug it to make the functionality work. Can you describe the process you followed and the issues you encountered?
Ans. 
I followed a systematic process to debug CSS code and resolve functionality issues.
• Reviewed the CSS code to identify any syntax errors or typos

• Checked for any conflicting styles that may be overriding the desired functionality

• Used browser developer tools to inspect elements and troubleshoot layout issues

• Tested different scenarios to pinpoint the exact cause of the problem

• Made necessary adjustments to the CSS code to fi
Answered by AI
Add your answer

Normal apti questions.

Q1. About you experience in previous organization.
Add your answer