Artefact Senior Data Engineer Interview Questions and Answers

Q1. What is difference between dynamic data frame and spark data frame in aws glue job? can we change dynamic dataframe to spark datafrmae?
Ans. 
Dynamic data frame in AWS Glue job is a dynamically generated data frame, while Spark data frame is specifically created using Spark APIs.
• Dynamic data frame is generated dynamically at runtime based on the data source and schema, while Spark data frame is explicitly created using Spark APIs.

• Dynamic data frame is more flexible but may have performance implications compared to Spark data frame.

• You can convert a dynamic d...read more
Answered by AI
Add your answer

Q1. Longest Increasing Subsequence
Ans. 
Find the length of the longest increasing subsequence in an array.
• Use dynamic programming to solve this problem efficiently.

• Iterate through the array and keep track of the longest increasing subsequence ending at each index.

• Example: For array [10, 22, 9, 33, 21, 50, 41, 60, 80], the longest increasing subsequence is [10, 22, 33, 50, 60, 80] with length 6.
Answered by AI
Add your answer

Q1. UseEffect polyfill
Add your answer

Q1. Basics of power bi and sql
Add your answer
Q2. What are joins and types of join
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN returns all rows from the right table and the matched rows from the left table

• FULL JOIN...read more
Answered by AI
Add your answer
Q3. How to add date table in power bi
Ans. 
To add a date table in Power BI, you can create a new table with a list of dates and relationships with other tables.
• Create a new table in Power BI with a list of dates

• Add columns for day, month, year, etc. for additional analysis

• Establish relationships between the date table and other tables in the data model
Answered by AI
Add your answer

Q1. Sql scenario based question on joins
Add your answer
Q2. Window function questions
Add your answer
Q3. Performance tuning
Add your answer
Q4. Power bi dax question
Add your answer

Q1. How good are you with numbers
Add your answer

Q1. Vlookup, pivot table, sumif, average, graphs
Add your answer

Q1. Do you know the role and responsibility of this position
Add your answer

Q1. Lifecycle hooks of Angular
Ans. 
Angular lifecycle hooks are methods that allow you to tap into specific points in a component's lifecycle.
• ngOnChanges: called when an input property changes

• ngOnInit: called once the component is initialized

• ngDoCheck: called during every change detection run

• ngAfterContentInit: called after content (ng-content) has been projected into the component

• ngAfterContentChecked: called after every check of the projected content

• ng...read more
Answered by AI
Add your answer
Q2. SOLID principles
Add your answer

Q1. Questions on SQL
Add your answer

Q1. Introduction and basic questions
Add your answer

Questions are asked from hackerrank . Difficulty level medium .
Prepare for SQL too.

Q1. Your projects, system design
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Expected salary
Add your answer