Add office photos
Accenture logo
Employer?
Claim Account for FREE

Accenture

3.8
based on 56.6k Reviews
Video summary
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Azure Data Engineer
Skills
Clear (1)

10+ Accenture Azure Data Engineer Interview Questions and Answers

Updated 7 Nov 2024

Q1. Which IR should we use if we want to copy data from on-premise db to azure

Ans.

We should use the Self-hosted Integration Runtime (IR) to copy data from on-premise db to Azure.

  • Self-hosted IR allows data movement between on-premise and Azure

  • It is installed on a local machine or virtual machine in the on-premise network

  • Self-hosted IR securely connects to the on-premise data source and transfers data to Azure

  • It supports various data sources like SQL Server, Oracle, MySQL, etc.

  • Self-hosted IR can be managed and monitored through Azure Data Factory

View 1 answer
right arrow

Q2. What is difference between scheduled trigger and tumbling window trigger

Ans.

Scheduled trigger is time-based while tumbling window trigger is data-based.

  • Scheduled trigger is based on a specific time or interval, such as every hour or every day.

  • Tumbling window trigger is based on the arrival of new data or a specific event.

  • Scheduled trigger is useful for regular data processing tasks, like ETL jobs.

  • Tumbling window trigger is useful for aggregating data over fixed time intervals.

  • Scheduled trigger can be set to run at a specific time, while tumbling wind...read more

Add your answer
right arrow

Q3. What are the control flow activites in adf

Ans.

Control flow activities in Azure Data Factory (ADF) are used to define the workflow and execution order of activities.

  • Control flow activities are used to manage the flow of data and control the execution order of activities in ADF.

  • They allow you to define dependencies between activities and specify conditions for their execution.

  • Some commonly used control flow activities in ADF are If Condition, For Each, Until, and Switch.

  • If Condition activity allows you to define conditiona...read more

Add your answer
right arrow

Q4. What are the types of IR

Ans.

IR stands for Integration Runtime. There are two types of IR: Self-hosted and Azure-SSIS.

  • Self-hosted IR is used to connect to on-premises data sources.

  • Azure-SSIS IR is used to run SSIS packages in Azure Data Factory.

  • Self-hosted IR requires an on-premises machine to be installed and configured.

  • Azure-SSIS IR is a fully managed service provided by Azure.

  • Both types of IR enable data movement and transformation in Azure Data Factory.

View 2 more answers
right arrow
Discover Accenture interview dos and don'ts from real experiences

Q5. How to mask data in azure

Ans.

Data masking in Azure helps protect sensitive information by replacing original data with fictitious data.

  • Use Dynamic Data Masking in Azure SQL Database to obfuscate sensitive data in real-time

  • Leverage Azure Purview to discover, classify, and mask sensitive data across various data sources

  • Implement Azure Data Factory to transform and mask data during ETL processes

  • Utilize Azure Information Protection to apply encryption and access controls to sensitive data

Add your answer
right arrow

Q6. What is linked services in adf

Ans.

Linked services in ADF are connections to external data sources or destinations that allow data movement and transformation.

  • Linked services are used to connect to various data sources such as databases, file systems, and cloud services.

  • They provide the necessary information and credentials to establish a connection.

  • Linked services enable data movement activities like copying data from one source to another or transforming data during the movement process.

  • Examples of linked se...read more

Add your answer
right arrow
Are these interview questions helpful?

Q7. What is azure data factory

Ans.

Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.

  • Azure Data Factory is used to move and transform data from various sources to destinations.

  • It supports data integration and orchestration of workflows.

  • You can monitor and manage data pipelines using Azure Data Factory.

  • It provides a visual interface for designing and monitoring data pipelines.

  • Azure Data Factory can be used for data migration, data warehou...read more

Add your answer
right arrow

Q8. What is Azure data lake

Ans.

Azure Data Lake is a scalable data storage and analytics service provided by Microsoft Azure.

  • Azure Data Lake Store is a secure data repository that allows you to store and analyze petabytes of data.

  • Azure Data Lake Analytics is a distributed analytics service that can process big data using Apache Hadoop and Apache Spark.

  • It is designed for big data processing and analytics tasks, providing high performance and scalability.

Add your answer
right arrow
Share interview questions and help millions of jobseekers 🌟
man with laptop

Q9. What is index in table

Ans.

An index in a table is a data structure that improves the speed of data retrieval operations on a database table.

  • Indexes are used to quickly locate data without having to search every row in a table.

  • They can be created on one or more columns in a table.

  • Examples of indexes include primary keys, unique constraints, and non-unique indexes.

Add your answer
right arrow

Q10. What is copy activity

Ans.

Copy activity is a tool in Azure Data Factory used to move data between data stores.

  • Copy activity is a feature in Azure Data Factory that allows you to move data between supported data stores.

  • It supports various data sources and destinations such as Azure Blob Storage, Azure SQL Database, and more.

  • You can define data movement tasks using pipelines in Azure Data Factory and monitor the progress of copy activities.

Add your answer
right arrow

Q11. 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 can be configured to run data integration activities in Azure Data Factory pipelines.

  • It supports different types of data integration activities such as copy data, transform data, and run custom activitie...read more

Add your answer
right arrow

Q12. What is scd type 1

Ans.

SCD Type 1 is a method of updating data in a data warehouse by overwriting existing data with new information.

  • Overwrites existing data with new information

  • No historical data is kept

  • Simplest and fastest method of updating data

Add your answer
right arrow

Q13. Activities used in ADF

Ans.

Activities in Azure Data Factory (ADF) are the building blocks of a pipeline and perform various tasks like data movement, data transformation, and data orchestration.

  • Activities can be used to copy data from one location to another (Copy Activity)

  • Activities can be used to transform data using mapping data flows (Data Flow Activity)

  • Activities can be used to run custom code or scripts (Custom Activity)

  • Activities can be used to control the flow of data within a pipeline (Control...read more

Add your answer
right arrow

Q14. Dataframes in pyspark

Ans.

Dataframes in pyspark are distributed collections of data organized into named columns.

  • Dataframes are similar to tables in a relational database, with rows and columns.

  • They can be created from various data sources like CSV, JSON, Parquet, etc.

  • Dataframes support SQL queries and transformations using PySpark functions.

  • Example: df = spark.read.csv('file.csv')

Add your answer
right arrow

More about working at Accenture

Back
Awards Leaf
AmbitionBox Logo
Top Rated Mega Company - 2024
Awards Leaf
Awards Leaf
AmbitionBox Logo
Top Rated Company for Women - 2024
Awards Leaf
Awards Leaf
AmbitionBox Logo
Top Rated IT/ITES Company - 2024
Awards Leaf
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at Accenture Azure Data Engineer

based on 8 interviews
2 Interview rounds
Technical Round - 1
Technical Round - 2
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Azure Data Engineer Interview Questions from Similar Companies

TCS Logo
3.7
 • 15 Interview Questions
View all
Recently Viewed
INTERVIEWS
Yodlee
10 top interview questions
INTERVIEWS
Tekion
10 top interview questions
INTERVIEWS
TCS
20 top interview questions
INTERVIEWS
HSBC Group
10 top interview questions
INTERVIEWS
KPMG India
10 top interview questions
INTERVIEWS
Tech Mahindra
No Interviews
INTERVIEWS
Tech Mahindra
No Interviews
INTERVIEWS
TCS
10 top interview questions
INTERVIEWS
Vedantu
No Interviews
DESIGNATION
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter