Nielsen Ingest Executive Interview Questions and Answers

Q1. Basic concept of c#,.net framework
Add your answer
Q2. What is CFA and DFA in entity framework core
Ans. 
CFA and DFA are Change-Tracking and Database-First Approaches in Entity Framework Core.
• CFA (Change-Tracking Approach) is used to track changes made to entities in memory and then save them to the database.

• DFA (Database-First Approach) is used to generate entity classes and DbContext from an existing database schema.

• CFA is useful when working with disconnected entities, while DFA is useful when working with an existing ...read more
Answered by AI
Add your answer

Q1. Basic questions
Add your answer

Q1. Asked about projects. Quite aloberately.
Add your answer
Q2. What is authorization and authentication?
Ans. 
Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform.
• Authentication confirms the identity of a user through credentials like passwords or biometrics.

• Authorization determines the level of access a user has to resources or actions.

• Example: Logging into a system with a username and password is authentication, while being able to view or edit specific files
Answered by AI
Add your answer

Q1. OOPS concepts, function overload, override,interface,string, string builder
Add your answer

Q1. Company profile,salary discussion
Add your answer

Q1. Mostly on your experience. Azure, .net core, microservices.
Add your answer
Q2. Coding round with basic programming questions. Easy level.
Add your answer

1 easy sql and 1 easy python for 55 min

1 easy python and very hard sql for 1 hr 50 min

Q1. Mainly they focused on the answers you have written on round 2 and basic sql and pandas in python
Add your answer
Q2. 1) write a join 2) implement left join using pandas
Ans. 
Answering a question on writing a join and implementing left join using pandas for Data Analyst role.
• To write a join, we need to identify the common column(s) between two tables and use the JOIN keyword in SQL.

• Example: SELECT * FROM table1 JOIN table2 ON table1.common_column = table2.common_column

• To implement left join using pandas, we can use the merge() function with how='left' parameter.

• Example: pd.merge(table1, tab
Answered by AI
Add your answer

Basic aptitude questions of quant and reasoning and general english

Case study of varies products asked around 15-20 which were easy to attempt

Q1. About yourself, practical knowledge, family, data related,etc.
Add your answer
Q2. What is sql. Excel formulas
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Excel formulas are used for performing calculations and data analysis in Microsoft Excel.
• SQL is used to retrieve, insert, update, and delete data from databases.

• Excel formulas are written using functions and operators to perform calculations and manipulate data.

• SQL example: SELECT * FROM customers WHERE age > 30;

• Excel formula example...read more
Answered by AI
Add your answer

Normal aptitude questions

Q1. Interview with manager
Add your answer

There will be MCQ Questions. They will ask you to use internet and answer the questions.
They want to check your research skills.

Q1. If you are a fresher then you can easily clear the interview, Hr will ask normal questions about yourself and about your education background.
Add your answer