Azure Data Factory Interview Question & Answers

ADF Interview Questions and Answers | Azure Data Factory Q&A

ADF Interview Questions and Answers

Introduction to Azure Data Factory

  1. What is Azure Data Factory and Why Do We Use Azure Data Factory?

Integration Runtime (IR)

  1. What is Integration Runtime in ADF, and what are the Types of IR?
  2. Which IR will you use if you need to read data from an on-premises network to Azure Cloud?
  3. If your Self-Hosted IR is running slowly, what steps will you take in Azure Data Factory?
  4. How will you check if SHIR is not working?
  5. Can a single Self-Hosted IR be used in more than one Data Factory?
  6. For load balancing and failover scenarios, what is the maximum number of nodes we can add in SHIR?
  7. Is it okay to create multiple Integration Runtimes in a single Data Factory, and why?

Pipelines and Activities

  1. What are Pipelines in Azure Data Factory?
  2. What is an Activity in Azure Data Factory?
  3. How will you control the flow of activities in an Azure Data Factory Pipeline?
  4. Which activity will you use to delete all files in Azure Data Factory?
  5. Explain a few activities in Azure Data Factory Pipeline that can run a stored procedure.
  6. How can you complete a task that cannot be done with built-in activities in Azure Data Factory?
  7. Can the same linked service be used in multiple Pipelines in Azure Data Factory?
  8. To get a list of all files from Azure Blob Storage, which activity will you use?

Triggers

  1. What is a Schedule Trigger in Azure Data Factory?
  2. What are Event-Based Triggers in Azure Data Factory?
  3. What is a Tumbling Window Trigger in Azure Data Factory?

Linked Services and Datasets

  1. What are Linked Services in Azure Data Factory?
  2. What is a Dataset in Azure Data Factory?
  3. What are Parameterized Linked Services, and why do you use them in Azure Data Factory?

SSIS Integration

  1. You need to run an SSIS Package in Azure Data Factory. Where will you save the SSIS package?
  2. What are your thoughts on which is better: SSIS vs. ADF?

Data Operations

  1. Does Copy Activity support UPSERT operations?
  2. How to remove duplicate records in Azure Data Factory?
  3. If you need to add an extra column or derive extra columns from source columns, can you use Copy Activity?
  4. You are given hundreds of files, and you need to load them into separate tables and create the tables on the fly. How would you do this?
  5. Multiple files are loaded to a single table. How will you identify the file names for each record?

Error Handling and Recovery

  1. If your Data Factory is deleted, how will you recover or restore it?
  2. How can you backup and restore Azure Data Factory?

Security and Networking

  1. What are the steps to create Private Endpoints in Azure Data Factory?
  2. Why do you use Azure Key Vault with Data Factory?

Parameters and Variables

  1. What is the difference between a Parameter and a Variable in Azure Data Factory?
  2. What are the three different types of variables available in Azure Data Factory?

Monitoring and Logging

  1. Where will you see the Pipeline Runs and Triggers?
  2. How will you keep the execution log history of ADF Pipelines for more than 3 months?
  3. How will you get the last 2 months' execution details of pipelines if your pipelines have been failing?
  4. How to find out which Pipeline is billed the most?
  5. How will you check if a file exists or does not exist in Blob storage in Azure Data Factory?

Data Flows

  1. Your Data Flow is running slowly in ADF. What steps will you take?
  2. What is the difference between General Purpose and Memory Optimized Mapping Data Flows?
  3. What is the minimum and maximum Vcore for Mapping Data Flow?

CI/CD and Source Control

  1. Which source control repository will you use in Azure Data Factory?
  2. Which tool have you used for CI/CD for Azure Data Factory?
  3. How to copy an Azure Data Factory Pipeline from one Data Factory to another?

Notifications

  1. How will you send an email with a file attachment from Azure Data Factory?
  2. How will you send an email from an Azure Data Factory Pipeline?
  3. How will you send an email from Azure Data Factory?

Miscellaneous

  1. In which modes can an Azure Data Factory Pipeline run?
  2. The Microsoft EventGrid resource provider is not registered in the subscription. How to resolve this?
  3. What steps will you take if your pipelines are stuck in a queue or in progress status?
  4. How often do you upgrade or update your Self-Hosted Integration Runtime?

© 2025 Aamir Shahzad. All rights reserved.

37 comments:

  1. In the month of March, the Jharkhand Academic Council JAC, Ranchi, conducted the annual examination. More than a million pupils took part in the secondary exams. All of the students are now waiting and watching. Jharkhand Board Class 10 Previous Question Paper 2023 is now available for download. The Jharkhand Academic Council, JAC 10th Question Paper 2023 Ranchi, will release the JAC Class X Exam Previous Question Paper 2023 on its official website, Jharkhand Previous Question Paper 2023 Portal, in the third week of May. Previous Year's Question Papers for Class 10th Jharkhand Board 2023 Dear all Jharkhand Board High School students, go to the official URL below and input your Syllabus number by number, then click the submit button to download your JAC Class 10th Previous Question Paper 2023 when it is officially published.

    ReplyDelete
  2. Ok, thanks for the information and have a good day! get-mobdro.com

    ReplyDelete
  3. If you need legitimate help with monitoring your partner's cell phone remotely, reach out to extremeinfiltrators@gmail.com, just say Josh referred you.

    ReplyDelete
  4. Fast loan reasonable interest rate of only 3%. We offer loans to those with bad credit and those who intend to invest in positive business ventures. That's why we offer personal loans, business loans, business loans, investment loans and many more. Contact us today for more information about our loan service financialserviceoffer876@gmail.com WhatsApp +918929509036

    ReplyDelete
  5. I was searching for loan to sort out my bills& debts, then i saw comments about Blank ATM Credit Card that can be hacked to withdraw money from any ATM machines around you . I doubted thus but decided to give it a try by contacting { cyberhackingcompany@gmail.com} they responded with their guidelines on how the card works. I was assured that the card can withdraw $5,000 instant per day & was credited with $50,000,000.00 so i requested for one & paid the delivery fee to obtain the card, after 24 hours later, i was shock to see the UPS agent in my resident with a parcel{card} i signed and went back inside and confirmed the card work's after the agent left. This is no doubts because i have the card & has made used of the card. This hackers are USA based hackers set out to help people with financial freedom!! Contact these email if you wants to get rich with this Via: cyberhackingcompany@gmail.com ..    

    ReplyDelete
  6. Do you Need Instant Loan from $2,000 to $5,000,000.00 with no collateral required and receive a no obligation loan approval.We welcome the opportunity to show you how effective we are at helping our clients obtain the money they need to succeed. Our professional staff is available for a Free Consultation.At Financial Group Funding, we understand that unexpected events arise requiring extra money that may not be readily available to you contact us now via email :

    Asia Loan Company Ltd
    asialoancompanyltd@gmail.com
    Call/Whats-App +919319926618
    Dr. Sipos Csaba

    ReplyDelete
  7. Are you looking for loan to clear off your dept. and start up your own Business? have you being going all over yet not able to get a legit loan Company that will loan you? Here is your final solution, We can give you any amount you need provided you are going to pay back within the period of time given without any problem. Apply now and Contact us for more details: financialserviceoffer876@gmail.com
    Whats-App on +91 8929509036
    Home Of Services
    Dr James Eric Finance Ltd
    Dr. James Eric

    ReplyDelete
  8. LOAN WE LEND TO EVERYONE ONLINE financialserviceoffer876@gmail.com 918929509036

    ReplyDelete
  9. your blog is very help full to us thanks for sharing such informations, i also have a blog about the satta gali result please visit my blog to know more gali result

    ReplyDelete
  10. This comment has been removed by the author.

    ReplyDelete
  11. This blog has some very excellent posts. Thanks for giving this useful information. Also visit my site Satta king

    ReplyDelete
  12. Web D school is the best training institute to learn Data Science course in Chennai with 100% placement record, Student workshops, Free Internships etc.
    Click this Link for more info about Data Science Course in Chennai.

    ReplyDelete
  13. As a business inclined individual I hated just staying home, saving all my pensions and not being able to make use of it to make more money so I went on looking for an investment, I tried binary options and forex, lost some money to that and took sometime off the online investment thing and after a while I stumbled on a so called investor guru. I invested lot of money with him and never got my money back. I read on an article of Mr. Fahad Waleed and contacted him and the rest is history. contact him and get your lost BTC or money back.

    Fahad-waleed64@cyber-wizard.com

    ReplyDelete
  14. John here, and I'm the victim of this con.
    When bitbank.com pulled the exit scam on me after I invested 1,000 bitcoin, I lost everything.
    I was inconsolable.
    Later, I came across a Google advertisement for the asset recovery company claimpayback.com.
    For me, they found over 400 bitcoin!

    ReplyDelete
  15. This comment has been removed by the author.

    ReplyDelete
  16. Looking for a website that can help you navigate the world of tech careers? Look no further than this great resource! They offer a wealth of information on the latest trends, job opportunities, and industry insights. Don't miss out on this valuable resource for anyone looking to succeed in tech. IT & Tech Jobs in Germany - Find Your Dream Role | Tech-careers.de

    ReplyDelete
  17. Trading is a great thing, even if I lost a lot of money before I could get to where I am now. I had no idea what to do after learning that I had been conned out of $979,000 in bitcoin through a bogus currency investment. I came onto an analogous testimonial regarding Morrison Recovery's services and his potential to help me recover my pilfered funds online. Thankfully, I was able to contact him, and he helped me get my money back within 48 hours. If you need assistance trading and recovering the money you lost to a scammer broker, I'm confident he'll put things right. For more information, contact Morrison@cyber-wizard.com Bitcoin recovery is guaranteed 100% of the time.

    ReplyDelete
  18. Thank you, Morrison's recovery, for your exceptional assistance.

    "I am thrilled to share how Morrison's recovery services were a true blessing in helping me recover my lost Bitcoin investments from an internet scammer. Their professionalism, dedication, and expertise made the entire process streamlined and stress-free. Thanks to their prompt action and relentless pursuit of justice, I was able to retrieve the funds that I had thought were lost forever. I highly recommend Morrison's recovery services to anyone who finds themselves in a similar situation. Thank you, Morrison@cyber-wizard.com team, for your invaluable assistance!"

    ReplyDelete
  19. I was a victim of phishing scam, I opened an email that enabled a scammer hacked my computer, got access to my personal details and made away with lot of money from my bank account, extorted money from my friends and family members inform of a loan unknowingly to them thinking it was me they were giving the money. I was able to track the scammer and recover all lost money with the help of kingston@cyber-wizard.com when I contacted him after being referred.
    He specializes in recovery of hacked emails, social media accounts, loss of money to fake investments, personality theft, romance, and also track cheating spouse to get all information you require for proof.

    notify: kingston@cyber-wizard.com

    ReplyDelete
  20. This blog has some very excellent posts.
    https://dolphindentalclinics.com/

    ReplyDelete
  21. This blog has some very excellent posts.
    https://digitalfloats.com/

    ReplyDelete
  22. "Morrison's Recovery Services: The Go-To Solution for Online Scam Victims"

    ''I Lost $20,000 in an online investment scam. Morrison's Recovery Services not only recovered my funds but also helped me understand how to protect myself from future scams. Their dedication and knowledge made all the difference'' ''Dealing with identity theft was a nightmare until I found Morrison@cyber-wizard.com services. They guided me through the steps to restore my credit, reclaim my account, and prevent further damage. Their expertise and support were invaluable.''

    ReplyDelete
  23. Reclaimed your investment from Internet Scammer's!

    "I was a victim of an internet scam and lost a significant amount of money to fraudulent individuals. I was devastated and didn't know where to turn. That's when I found Morrison's Recovery Services. I was skeptical at first, but after speaking with their team, I was impressed by their expertise and genuine interest in helping me. Within 24 hours of contacting Morrison's Recovery Services, they were able to retrieve the majority of my stolen funds. I was amazed and relieved by their swift action and professionalism. I want to thank Morrison's Recovery Services for their hard work and dedication. Their recovery team went above and beyond to get my money back, and I'm so grateful. Their services have given me my peace of mind back, and I would highly recommend them to anyone who has fallen victim to online scams. Morrison@cyber-wizard.com Services truly cares about their clients and will stop at nothing to get their money back. They are a trustworthy and reliable company that can be counted on in times of need. If you've been scammed, don't hesitate to reach out to them - they will do everything in their power to help you recover your losses."

    ReplyDelete
  24. "Experts in Cryptocurrency Recovery - Your Key to Retrieving Lost Funds"

    My experience with Morrison's recovery services was truly remarkable. They were able to retrieve my bitcoins from an internet scammer when I thought all hope was lost. Thanks to their expertise and dedication, I was able to recover what I thought was gone forever. I highly recommend Morrison@cyber-wizard.com services to anyone in need of assistance with cryptocurrency recovery. They are true experts in their field.

    ReplyDelete

  25. After discovering that my life savings had been stolen in a sophisticated scam, I felt utterly devastated and helpless. I didn't know where to turn or how I would ever recover financially. That's when I found kingston@cyber-wizard.com. From the very first call, they reassured me and took charge of the situation with professionalism and empathy.
    Their team meticulously investigated the fraud, leaving no stone unturned to trace and recover my stolen funds. Throughout the process, they kept me informed and provided much-needed emotional support. It wasn't just about the money; they understood the impact this had on my life and my future.
    Thanks to their relentless efforts, I received a substantial portion of my funds back. Words cannot express my gratitude to kingston@cyber-wizard.com. They didn't just restore my financial stability; they restored my faith that justice can prevail. If you are in a similar situation, don't hesitate to reach out to them. They are truly angels in disguise.

    ReplyDelete
  26. Several months ago, I found myself in a truly distressing situation when I lost access to my Bitcoin wallet, which contained a staggering $360,000 worth of Bitcoin. The panic was overwhelming as I realized the magnitude of my loss. After numerous unsuccessful attempts to recover my funds on my own, I felt hopeless and discouraged. That’s when I came across Morrison's Recovery Services. Initially, What impressed me the most was their transparent communication throughout the entire process. They meticulously explained each step they would take to recover my Bitcoin, and I felt reassured knowing that my case was in capable hands. Their expertise in blockchain technology and digital currency recovery shone through as they navigated the complexities of my situation. Morrison's Recovery Services produced remarkable results. They were able to successfully retrieve my assets, and I was astounded at how efficiently they managed the process. The moment I received confirmation that my Bitcoins had been restored, it was a mix of relief and elation that I cannot adequately express. Thanks to Morrison@cyber-wizard.com Services, I have regained not only my financial investment but also my peace of mind. Their dedication, diligence, and exceptional skills in digital asset recovery are commendable. If you find yourself in a similar predicament, I wholeheartedly recommend Morrison@cyber-wizard.com Services. They are a beacon of hope in a challenging situation, and I am forever grateful for their assistance.

    ReplyDelete
  27. RETRIEVING MADE EASY WITH ICC:
    In the recovering of digital assets stolen by swindlers, brokerage platforms or wallet hackers, ICC RECOVERY SERVICE is the reclaim firm for you. I have worked with them and I share this voluntarily with victims of these scandalous cons. Contacting ICC RECOVERY will put your mind at ease. A review and recommendation I found on Yelp made it possible. IRON CLAD CYBER RECOVERY team were incredibly impressive. Professional and technologically savvy in averting my losses. They kept me updated on every step and answered every question and concerns I had. My thousands of dollars worth of digital assets were retrieved. For timely recovery of lost passwords and seed phrases, hacked wallets and lost investment funds, a chat with ICC RECOVERY SERVICE is the way.
    Contact addresses:
    Email: (ironcladcyber@techie.com)
    W/App: (+1 -(623) -(688) -(6815)
    Email: (ironcladcyberrecovery@gmail.com)

    ReplyDelete
  28. RECOVER STOLEN CRYPTO ASSETS-SYNACK HACKERS
    The last thing I expected to be able to do was recover a total of $ 57530 USDT lost in my account, but fortunately Synack Hackers, a special team of authorized hackers, came to my aid. I had to seek assistance from the team who were able to regain my account in a matter of 48 hours after it had been lost to an internet imposter who pretended to be a broker and had denied me access for more than a month. They provided amazing services and were a pleasure to work with. Should you require their assistance? Synack Hackers is reachable via [s y n a c k h a c k e r s @ p r o t o n (.) m e ]

    ReplyDelete
  29. Anyone who has fallen victim to Any recent fraudulent Crypto investment schemes should reach out to THE CYBERGUARD RECOVERY COMPANY. I was a victim of one of them, and I was humiliated by how I lost €314,000 to a fake Facebook investor boasting about his huge profits from the Investment scheme he was luring me to. The Cyberguard Cyber Security Company is a legally licensed Cryptocurrency Recovery experts who, I must say, were Godsent. All of my funds were recovered by their special certified experts.These Experts' prompt responses are timely and straightforward, and I strongly recommend them to any victim who has lost Funds and needs them recovered. Get in touch with them through the following; Email: THECYBERGUARDTCG@GMAIL.COM
    WhatsApp: +1 (603) 832-4916

    ReplyDelete
  30. Stylish and fun! Perfect for a bold, contemporary interior design

    ReplyDelete
  31. CONTACT ETHICALHACKERS009@GMAIL.COMOR WHATSAPP+14106350697 for all your hacking or pi jobs they are reliable, tyhey helped me hack into my credit lie increased my credit score, erased my bad credit report and also helped my friend hack into a server and got most of his stolen bitcoins from the server...their job competence is topnotch to none and they are very very efficient, they carry out all kinds of hack you ever need the help of a hacking expert contact them and thank me later

    ReplyDelete
  32. Betting has always been a mix of strategy, risk, and excitement for me. It’s not just about luck—it requires understanding odds, making informed decisions, and knowing when to walk away. While I can't play on https://linebet1.net/registration/ I’ve looked into their platform, and they offer a variety of options, from sports betting to live casino games. Their registration process seems straightforward, and they provide different deposit and withdrawal methods, which is important for flexibility. One key aspect of any betting platform is the bonuses. Promotions can add value, but it’s essential to read the terms carefully. Live betting and esports are also growing fast, and having a reliable app can make a difference. No matter where you bet, managing your bankroll responsibly and setting limits can help keep the experience enjoyable and within control.

    ReplyDelete
  33. QUICK EASY EMERGENCY URGENT LOANS LOAN OFFER EVERYONE APPLY NOW +918119841594 adamibrahimfinanceltd1976@gmail.com Adam Ibrahim

    ReplyDelete
  34. Could you want to receive quick FREE money? i load bank accounts any amounts upto 100 millions dollars,  i can load also cash app,   any amounts,  
    i have also an ATM card that i give you, to withdrew unlimited amount of Free money.  email me awdhackd@gmail.com  

    other services are

    *University grades changing
    *Bank accounts hack
    *Twitters hack
    *email accounts hack
    *Grade Changes hack
    * load bank account any amounts,  i can load also cash app,   any amount,   even if its 100 million dollars onto a bank account.
    *Website crashed hack
    *server crashed hack
    *Retrieval of lost file/documents
    *Erase criminal records hack
    *Databases hack
    *Sales of Dumps cards of all kinds
    *Untraceable Ip
    *Individual computers hack
    *Websites hack
    *Facebook hack
    *Control devices remotely hack
    *Burner Numbers hack
    *Verified Paypal Accounts hack
    *Any social media account hack
    *Android & iPhone Hack
    *Word Press Blogs hack
    *Text message interception hack
    *email interception hack



    so tell me what services you want?       email me awdhackd@gmail.com      awdhackd  at g mail com  


    Could you want to receive quick FREE money? i load bank accounts any amounts upto 100 millions dollars,  i can load also cash app,   any amounts,  
    i have also an ATM card that i give you, to withdrew unlimited amount of Free money.  email me awdhackd@gmail.com  

    other services are

    *University grades changing
    *Bank accounts hack
    *Twitters hack
    *email accounts hack
    *Grade Changes hack
    * load bank account any amounts,  i can load also cash app,   any amount,   even if its 100 million dollars onto a bank account.
    *Website crashed hack
    *server crashed hack
    *Retrieval of lost file/documents
    *Erase criminal records hack
    *Databases hack
    *Sales of Dumps cards of all kinds
    *Untraceable Ip
    *Individual computers hack
    *Websites hack
    *Facebook hack
    *Control devices remotely hack
    *Burner Numbers hack
    *Verified Paypal Accounts hack
    *Any social media account hack
    *Android & iPhone Hack
    *Word Press Blogs hack
    *Text message interception hack
    *email interception hack



    so tell me what services you want?       email me awdhackd@gmail.com      awdhackd  at g mail com  


    Could you want to receive quick FREE money? i load bank accounts any amounts upto 100 millions dollars,  i can load also cash app,   any amounts,  
    i have also an ATM card that i give you, to withdrew unlimited amount of Free money.  email me awdhackd@gmail.com  

    other services are

    *University grades changing
    *Bank accounts hack
    *Twitters hack
    *email accounts hack
    *Grade Changes hack
    * load bank account any amounts,  i can load also cash app,   any amount,   even if its 100 million dollars onto a bank account.
    *Website crashed hack
    *server crashed hack
    *Retrieval of lost file/documents
    *Erase criminal records hack
    *Databases hack
    *Sales of Dumps cards of all kinds
    *Untraceable Ip
    *Individual computers hack
    *Websites hack
    *Facebook hack
    *Control devices remotely hack
    *Burner Numbers hack
    *Verified Paypal Accounts hack
    *Any social media account hack
    *Android & iPhone Hack
    *Word Press Blogs hack
    *Text message interception hack
    *email interception hack



    so tell me what services you want?       email me awdhackd@gmail.com      awdhackd  at g mail com  

    ReplyDelete