GSPANN Technologies Cognos Developer Interview Questions and Answers for Experienced

Q1. Use of display in databricks
Ans. 
Display in Databricks is used to visualize data in a tabular format or as charts/graphs.
• Display function is used to show data in a tabular format in Databricks notebooks.

• It can also be used to create visualizations like charts and graphs.

• Display can be customized with different options like title, labels, and chart types.
Answered by AI
Add your answer
Q2. How to create workflow in databrics
Ans. 
To create a workflow in Databricks, use Databricks Jobs or Databricks Notebooks with scheduling capabilities.
• Use Databricks Jobs to create and schedule workflows in Databricks.

• Utilize Databricks Notebooks to define the workflow steps and dependencies.

• Leverage Databricks Jobs API for programmatic workflow creation and management.

• Use Databricks Jobs UI to visually design and schedule workflows.

• Integrate with Databricks D
Answered by AI
Add your answer

Q1. All abt sql and databricks Then some questions from adf
Add your answer

It was good and comparatively moderate.

Q1. What is indexing in SQl
Ans. 
Indexing in SQL is a technique to improve the performance of queries by creating a data structure that allows for faster retrieval of data.
• Indexes are created on columns in a database table to speed up the retrieval of data.

• They work similar to the index in a book, allowing the database to quickly find the rows that match a certain value.

• Indexes can be created using single or multiple columns.

• Examples: CREATE INDEX ind
Answered by AI
Add your answer

Q1. Sql and python questions
Add your answer

Q1. Project based question
Add your answer
Q2. In depth sql queries
Add your answer

I was asked 2 coding problems in pyspark, after that a discussion round followed.

Q1. Explain databricks dlt, and when will you use batch vs streaming?
Ans. 
Databricks DLT is a unified data management platform for batch and streaming processing.
• Databricks DLT (Delta Lake Table) is a storage layer that brings ACID transactions to Apache Spark and big data workloads.

• Batch processing is used when data is collected over a period of time and processed in large chunks, while streaming processing is used for real-time data processing.

• Use batch processing for historical data analy...read more
Answered by AI
Add your answer
Q2. What is the difference between deltalake and delta warehouse
Ans. 
Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads, while Delta Warehouse is a cloud-based data warehouse service.
• Delta Lake is an open-source storage layer that brings ACID transactions to Apache Spark and big data workloads.

• Delta Warehouse is a cloud-based data warehouse service that provides scalable storage and analytics capabilities.

• Delta Lake is more fo...read more
Answered by AI
Add your answer

Q1. SQL problem window function
Add your answer
Q2. SQL code like join and scenerio
Add your answer

Q1. Design round for adf pipeline
Ans. 
Designing an ADF pipeline for data processing
• Identify data sources and destinations

• Define data transformations and processing steps

• Consider scheduling and monitoring requirements

• Utilize ADF activities like Copy Data, Data Flow, and Databricks

• Implement error handling and logging mechanisms
Answered by AI
Add your answer
Q2. Azure synapses and adf adb
Add your answer

Q1. Expected ctc and current ctc negotiations
Ans. 
Discussing expected and current salary for negotiation purposes.
• Be honest about your current salary and provide a realistic expectation for your desired salary.

• Highlight your skills and experience that justify your desired salary.

• Be open to negotiation and willing to discuss other benefits besides salary.

• Research industry standards and salary ranges for similar positions to support your negotiation.

• Focus on the value y...read more
Answered by AI
Add your answer
Q2. Relocation and remote work until ofc open for Pune location
Add your answer

Q1. Spark fundamentals
Add your answer
Q2. Python
Add your answer

Pyspark joining strategies, coding, and Python-based problem-solving techniques.