Session 3 (Scenario based)
- What type of
Transformations are used to Run 10 Packages at a time?
- Load 1 GB text file into
table (fastest method) & Why?
- Issue in package (It is
failed) but is not impact on SQL Server Agent Job & Why?
- How to Deploy the
package into UAT/PROD & Explain various deployment options & which one
is best in Real time?
- How to run the package
in various environments without Configuration ?
- Explain the process flow
to load 100 files into table and each file contains some more tabs &
sometimes the excel files contains un structure data also . How to handle this
case?
- Excel source need to
load into SQL -- Which transformation is used in the package?
- How to use temp table throughout
the package ?
- Package should not run
when there is no file and should run if file is present? How do you create this
package?
- Conditional split (it
won’t work for multiple columns)
- How to load multiple
files with different names from single folder?
- How to load multiple
sheets from a single excel file?
- How to you debug a
failed package at data flow level?
- How to use a temp table
in all of the package? what are the properties we need to set?
- replacement of OLEDB
command
- If using .csv files,
what are the issues are faced
|
|
|
|
|
|
Excel File
|
|
SQL
|
|
SQL
|
|
|
|
|
|
|
Table A
|
|
Table
B
|
|
Table C
|
How to get the joining
data from Table A,B & C in SSIS?
- Explain step by step
process to get the 10 Tables data from Oracle server to SQL Server using SSIS
& without SSIS?
- How to create the
checkpoint? If check point log is deleted in which point onward the package
will run?
- Where you can specify
checkpoint and Transaction
- SCD 6 & SCD 2
scenario
- How to change the
configuration of package on Run time? More ....
Session 2
- Explain SSIS
architecture ?
- Difference between DTS
& SSIS package (Explain briefly)
- What is the use of
deployment and explain the steps of deployment process?
- what is 2012 deployment
model ?
- what are Package
parameters?
- Different between 2012
& 2014 BI Tool, explain each and every thing
- SSIS Synchronous and
Asynchronous transformation ?
- What is CDC and explain
about CDC?
- Explain about Checkpoints
and break points ?
- Difference between raw
file source and destination
- Package security types ?
- What are the types of
transformations in SSIS (Like fully , partial & no blocking)?
- What are fully blocking
transformations & Partial ?
- Encryption mechanism in
SSIS
- How to send the
Encryption files to clients in SSIS
- CLR Program
- Error Exceptions in SSIS
- Lookup and different
types of caches and why we use it ?
- Knowledge on Migration in SSIS? More ....
Session
1 (Simple)
- Different types of
Constrains in SSIS?
- What
are the Control flow components are using in your project?
- What
is DFT? What will be doing in Data flow task?
- What
is the use of Event Handlers?
- What
is mean of logging and explain about the types
- Explain
about the types of configuration
- Difference
between XML & SQL Configuration
- Diff between OLEDB &
SQL destination
- Diff between OLEDB &
ADO.net destination
- Execute Package task
& Execute Process task
- XML task in SSIS
- FTP task & Web
service task in SSIS
- Union all & Merge in
SSIS
- Explain about Incremental
load process ?
- How to debug the data
flow task ?
- Explain Merge ?
- Difference between merge
and merge join ?
- SCD and its type with
example?
- Explain the lookup
transformation in SSIS?
- how to use temp table
and its properties?
Session 2
- Explain about Role based
security concept (Step by Step) For example customers can visible only US &
UK data.
- Explain about service
level security Mechanism.
- How to get the data from
SQL Server to POWER BI, how many ways
- Explain about the POWER BI
Reports using SSAS Cubes
- How to share the dashboard
to outside the organization, what are the pre requirements
- Client/Customer telling
that he is not able to visible the dashboard? What are the steps to follow to
resolve this issue?
- If someone delete the
report in dashboard? What is happens?
- If you create a dashboard
from a report, after someone delete the report. What message is showing in
dashboard?
- If Client/Customer don’t
have the POWER BI software in there machines then how to share your dashboard
to him? (Explain in step by step)
- How to call the SSRS
report to Dashboard / Dashboard to SSRS report
- Facing ay issues in
Dataset level in current project?
- One hour before data is
not showing in Dashboard after some time the data is showing. How to backtrack
this issue?
- Dashboard in PowerBI and we need changes in
Dimension structure in which level we can do change? .....More
Session 1 (Simple)
- What are the
visualizations worked in the project on POWER BI?
- Views in POWER BI Desktop?
- What are the Apps are
showing in POWER BI Service / Desktop
- Explain about DAX
functions & calculated columns
- What are the
visualizations in SSRS & POWER BI
- Content pad uses
- What are the filters in
POWER Bi
- What is Drill down &
Drill through functionality in POWER BI
- What are the licenses
required to show POWER BI Reports
- What is the service behind
in POWER BI
- What are the different
gateways in POWER BI
- Explain the Data model
concept in POWER BI
- Explain the relationships
concept in POWER BI
- Tell me 4 or 5 DAX
Expressions in POWER BI are using in your project
- Difference between Power bi & SSRS Reports?
- What is the difference between management
gateway enterprise and personal gateway?
- Differences of Charts, dashboard and reports?
- What if chart doesn't have data? How do you make
sure that charts will have data? .... More
SSAS
Interview Questions
- What is
use of SSAS Cube?
- How Cubes
are implemented in SSAS
- At the
time of Creating of cube, what challenges you faced?
- How many
languages are used to retrieve data from cube?
- member,tuple,set
definition explain with example
- What is Named
set?
- Explain recent development
scenario in SSAS
- How to
Deploy the Cube?
- Type property in SSAS
Dimension
- Unknown member is SSAS
- Fact-Many
Many- to Many-to remove duplicates ?
- Named
Calculations and example in real time
- Explain Aggregations
usage in cube level
- How to
improve cube performance?
- Before
cube creation process methods
- What is
Ragged Hierarchy?
- What are
Different Ways of Creating Aggregations?
- What is
Write Back Property in Partition?
- In DSV
Tables or Named Query Calculations. Which one is Execute One?
- What is
the Difference between Derived Measure and Calculated Measures?
Datawarehouse/DW Interview Questions
- Explain about Data warehousing concepts?
- Star schema and snow flake schema?
- Explain the structure of Fact & Dimensions
tables
- Difference between OLTP & OLAP
- Explain about MOLAP , ROLAP, HOLAP
- Have you ever worked on Data modeling?
- Difference between STAR
& SNOWFLAKE Schema
- Briefly explain about DATA
MARTS
- What are Early arriving facts, late arriving dimensions?
- Cascading parameters?
- Types of dimensions & Facts?
- Degeneration
dimensions?
- What is Fact less facts & Junk dimension?
Session
2
- Types of reports in SSRS
- How to send same report data on basis of different country to
different sheet in same excel?
- How to control number of rows on each page in SSRS
- How do you create multi select drop down/parameter? Without Allow
multiple values option?
- How to create cascading parameters? Explain with a scenario in current
project?
- What kind of export you worked in current project?
- What are the Issues in exporting to excel or pdf?
- How to set page names in exported copy?
- How to set limit on page size while exporting? I.e. when exported, the
page should contain only 50 rows. How do you achieve it?
- What kind of reports you created?
- How do you do deployments in SSRS on current project?
- What types of Expressions are using in current project?
- How to use 2 different dataset fields in single report?
- How to restrict a particular user not to see a particular report data?
- How to split and export report data into multiple excel sheets?
- Drill down and Drill through,
Deployment types?
- How to get deployment
permissions if you don’t have to do so?
- Explain about permissions on
SSRS Reports?
- What was the chain -- how to
give the permission -- permission action on user or URL?
- How will give permissions on
URL's and Reports? More ....
Session
1
- What are the type of reports are available in
SSRS?
- What are the steps to follow to create the
Report?
- Different types of SSRS Reports
- What is Parameterized Reports?
- Difference between tabular and matrix
- Diff between drill down and drill through
- How to restrict rendering options in SSRS
- What are the uses of “Sub reports” in SSRS?
- How to hide Rendering options
in Report level & Group of Reports level
- In my system so many SQL Agent
jobs are running (SSMS), I want a report to show the job running status report
with all information?
- Drill through & Drill Drop
Reports
- What is Subscriptions? And
types in SSRS?
- Data driven subscriptions?
- Difference between report server and report manager
- What is the use of page breaks?
- What is bookmark in SSRS?
- What types are modes are included in report server installation? More ....
Project related
Questions:
- Explain the Roles
& Responsibilities on current Project?
- What is the day to day activates in your job?
- Which SDLC process is using in your project
(Water fall , Agile)
- Control flow components are using in current
project
- What kind of sql & BI tool in your current
project?
- What are the SSIS
Transformations are using in your project?
- How to Monitoring
the jobs on current Project?
- Incremental load
& Full load process following in working project
- What type of
Transactions on current Projects?
- Errors on your
Project and How to handle it?
- What are the visualizations worked in the project?
- Facing issues in current project?
