SI-UK Interview Questions and Answers

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 analysis, ETL jobs, and periodic reporting. Use streaming proce...read more

Power BI offers different types of licenses for data modeling, including Power BI Pro and Power BI Premium.

• Power BI Pro license allows users to create and share reports and dashboards with others.

• Power BI Premium license offers additional features such as larger data capacity and advanced AI capabilities.

• Power BI Embedded license is designed for embedding reports and dashboards into custom applications.

• Power BI Report Server license allows for on-premises report publishing an...read more

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 focused on data lake operations and ensuring data reliabilit...read more

The most frequent word in a sentence can be found by counting the occurrence of each word and selecting the one with the highest count.

• Split the sentence into words using whitespace as delimiter

• Create a dictionary to store the count of each word

• Iterate through the words and update the count in the dictionary

• Find the word with the highest count in the dictionary

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 you can bring to the company rather than just the monetary ...read more

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 index_name ON table_name(column_name);

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