Accenture Admin Interview Questions and Answers

General question around data engineering

Q1. Different apache tech and tools
Add your answer
Q2. What is snowflake
Add your answer
Q3. Coding questions on python
Add your answer

Q1. About location preference
Add your answer
Q2. Behavioural questions
Add your answer

Q1. Python SQL question
Add your answer

Q1. More on Project side
Add your answer

Q1. Salary Discussion
Add your answer

Q1. Data engineer roles and resposibilities
Add your answer

Q1. Explain your project structure ?
Ans. 
My project structure follows a modular approach with separate folders for data ingestion, processing, and storage.
• Separate folders for data ingestion, processing, and storage

• Use of version control for tracking changes

• Documentation for each module and process

• Unit tests for data pipelines

• Logging and monitoring for tracking data flow
Answered by AI
Add your answer
Q2. What is mean by dag ?
Ans. 
DAG stands for Directed Acyclic Graph, a data structure used to represent dependencies between tasks in a workflow.
• DAG is a collection of nodes connected by directed edges, where each edge represents a dependency between tasks.

• It is acyclic, meaning there are no cycles or loops in the graph.

• DAGs are commonly used in data processing pipelines to ensure tasks are executed in the correct order.

• Example: In a DAG representi...read more
Answered by AI
Add your answer

Q1. Explain Spark RDD,DF
Ans. 
Spark RDD and DF are two data structures in Apache Spark for processing and analyzing data.
• RDD (Resilient Distributed Dataset) is a distributed collection of elements that can be operated on in parallel. It is immutable and fault-tolerant.

• DF (DataFrame) is a distributed collection of data organized into named columns. It provides a more structured and efficient way to work with data compared to RDDs.

• RDD is low-level an...read more
Answered by AI
Add your answer
Q2. Spark Architecture
Add your answer

End to end data engineering architecture

Q1. Salary expectation
Add your answer
Q2. Cultural fitment
Add your answer

1. Questions on spark basica
2. Sql coding questions
3. Java or scala basics

Q1. How bigquery works?
Ans. 
BigQuery is a fully managed, serverless data warehouse by Google Cloud for analyzing large datasets using SQL queries.
• BigQuery is a cloud-based data warehouse that allows for fast SQL queries on large datasets.

• It is fully managed and serverless, meaning users do not have to worry about infrastructure management.

• BigQuery can handle petabytes of data and allows for real-time analytics with its streaming capabilities.

• It s...read more
Answered by AI
Add your answer

Its was moderate and had to concentrate more or logical part

Q1. I don't remember as of now but i could remember that most of questions were from the core concepts of the skills mentioned in the resume
Add your answer

Q1. Regular questions like why should we hire you, tell me about yourself, interest hobbies, etc
Add your answer