Accenture Senior Analyst Interview Questions, Process, and Tips

Q1. What are window function
Ans. 
Window functions are a type of function in SQL that perform calculations across a set of table rows related to the current row.
• Window functions are used to perform calculations on a set of rows related to the current row.

• They allow you to perform calculations without grouping the rows into a single output row.

• Examples of window functions include ROW_NUMBER(), RANK(), and NTILE().
Answered by AI
Add your answer

Q1. What os star schema
Ans. 
Star schema is a type of data warehouse schema where a central fact table is connected to multiple dimension tables.
• Central fact table contains the primary data of interest

• Dimension tables provide context and details about the data in the fact table

• Each dimension table is connected to the fact table through a foreign key

• Allows for efficient querying and analysis of data
Answered by AI
Add your answer

Basic aptitude test with 3 levels of questions

Q1. Knowledge about the domain
Add your answer
Q2. Explain your resume
Add your answer

Q1. Java spring boot microservice
Add your answer

Q1. Normally hr question
Add your answer

MCQ test based on JavaScript, Angular, Jasmine, GIT

Q1. Various questions on HTML5, CSS3, Bootstrap, Angular, SQL
Add your answer

Q1. Salary discussion
Add your answer