Altimetrik Interview Questions, Process, and Tips

Q1. Sql questions on case statments and joins
Add your answer
Q2. Python and project related questions
Add your answer

Q1. Find columns from a table where data type is timestamp.
Ans. 
Use SQL query to find columns with timestamp data type in a table.
• Use a SQL query like 'SHOW COLUMNS FROM table_name WHERE Type = 'timestamp''

• Alternatively, query the information_schema.columns table for column data types

• Check for variations of timestamp data types like datetime, timestamp, etc.
Answered by AI
Add your answer
Q2. Alter column name
Add your answer
Q3. Delete column from a table
Ans. 
To delete a column from a table, use the ALTER TABLE command.
• Use the ALTER TABLE command followed by DROP COLUMN to delete a column from a table.

• Specify the name of the column you want to delete after the DROP COLUMN keyword.

• Make sure to carefully consider the impact of deleting a column on the data and any dependent objects.
Answered by AI
Add your answer
Q4. Difference between drop, truncate and delete
Ans. 
Drop removes a table from the database, truncate removes all rows from a table, and delete removes specific rows from a table.
• DROP: Removes the entire table structure and data from the database.

• TRUNCATE: Removes all rows from a table but keeps the table structure.

• DELETE: Removes specific rows from a table based on a condition.

• Example: DROP TABLE table_name;

• Example: TRUNCATE TABLE table_name;

• Example: DELETE FROM table_n
Answered by AI
Add your answer
Q5. Difference between top and limit.
Ans. 
Top is used to select the first few rows from a dataset, while limit is used to restrict the number of rows returned in a query.
• Top is commonly used in SQL Server, while limit is commonly used in MySQL.

• Top is used with the SELECT statement in SQL Server to limit the number of rows returned, while limit is used in MySQL to restrict the number of rows returned.

• Example: SELECT TOP 5 * FROM table_name; (SQL Server) vs. SEL
Answered by AI
Add your answer
Q6. What is difference between count(*) and count(1)
Ans. 
count(*) counts all rows in a table, while count(1) counts the number of non-null values in a specific column.
• count(*) counts all rows in a table

• count(1) counts the number of non-null values in a specific column

• count(*) is generally used when you want to count all rows in a table, while count(1) is used when you want to count non-null values in a specific column
Answered by AI
Add your answer
Q7. FInd second index of "l" from a string "Hello". write a py code.
Ans. 
Find the second index of 'l' in the string 'Hello'.
• Use the find() method to find the first index of 'l'.

• Use the find() method again starting from the index after the first 'l' to find the second index.

• Handle cases where the first 'l' is not found or there is no second 'l'.
Answered by AI
Add your answer

Coding + Aptitude question

Q1. Basic of programming lang.
Add your answer
Q2. DSA and Oop concepts questions.
Add your answer

Q1. Architecture level questions
Add your answer
Q2. Project Management related questions
Add your answer

Q1. GCP main components and its uses
Ans. 
GCP main components include Compute Engine, Cloud Storage, BigQuery, and Dataflow for various uses.
• Compute Engine - Virtual machines for running workloads

• Cloud Storage - Object storage for storing data

• BigQuery - Data warehouse for analytics

• Dataflow - Stream and batch processing of data
Answered by AI
Add your answer
Q2. About Big Query architecture
Add your answer

Q1. How can you optmize dags?
Ans. 
Optimizing dags involves reducing unnecessary tasks, parallelizing tasks, and optimizing resource allocation.
• Identify and remove unnecessary tasks to streamline the workflow.

• Parallelize tasks to reduce overall execution time.

• Optimize resource allocation by scaling up or down based on task requirements.

• Use caching and memoization techniques to avoid redundant computations.

• Implement data partitioning and indexing for eff
Answered by AI
Add your answer
Q2. How can we handle unacknowledged messages in pubsub?
Ans. 
Unacknowledged messages in pubsub can be handled by implementing retries, dead letter queues, and monitoring mechanisms.
• Implement retries for unacknowledged messages to be redelivered.

• Use dead letter queues to store messages that repeatedly fail to be processed.

• Set up monitoring mechanisms to track unacknowledged messages and identify potential issues.
Answered by AI
Add your answer