Accenture Data Associate Interview Questions and Answers

Forecasting problem - Predict daily sku level sales

Q1. What is difference between bias and variance
Ans. 
Bias is error due to overly simplistic assumptions, variance is error due to overly complex models.
• Bias is the error introduced by approximating a real-world problem, leading to underfitting.

• Variance is the error introduced by modeling the noise in the training data, leading to overfitting.

• High bias can cause a model to miss relevant relationships between features and target variable.

• High variance can cause a model to ...read more
Answered by AI
Add your answer
Q2. Parametric vs non parametruc model
Ans. 
Parametric models make strong assumptions about the form of the underlying data distribution, while non-parametric models do not.
• Parametric models have a fixed number of parameters, while non-parametric models have a flexible number of parameters.

• Parametric models are simpler and easier to interpret, while non-parametric models are more flexible and can capture complex patterns in data.

• Examples of parametric models inc...read more
Answered by AI
Add your answer

Q1. What is scd type 2?
Ans. 
SCD type 2 is a method used in data warehousing to track historical changes by creating a new record for each change.
• SCD type 2 stands for Slowly Changing Dimension type 2

• It involves creating a new record in the dimension table whenever there is a change in the data

• The old record is marked as inactive and the new record is marked as current

• It allows for historical tracking of changes in data over time

• Example: If a cust...read more
Answered by AI
Add your answer
Q2. Pyspark question read CSV from folder and add column in each csv file and write it to different location.
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. What are databricks workflows?
Ans. 
Databricks workflows are a set of tasks and dependencies that are executed in a specific order to achieve a desired outcome.
• Databricks workflows are used to automate and orchestrate data engineering tasks.

• They define the sequence of steps and dependencies between tasks.

• Tasks can include data ingestion, transformation, analysis, and model training.

• Workflows can be scheduled to run at specific times or triggered by event...read more
Answered by AI
Add your answer
Q2. Help to orchestrate the jobs
Add your answer

Q1. Existing project design
Ans. 
The existing project design is a data pipeline for processing and analyzing customer data.
• The project uses Apache Kafka for real-time data ingestion.

• Data is stored in a distributed file system like Hadoop HDFS.

• Apache Spark is used for data processing and transformation.

• The processed data is loaded into a data warehouse like Amazon Redshift.

• The project includes monitoring and alerting mechanisms for data quality and pip
Answered by AI
Add your answer

Q1. Talk about previous experience
Add your answer

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

Q1. Tell abt ur self
Ans. 
I am a data scientist with a background in statistics and machine learning, passionate about solving complex problems using data-driven approaches.
• I have a Master's degree in Data Science from XYZ University.

• I have experience working with Python, R, and SQL for data analysis and modeling.

• I have worked on projects involving predictive analytics, natural language processing, and computer vision.

• I am proficient in data vi...read more
Answered by AI
Add your answer

General question and grammatical questions

Q1. About myself at one on one round
Add your answer
Q2. Tell me about yourself
Add your answer
Q3. Explain about your Previous experience
Add your answer

The test will be conducted in a interview process

Group discussion is a communicate in a people

Q1. Hr face to face commutation
Add your answer
Q2. Self introduction and
Add your answer

Q1. It is the individual interview
Add your answer
Q2. Personal questions only
Add your answer