AZURE DATA FACTORY INTERVIEW QUESTIONS: INTEGRATION RUNTIME and TYPES.

 INTEGRATION RUMTIME

      Intergration Runtime is the compute Infrastructure used by ADF.

      Integration runtime is the one who provides the computer resources for the data transfer activities and for dispatching the data transfer activities in azure data factory.

      Integration runtime provides the area where this activity can execute.

TYPES:-

     1.AZURE INTEGRATION RUNTIME.

     2.SELF HOSTED INTEGRATION RUNTIME.

     3.AZURE SSIS INTEGRATION RUNTIME.

1.AZURE INTEGRATION RUNTIME:-

          *Azure Integration runtime (Auto Resolve Integration Runtime) provides fully managed,                          serverless compute in Azure itself.

          *You don't have to worry about Infrastructure provision , Software installation, Patching or                        Capacity scaling.

          *In addition , you only need  to pay for the duration of the actual utilization.

2.SELF HOSTED INTEGRATION RUNTIME:-

          *The Self Hosted Integration Runtime copies data between private on-premises store to public                  cloud storage.

          *The direction of the copy depends on how the copy activity is configured in the data pipeline.

3.AZURE SSIS INTEGRATION RUNTIME:-

          *Azure SQL Server Integration Services (SSIS) is a component of the SQL server database                        software that can be used to perform a broad range of data migration (ETL) tasks.

          *May also be used to automate maintenance of SQL Server database and updates to data.





Comments

Post a Comment

Popular posts from this blog

SQL Interview Questions:3

Image
3. FETCH THE EMPLOYEES WHOSE SALARY IS GREATER THAN AVERAGE SALARY OF THEIR DEPARTMENT. CREATE   table employee ( id int, name varchar (100), dept_Id int, salary int ) insert into employee values(1,'vineela',1,20000),(2,'lakshmi',1,30000),(3,'gayithri',1,30000), (4,'mukundh',2,45000),(5,'kavya',2,300000),(6,'sithara,2,45000) select * from employee method1:-         select a.name,a.dept_Id,a.salary  from employee a where a.salary >(select avg(salary) from         employee b where b.dept_Id=a.dept_Id)                                              method2:- select t1.name,t1.dept_Id, ,t1.salary  from employee as t1 join (select dept_Id,avg(salary) as avgsalary from employee group by dept_Id) as t2 on t1.dept_Id=t2.dept_Id where salary>avgsalary             ...
Read more

AZURE DATA FACTORY INTERVIEW QUESTIONS: FILES FORMATS

  21.Diffrence types of file formats? 1.Delimited text files       CSV Files and TSV Files   CSV Files:-            *Comma Separated Values           *  In which comma ,pipe etc. are used to separate the fields and values in CSV files.  TSV Files:-           * Tab separated values.           *In which tab or space are used to separate the fields and values.           *Fixed width data in which each field is allocated a fixed number of characters. 2.JSON           *Java Script Object Notation (JSON).            * JSON format file is a standard data interchange format.            *JSON files are text-based, human-readable, can be edited easily.     example:-          {         ...
Read more

AZURE DATA FACTORY INTERVIEW QUESTIONS :ACTIVITIES AND TYPES.

  ACTIVITIES:-      The Activities in a pipeline defines actions or operations to perform on your data. TYPES:-        1.DATA MOVEMENT ACTIVITIES.       2.DATA TRANSFORMATION  ACTIVITIES.       3. CONTROL FLOW ACTIVITIES.   1. DATA MOVEMENT ACTIVITIES :-         Copy Data :-                   The Copy Data Activity is the core tool in Azure data factory that can move the data from Source to Sink (destination). 2. DATA TRANSFORMATION  ACTIVITIES :-         Data flow:-               Data flow activity is a cloud native graphical data transformation tool.             types:-             1.Mapping Data flow             2.Wrangling Data flow.          1.Mapping Data flow:- ...
Read more