Zifo RnD Solutions Data Manager Interview Questions and Answers

The first round was a combination of MCQs and SQL Coding test. It consisted of 23 MCQs on SQL, 10 MCQs on Power BI and 5 SQL Coding questions.

Q1. Simple questions on SQL were asked.
Add your answer

Q1. What is pivot table in Excel?
Ans. 
A pivot table in Excel is a data summarization tool that allows you to reorganize and summarize selected columns and rows of data.
• Pivot tables allow you to analyze and summarize large amounts of data in a spreadsheet.

• You can easily rearrange the layout of the data to view it from different perspectives.

• Pivot tables can perform functions like sum, average, count, and more on the data.

• They are useful for creating reports...read more
Answered by AI
Add your answer
Q2. What is 'Data Validation' in Excel?
Ans. 
Data Validation in Excel ensures that data entered in a cell meets certain criteria or conditions.
• Data Validation allows you to set rules for what can be entered in a cell, such as a range of values, a list of items, or a custom formula.

• Examples of Data Validation include setting a drop-down list of options for a cell, restricting input to a certain number range, or ensuring dates are entered in a specific format.

• Data ...read more
Answered by AI
Add your answer
Q3. What is the order of execution of an SQL query?
Ans. 
The order of execution of an SQL query involves multiple steps to retrieve data from a database.
• 1. Parsing: The SQL query is first parsed to check for syntax errors.

• 2. Optimization: The query optimizer creates an execution plan to determine the most efficient way to retrieve data.

• 3. Compilation: The optimized query is compiled into an executable form.

• 4. Execution: The compiled query is executed by the database engine t...read more
Answered by AI
Add your answer
Q4. What is the difference between Tree Map and Heatmap in Tableau?
Ans. 
Tree Map visualizes hierarchical data using nested rectangles, while Heatmap displays data values using color gradients.
• Tree Map displays data hierarchically with nested rectangles, where the size and color represent different measures.

• Heatmap visualizes data values using color gradients, with darker colors indicating higher values.

• Tree Map is useful for showing hierarchical data structures, while Heatmap is effective ...read more
Answered by AI
Add your answer
Q5. What is the difference between 'Extract Data' and 'Live Connection' in Tableau?
Ans. 
Extract Data saves a snapshot of data in Tableau workbook, while Live Connection directly connects to data source.
• Extract Data creates a static copy of data in Tableau workbook, while Live Connection directly queries data source in real-time.

• Extract Data is useful for working offline or with small datasets, while Live Connection is ideal for large datasets or when data is frequently updated.

• Extract Data can improve per...read more
Answered by AI
Add your answer

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...read more
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Q1. Ques -> Can you define difference b/w Azure data lake and Delta lake.
Ans. 
Azure Data Lake is a cloud-based storage and analytics service, while Delta Lake is an open-source storage layer that adds reliability to data lakes.
• Azure Data Lake is a service provided by Microsoft Azure for storing and analyzing large amounts of data.

• Delta Lake is an open-source storage layer that adds ACID transactions and schema enforcement to data lakes.

• Azure Data Lake is a cloud-based solution, while Delta Lake ...read more
Answered by AI
Add your answer
Q2. How to implemented Primary key and foreign key in delta tables.
Ans. 
Primary keys and foreign keys can be implemented in delta tables using constraints and references.
• Primary keys can be implemented using the PRIMARY KEY constraint, which ensures that each record in the table has a unique identifier.

• Foreign keys can be implemented using the FOREIGN KEY constraint, which establishes a link between two tables based on a common column.

• The referenced table must have a primary key defined, a...read more
Answered by AI
Add your answer
Q3. How to handle exception in python?
Ans. 
Exception handling in Python allows for the graceful handling of errors and prevents program crashes.
• Use try-except blocks to catch and handle exceptions.

• Multiple except blocks can be used to handle different types of exceptions.

• The finally block is executed regardless of whether an exception occurred or not.

• Exceptions can be raised using the 'raise' keyword.

• Custom exceptions can be defined by creating a new class that
Answered by AI
Add your answer
Q4. What is star schema and snowflake schema
Ans. 
Star schema is a data modeling technique where a central fact table is connected to multiple dimension tables. Snowflake schema is an extension of star schema with normalized dimension tables.
• Star schema is a simple and denormalized structure

• It consists of a central fact table connected to multiple dimension tables

• Dimension tables contain descriptive attributes

• Star schema is easy to understand and query, but can lead t...read more
Answered by AI
Add your answer
Q5. Which are the most frequently change
Ans. 
The most frequently changing data
• Customer preferences

• Market trends

• Weather data

• Stock prices

• Social media trends
Answered by AI
Add your answer

Q1. What were my grades in high school
Ans. 
My grades in high school were consistently high, with a GPA of 3.8.
• Consistently high grades throughout high school

• Achieved a GPA of 3.8

• Received honors and awards for academic performance
Answered by AI
Add your answer

Object Detection on a subset of COCO dataset having Cars and Person classes

Q1. Technical discussion on Machine Learning, Deep Learning Concepts and coding round.
Add your answer

Q1. Technical discussion on Deep Learning and Computer Vision.
Add your answer

Two coding questions

Q1. DBMS questions, keys
Add your answer
Q2. SQL related queries
Add your answer

Q1. Explain process in adf
Ans. 
ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

• You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.

• ADF supports a wide range of d...read more
Answered by AI
Add your answer