TresVista Data Engineer Interview Questions and Answers

Q1. SQL and Python and Spark related questions
Add your answer
Q2. Project-oriented questions
Add your answer

Q1. Coding and AWS cloud-related questions like GLUE, LAMBDA, Redshift etc
Add your answer
Q2. Project and managerial-related questions
Add your answer

Q1. What is delta lake and its architecture
Ans. 
Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads.
• Delta Lake provides ACID transactions, scalable metadata handling, and unifies streaming and batch data processing.

• It stores data in Parquet format and uses a transaction log to keep track of all the changes made to the data.

• Delta Lake architecture includes a storage layer, a transaction log, and a metadata l...read more
Answered by AI
Add your answer
Q2. Activities in ADF
Ans. 
Activities in ADF refer to the tasks or operations that can be performed in Azure Data Factory.
• Activities can include data movement, data transformation, data processing, and data orchestration.

• Examples of activities in ADF are Copy Data activity, Execute Pipeline activity, Lookup activity, and Web activity.

• Activities can be chained together in pipelines to create end-to-end data workflows.

• Each activity in ADF has prop...read more
Answered by AI
Add your answer
Q3. Explain mounting process in Databricks
Ans. 
Mounting process in Databricks allows users to access external data sources within the Databricks environment.
• Mounting allows users to access external data sources like Azure Blob Storage, AWS S3, etc.

• Users can mount a storage account to a Databricks File System (DBFS) path using the Databricks UI or CLI.

• Mounted data can be accessed like regular DBFS paths in Databricks notebooks and jobs.
Answered by AI
Add your answer
Q4. Difference between Blob storage vs Data Lake
Ans. 
Blob storage is for unstructured data, while Data Lake is for structured and unstructured data with metadata.
• Blob storage is optimized for storing large amounts of unstructured data like images, videos, and backups.

• Data Lake is designed to store structured and unstructured data with additional metadata for easier organization and analysis.

• Blob storage is typically used for simple storage needs, while Data Lake is used ...read more
Answered by AI
Add your answer

SQL coding and Ssis technical skills

Q1. SQL server Database concepts
Add your answer

Q1. What are hooks, event loop usecontext api
Add your answer
Q2. What is aggregator
Add your answer

Q1. What is the difference between normal and arrow functions
Ans. 
Arrow functions are more concise and have a lexical 'this' binding compared to normal functions.
• Arrow functions do not have their own 'this' keyword, they inherit it from the parent scope.

• Arrow functions do not have their own 'arguments' object.

• Arrow functions cannot be used as constructors with 'new'.

• Arrow functions are more concise and have implicit return when no curly braces are used.
Answered by AI
Add your answer
Q2. All basic JS Questions to cover Hoisting closure
Add your answer
Q3. They asked to show me an example using the API call
Add your answer
Q4. Difference between forEach and Map
Ans. 
forEach is used to iterate over an array and perform a function on each element, while map creates a new array by applying a function to each element.
• forEach does not return a new array, while map does

• forEach does not modify the original array, while map creates a new array

• forEach is used for side effects, while map is used for transformation

• Example: forEach - array.forEach(item => console.log(item)), map - const newAr
Answered by AI
Add your answer

Jsjwkqnsnns.hejwkqp hsowpa bsoqla bspam

Bsppq hspals bsoak nspal bdoa a

Hsoaks bspapa bosoaks bospmwa bosoebs

Q1. Jspwpaknsbe jsos heopw
Add your answer
Q2. Jsppq jepwl jspam
Add your answer

Hdosm jspwl jspwla bqiq heowwo hsowoa

Q1. Hslwla jwpwpq belwp
Add your answer
Q2. Bspwlw noslw nspq a
Add your answer

Q1. Asked about oops
Add your answer
Q2. And also aked SQL related queries
Add your answer