Avantor Analyst Interview Questions and Answers

Q1. Self , previous year company work
Add your answer

Q1. CALCULATE function from DAX.
Ans. 
The CALCULATE function in DAX is used to apply filters to a calculation in a formula.
• CALCULATE function modifies the filter context for a calculation in DAX.

• It can be used to override existing filters or apply new filters.

• Example: CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'North')
Answered by AI
Add your answer
Q2. What are data structure?
Ans. 
Data structures are ways of organizing and storing data in a computer so that it can be accessed and used efficiently.
• Data structures define the way data is stored, accessed, and manipulated in a computer program.

• Examples of data structures include arrays, linked lists, stacks, queues, trees, and graphs.

• Choosing the right data structure is crucial for optimizing the performance of a program.
Answered by AI
Add your answer

Q1. All about .net questions
Add your answer

Q1. Salary discussion and tell about myselft
Add your answer

It was a 90 mins round, and we have to do 85 questions. Coding was also a part of it.

Logical reasoning numerical English sum

Python power bi sql tablue

Q1. Aksjfhasf asjhfgkaskf sdkhgf
Add your answer
Q2. Sdkjghsdgd sdkgjsdg skdghsdtsd
Add your answer

Q1. How do you find the code performance issue in the code deployed in production?
Ans. 
To find code performance issues in production, use monitoring tools and profiling techniques.
• Use monitoring tools like New Relic, AppDynamics, or Datadog to track performance metrics and identify bottlenecks.

• Use profiling techniques like CPU profiling, memory profiling, and network profiling to pinpoint specific areas of the code that are causing performance issues.

• Analyze logs and error messages to identify patterns a...read more
Answered by AI
View 1 more answer
Q2. What is asynchronous programming
Ans. 
Asynchronous programming is a programming paradigm that allows multiple tasks to run concurrently without blocking each other.
• Asynchronous programming is used to improve the performance of applications that require a lot of I/O operations.

• It involves the use of callbacks, promises, and async/await keywords in JavaScript.

• Asynchronous programming can be used in both front-end and back-end development.

• Examples of asynchro...read more
Answered by AI
Add your answer
Q3. Write a program to change background after every 0.5 sec interval to orange,white,green on button click in Angular?
Ans. 
Program to change background color on button click in Angular
• Create a button in Angular template

• Add click event listener to the button

• Use setInterval() function to change background color after every 0.5 sec

• Use ngStyle directive to change background color dynamically
Answered by AI
Add your answer
Q4. How to load a component only after 3 of my services are loaded?
Ans. 
Use Angular's 'resolve' property to load component after services are loaded.
• Create a resolver service that waits for all three services to complete before resolving.

• Add the resolver service to the 'resolve' property of the component's route.

• Access the resolved data in the component using the ActivatedRoute service.

• Example: { path: 'my-component', component: MyComponent, resolve: { data: MyResolverService } }
Answered by AI
Add your answer
Q5. What is difference between iquerable and ienumrable
Ans. 
IQueryable is for querying data from a source that implements IQueryable interface while IEnumerable is for iterating over a collection of data.
• IQueryable is used for deferred execution while IEnumerable is used for immediate execution.

• IQueryable is used for querying data from a remote data source while IEnumerable is used for querying data from an in-memory collection.

• IQueryable is more efficient for large datasets as...read more
Answered by AI
Add your answer
Q6. When you go with entity framework and ado.net
Ans. 
Entity Framework is an ORM while ADO.NET is a data access technology.
• Entity Framework is easier to use and provides more abstraction than ADO.NET.

• ADO.NET is faster and more flexible than Entity Framework.

• Use Entity Framework for simple CRUD operations and ADO.NET for complex queries and performance-critical applications.
Answered by AI
Add your answer