Accenture Federal Services Associate Application Developer Interview Questions and Answers

Q1. Technical questions on 1st level.
Add your answer

Q1. Level 2 technical questions
Add your answer

Q1. Level 3 Technical questions.
Add your answer

45 mins test including easy - moderately solvable questions

2 coding problems with 6 testcase

Q1. DBMS based questions
Add your answer
Q2. Programming basics based questions
Add your answer

Q1. How to resend identity column
Ans. 
To resend an identity column, you can use DBCC CHECKIDENT command.
• Use DBCC CHECKIDENT command to reseed the identity column

• Specify the table name and the new seed value

• For example: DBCC CHECKIDENT ('TableName', RESEED, NewSeedValue)
Answered by AI
Add your answer
Q2. Difference between stored procedures and functions
Ans. 
Stored procedures are precompiled SQL queries that can perform multiple operations, while functions are reusable code blocks that return a single value.
• Stored procedures can execute multiple SQL statements, while functions can only return a single value.

• Stored procedures can have input and output parameters, while functions can only have input parameters.

• Stored procedures can be used to perform complex operations like ...read more
Answered by AI
Add your answer

Logical and Verbal questions

Q1. Basic programming, database related questions
Add your answer

Q1. Behavioral questions
Add your answer

Q1. What is the difference b/w broadcast and accumulator?
Ans. 
Broadcast is a method of sending a message to multiple recipients, while accumulator is a variable that stores the result of an operation.
• Broadcast sends a message to multiple recipients simultaneously.

• Accumulator is a variable that stores the result of an operation by continuously adding or accumulating values.

• Example: Broadcasting a message to all users in a chat group vs. using an accumulator to sum up numbers in a
Answered by AI
Add your answer
Q2. What is Azure IR
Ans. 
Azure IR stands for Azure Integration Runtime, which is a data integration service in Azure Data Factory.
• Azure IR is used to provide data integration capabilities across different network environments.

• It allows data movement between cloud and on-premises data sources.

• Azure IR supports activities like data copy, data flow, and data transformation.

• It can be configured to run in different modes such as Azure, Self-hosted,
Answered by AI
Add your answer

Q1. Diff between Kubernetes and Docker swarm
Ans. 
Kubernetes is a container orchestration tool that manages containerized applications across multiple hosts, while Docker Swarm is a clustering and scheduling tool for Docker containers.
• Kubernetes is more feature-rich and complex, offering advanced features like auto-scaling, self-healing, and rolling updates.

• Docker Swarm is simpler to set up and use, making it a good choice for smaller deployments or users familiar wit...read more
Answered by AI
Add your answer
Q2. HTTP health checkup in K8s
Ans. 
HTTP health checkup in K8s is a way to monitor the health of applications running in Kubernetes clusters.
• HTTP health check is a method to periodically check the health of an application by sending HTTP requests to a specified endpoint.

• In Kubernetes, you can define HTTP health checks in the pod's configuration using readiness and liveness probes.

• Readiness probes are used to determine when a pod is ready to serve traffic...read more
Answered by AI
Add your answer

Q1. What document you are creating for talend job
Ans. 
Creating a job design document for Talend job
• Include job description and purpose

• List of input and output data sources

• Detailed steps and transformations in the job

• Error handling and logging mechanisms

• Dependencies and scheduling information
Answered by AI
Add your answer

Basic reasoning and logical things

Which is second half of the aptitude test

Q1. Behaviour questions
Add your answer
Q2. Least favourite subject
Ans. 
Mathematics
• Struggled with complex equations

• Found geometry challenging

• Preferred subjects with more creativity like art or music
Answered by AI
Add your answer