Add office photos
Filter interviews by
Sakshi Infotech Solutions SQL and MSBI Developer Interview Questions and Answers
Sakshi Infotech Solutions SQL and MSBI Developer Interview Experiences
1 interview found
Anonymous
Selected
I applied via Job Portal and was interviewed before Jan 2023. There was 1 interview round.
(3 Questions)
- Q1. Store procedure, joins, normalisation
- Q2. Asked about SQL server, SSIS Etl tools
- Q3. SQL server, T-SQL SSIS MySQL
Top trending discussions
Interview questions from similar companies
Selected
I applied via Referral and was interviewed in Sep 2023. There were 3 interview rounds.
(3 Questions)
- Q1. How can you segregate data from one file to many file based on data value of a particular column.
- Ans.
Use SQL queries to filter data based on a particular column value and export to separate files.
Use SELECT statement with WHERE clause to filter data based on the particular column value
Use INSERT INTO statement to insert the filtered data into separate tables or files
Consider using a loop or cursor to iterate through the data and export to multiple files
- Q2. How to access multiple data file place in same directory.
- Ans.
To access multiple data files in the same directory, use a wildcard character (*) in the file path.
Use a wildcard character (*) in the file path to access all files in the directory.
For example, to access all CSV files in a directory, use 'SELECT * FROM folder_path/*.csv'.
Make sure the SQL query or MSBI package is configured to handle multiple files.
- Q3. How to delete data if there is no primary key while there are repeated data sets
- Ans.
You can delete data without a primary key by using a combination of columns to identify and remove duplicate records.
Identify unique combination of columns to differentiate between duplicate records
Use the identified columns in a DELETE statement to remove duplicate records
Consider using temporary tables or CTEs to handle the deletion process efficiently
Scenario based questions
(2 Questions)
- Q1. Why you want to join Capgemini?
- Q2. What makes you confident that Capgemini will offer you?
Interview Preparation Tips
sachin yadav
(1 Question)
- Q1. Define power bi and its feature
- Ans.
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI allows users to create reports and dashboards using data from various sources.
It offers features like data visualization, data modeling, and data manipulation.
Users can share and collaborate on reports with others, and access them on multiple devices.
Power BI integrates with other ...
(1 Question)
- Q1. Tell me about yourself
Skills evaluated in this interview
I applied via Newspaper Ad and was interviewed in Nov 2021. There were 2 interview rounds.
(2 Questions)
- Q1. What is your biggest achievement so for?
- Q2. Why do u want to work for our company
Interview Preparation Tips
(2 Questions)
- Q1. Explain sql commands
- Q2. Explain normalization in sql
Selected
I applied via Company Website and was interviewed in Nov 2024. There were 2 interview rounds.
Sql
ddl
dml
tcl
dql
joins
view
date commit
Date commit
joins
view
sum
max
avg
count
min
(1 Question)
- Q1. What is sql , index , stored proc , triggers
(2 Questions)
- Q1. Difference bw table and matrix
- Ans.
A table is a two-dimensional representation of data, while a matrix is a multi-dimensional representation of data.
Tables have rows and columns, while matrices can have multiple dimensions.
Tables are typically used for simple data structures, while matrices are used for more complex data analysis.
In Power BI, tables are used for displaying data in a tabular format, while matrices are used for creating pivot tables and c
- Q2. Syntax for Calculate function
- Ans.
Calculate function in DAX is used to evaluate an expression for a specific filter context.
Syntax: CALCULATE(
, , , ...) Can be used to apply filters to an expression
Can override existing filters in the current context
Example: CALCULATE(SUM(Sales[Amount]), Sales[Region] = 'North')
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. How to insert multiple values in one go
- Ans.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
- Q2. Update query using joins
- Ans.
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
Interview Preparation Tips
Skills evaluated in this interview
I applied via Company Website and was interviewed in Apr 2024. There were 3 interview rounds.
Test your algorithmic thinking and problem solving skills
(1 Question)
- Q1. Communications,clearity of answers
(1 Question)
- Q1. Discussion about packages,joining date
Interview Preparation Tips
Sakshi Infotech Solutions Interview FAQs
Tell us how to improve this page.
Sakshi Infotech Solutions Interviews By Designations
Interview Questions for Popular Designations
- MS SQL DBA Interview Questions
- Msbi Developer Interview Questions
- SQL Developer Interview Questions
- MSBI and Power BI Developer Interview Questions
- SQL Database Administrator Interview Questions
- SQL and PL SQL Developer Interview Questions
- Oracle SQL and PLSQL Developer Interview Questions
- SQL Server Developer Interview Questions
- Show more
People are getting interviews through
Interview Questions from Similar Companies
|
Software Developer
10
salaries
|  ₹3 L/yr - ₹6 L/yr |
|
Software Engineer
6
salaries
| ₹3 L/yr - ₹6.5 L/yr |
|
Msbi Developer
5
salaries
| ₹3 L/yr - ₹5.1 L/yr |
|
HR Manager
4
salaries
| ₹8.1 L/yr - ₹30 L/yr |
|
Software Consultant
4
salaries
| ₹4 L/yr - ₹5.2 L/yr |
Infosys
TCS
Wipro
HCLTech
Calculate your in-hand salary
- Home >
- Interviews >
- Sakshi Infotech Solutions Interview Questions >
- Sakshi Infotech Solutions SQL and MSBI Developer Interview Questions
