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.

Normal apti questions.

Q1. About you experience in previous organization.
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

Round duration - 90 Minutes
Round difficulty - Medium

The round was scheduled in afternoon time.
HackerEarth test link was shared beforehand
All the instructions were provided in the welcome page of test link.
It was proctored test

Q1. 
Palindrome String Validation
Determine if a given string 'S' is a palindrome, considering only alphanumeric characters and ignoring spaces and symbols.
Note:
The string 'S' should be evaluated in a case...read more
Ans. 
Validate if a given string is a palindrome after removing special characters, spaces, and converting to lowercase.
• Remove special characters and spaces from the input string

• Convert the string to lowercase

• Check if the modified string is equal to its reverse to determine if it's a palindrome
Answered by AI
Add your answer
Q2. 
Find First Repeated Character in a String
Given a string 'STR' composed of lowercase English letters, identify the character that repeats first in terms of its initial occurrence.
Example:
Input:
STR =...read more
Ans. 
Find the first repeated character in a given string of lowercase English letters.
• Iterate through the string and keep track of characters seen so far

• Return the first character that repeats, if none, return '%'

• Use a hash set or array to store characters seen
Answered by AI
Add your answer

Round duration - 35 minutes
Round difficulty - Medium

It was in afternoon 3pm.
Interview platform was Microsoft teams.
Interview link was shared a day before.
Interviewer was professional.

Q1. 
Pair Sum Problem Statement
You are given an integer array 'ARR' of size 'N' and an integer 'S'. Your task is to find and return a list of all pairs of elements where each sum of a pair equals 'S'.
Note:
...read more
Ans. 
Given an array and a target sum, find pairs of elements that add up to the target sum.
• Iterate through the array and for each element, check if the complement (target sum - current element) is present in a hash set.

• If the complement is found, add the pair to the result list.

• Sort the pairs based on the first element, and if the first elements are equal, sort based on the second element.
Answered by AI
Add your answer

Round duration - 25 Minutes
Round difficulty - Medium

It was held around 4pm.
Scheduled on MS teams.
Interview link shared one day before.
The interviewer was pretty chill and made me comfortable.

Q1. How would you handle a situation where a company approaches you during a pandemic and states that demand is high but supply is low?
Add your answer
Q2. Why do you want to join this company?
Add your answer