Amazon Data Management Associate Interview Questions and Answers

Q1. About current project
Add your answer
Q2. Snowflake limitations
Ans. 
Snowflake has limitations such as maximum table size, maximum number of columns, and maximum number of concurrent queries.
• Snowflake has a maximum table size of 16TB for all tables, including temporary and transient tables.

• There is a limit of 1600 columns per table in Snowflake.

• Snowflake has a maximum of 10,000 concurrent queries per account.

• There are also limitations on the number of objects (databases, schemas, tables
Answered by AI
Add your answer

Q1. How to split staged data’s row into separate columns
Ans. 
Use SQL functions like SUBSTRING and CHARINDEX to split staged data's row into separate columns
• Use SUBSTRING function to extract specific parts of the row

• Use CHARINDEX function to find the position of a specific character in the row

• Use CASE statements to create separate columns based on conditions
Answered by AI
Add your answer
Q2. How would you monitor an overnight data load job in snowflake
Ans. 
Monitor overnight data load job in Snowflake
• Set up alerts and notifications for job completion or failure

• Check job logs for any errors or issues

• Monitor resource usage during the data load process

• Use Snowflake's query history to track job progress

• Implement automated retries in case of failures
Answered by AI
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

Q1. What is joins in SQL
Ans. 
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column between them

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

SQL - shared question on the screen and asked to code in SQL

Q1. Nth highes salary
Add your answer

Q1. What is degination
Ans. 
Designation refers to the job title or position held by an employee in an organization.
• Designation is a term used to describe the job title or position held by an employee in an organization.

• It is often used interchangeably with job title.

• Examples of designations include Manager, Executive, Analyst, etc.
Answered by AI
Add your answer
Q2. What is job interest in
Ans. 
My job interest in data entry operator role lies in my attention to detail, organizational skills, and ability to work efficiently with data.
• I have a strong attention to detail, ensuring accuracy in data entry tasks.

• I am highly organized, allowing me to efficiently manage and prioritize data entry assignments.

• I enjoy working with data and have experience in handling large volumes of information.

• I am proficient in using...read more
Answered by AI
View 1 more answer

SQL test on hackerrank

1.Basic SQL
2. Python based question
3.Data modelling
4. Spark
5. Cloud based questions

Sql,Python,Data Modeling and Project based questions

Q1. Salary discussion and cultural fit.
Add your answer
Q2. Basic cultural fit.
Add your answer

Q1. When I initially joined my job right after college there was a point where I was constantly
Add your answer
Q2. It's a great organisation and I've learner a lot here but it's such a small company that it's difficult to find ways to move up ask yourself what makes you feel passionate or happy when you work😊
Add your answer
Q3. Opportunity great time interest must
Add your answer

Group discussion can also provide feedback to instructors on participant comprehension.