Data engineering Interview questions: Accenture


Q1.Which Integration Runtime (IR) should be used for copying data from an on-premise database to Azure?

Q2.Explain the differences between a Scheduled Trigger and a Tumbling Window Trigger in Azure Data Factory. When would you use each?

Q3. What is Azure Data Factory (ADF), and how does it enable ETL and ELT processes in a cloud environment?

Q4.Describe Azure Data Lake and its role in a data architecture. How does it differ from Azure Blob Storage?

Q5. What is an index in a database table? Discuss different types of indexes and their impact on query performance.

Q6.Given two datasets, explain how the number of records will vary for each type of join (Inner Join, Left Join, Right Join, Full Outer Join).

Q7.What are the Control Flow activities in the Azure Data Factory? Explain how they differ from Data Flow activities and their typical use cases.

Q8. Discuss key concepts in data modeling, including normalization and denormalization. How do security concerns influence your choice of Synapse table types in a given scenario? Provide an example of a scenario-based ADF pipeline.

Q9. What are the different types of Integration Runtimes (IR) in Azure Data Factory? Discuss their use cases and limitations.

Q10.How can you mask sensitive data in the Azure SQL Database? What are the different masking techniques available?

Q11.What is Azure Integration Runtime (IR), and how does it support data movement across different networks?

Q12.Explain Slowly Changing Dimension (SCD) Type 1 in a data warehouse. How does it differ from SCD Type 2?

Q13.SQL questions on window functions - rolling sum and lag/lead based. How do window functions differ from traditional aggregate functions?