Metropolis Healthcare Sales Interview Questions and Answers

Q1. SQL related questions on snowflake and databricks
Add your answer

Q1. Database architecture and design related questions
Add your answer

Q1. Databricks experience, domain knowledge and mostly experience related questions.
Add your answer

Q1. Expectations and how you would be a good fit. All general HR questions that you can find
Add your answer

There were 2 SQL queries based on rank function and count aggregation. 1 python program based on array.

Q1. 2 sql questions. Was asked which technology I worked on- aws redshift.
Add your answer
Q2. Architecture of redshift. keys in redshift.
Ans. 
Redshift is a cloud-based data warehousing solution by AWS. It uses columnar storage and massively parallel processing.
• Redshift is based on PostgreSQL and uses SQL for querying data.

• It uses columnar storage which is optimized for analytical queries.

• Redshift is a massively parallel processing (MPP) system, which means it can distribute queries across multiple nodes for faster processing.

• It uses key-based sharding to dis...read more
Answered by AI
Add your answer
Q3. 1 python program on sliding window technique .
Ans. 
Sliding window technique is used to solve problems where we need to find a substring of a certain length in a larger string.
• Define the window size and slide it over the string

• Use two pointers to keep track of the start and end of the window

• Examples: Maximum sum subarray of size K, Longest substring with K distinct characters
Answered by AI
Add your answer

Q1. 3 sql queries. architecture for a data pipeline to display hour per activity in last 24 hra on a smartwatch .
Ans. 
Design a data pipeline to display hourly activity on a smartwatch for the last 24 hours using SQL queries.
• Create a table to store activity data with columns for timestamp and activity type.

• Use a SQL query to aggregate activity data by hour for the last 24 hours.

• Display the results on the smartwatch using a suitable visualization.
Answered by AI
Add your answer