Affine Power BI Developer Interview Questions and Answers

Q1. Dax queries on scenario based
Add your answer
Q2. Sql queries on scenario based
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.

Coding testing with 15 questions MCQ based

Q1. 1 or 2 DSA questions, rest tech stack related questions were asked
Add your answer

Q1. This was a technofunctional round, kind of a managerial round.
Add your answer

Q1. This was a HR round
Add your answer

Q1. Reg BW and ABAP and XSA
Add your answer

Q1. Reg sap BW and ABAP and XSA
Add your answer

Q1. Company structure
Add your answer

Aptitude auestions were there

In this round 14 mcq and 2 sql queries were given

Online coding test with Sql and python questions

Q1. Details about project and experience
Add your answer
Q2. Pyspark and databricks questions
Add your answer
Q3. What is Spark context
Ans. 
Spark context is the main entry point for Spark functionality and represents the connection to a Spark cluster.
• Main entry point for Spark functionality

• Represents connection to a Spark cluster

• Used to create RDDs, broadcast variables, and accumulators
Answered by AI
Add your answer
Q4. What is inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class can inherit attributes and methods from another class.
• Allows for code reusability by creating a new class based on an existing class

• Derived class inherits properties and behaviors of the base class

• Supports the concept of polymorphism and encapsulation

• Example: Class 'Car' can inherit from class 'Vehicle' and inherit its attributes like 'color' and met
Answered by AI
Add your answer
Q5. What is sparkconfig
Ans. 
SparkConfig is a configuration object used in Apache Spark to set various parameters for Spark applications.
• SparkConfig is used to set properties like application name, master URL, and other Spark settings.

• It is typically created using SparkConf class in Spark applications.

• Example: val sparkConf = new SparkConf().setAppName("MyApp").setMaster("local")
Answered by AI
Add your answer