Accenture SQL Server Developer Interview Questions and Answers for Experienced

Q1. Data Modeling Concepts, SQL Query
Add your answer
Q2. Data Governance, Data Lineage, ETL process,
Add your answer

SQL Scripts to write and also also asked to design an data model of my choice in Telecom Domain

Q1. What is the uses of filter stage
Ans. 
Filter stage is used in ETL processes to selectively pass or reject data based on specified criteria.
• Filter stage helps in removing unwanted data from the input dataset.

• It can be used to apply conditions like filtering out duplicate records, selecting specific columns, or excluding certain values.

• For example, a filter stage can be used to only pass records where the sales amount is greater than $1000.
Answered by AI
Add your answer
Q2. What is the uses of transfor stage
Ans. 
Transform stage is used in ETL process to apply business rules, clean and enrich data before loading into target database.
• Transform stage is used to apply business rules to the data.

• It is used to clean and standardize data before loading into the target database.

• Transform stage can also be used to enrich data by combining multiple sources or adding calculated fields.

• Examples include converting data types, removing dupl
Answered by AI
Add your answer
Q3. What is the uses of sort stage
Ans. 
Sort stage is used in ETL processes to sort data based on specified criteria before loading it into the target system.
• Sort stage helps in arranging data in a specific order for better analysis and reporting

• It can be used to remove duplicates from data before loading

• Sorting can be done based on multiple columns or expressions

• Example: Sorting customer data based on their purchase amount before loading into a data warehou
Answered by AI
Add your answer
Q4. How to create the prallel job
Ans. 
To create a parallel job, use parallel processing techniques to divide tasks into smaller subtasks that can be executed simultaneously.
• Identify tasks that can be executed independently and in parallel

• Use parallel processing techniques such as multi-threading or distributed computing

• Implement parallel job using ETL tools like Informatica or Talend

• Monitor and optimize parallel job performance to ensure efficient executio
Answered by AI
Add your answer
Q5. Defenation of scd
Ans. 
SCD stands for Slowly Changing Dimension, a technique used in data warehousing to track changes in dimension attributes over time.
• SCD is used to maintain historical data in a data warehouse

• There are different types of SCDs - Type 1, Type 2, and Type 3

• Type 1 SCD overwrites old data with new data

• Type 2 SCD creates a new record for each change and maintains history

• Type 3 SCD keeps a limited history by adding columns to tr
Answered by AI
Add your answer

Q1. Basics of Kotlin
Add your answer
Q2. Jetpack component.
Add your answer
Q3. One from data structure.
Add your answer

Test your algorithmic thinking and problem solving skills

Q1. Communications,clearity of answers
Add your answer

Q1. Discussion about packages,joining date
Add your answer

Q1. DONT REMEMBER THE QUESTIONS
Add your answer
Q2. I FORGOT THE QUESTION ASKED
Add your answer

Q1. Sql questions based on fundamental
Add your answer

Q1. IICS FUNCTIONS TRANSFORMATIONS SQL
Add your answer

Q1. Explain Activity lifecycle
Ans. 
Activity lifecycle refers to the series of states an activity goes through during its lifetime in an Android app.
• Activity is created with onCreate() method

• Activity is started with onStart() method

• Activity is resumed with onResume() method

• Activity is paused with onPause() method

• Activity is stopped with onStop() method

• Activity is destroyed with onDestroy() method
Answered by AI
Add your answer
Q2. What is databinding
Ans. 
Data binding is a technique in software development that establishes a connection between the UI components and the data sources.
• Data binding allows for automatic synchronization of data between the UI and data sources.

• It reduces boilerplate code by eliminating the need for manual updates to the UI when data changes.

• Data binding can be implemented using frameworks like Android Data Binding Library.
Answered by AI
Add your answer