Interview Questions and Answers

BI and MS BI Interview Questions and Answers

SQL Server Interview Questions and Answers - Part1
SQL Server Interview Questions and Answers - Part2
SQL Server Interview Questions and Answers - Part3
SQL Server Interview Questions and Answers - Part4
SQL Server Interview Questions and Answers - Part5

SQL Server Integration Services (SSIS) Interview Questions and Answers - Part1
SQL Server Integration Services (SSIS) Interview Questions and Answers - Part2
SQL Server Integration Services (SSIS) Interview Questions and Answers - Part3

SQL Server Analysis Services (SSAS) Interview Questions and Answers - Part1
SQL Server Analysis Services (SSAS) Interview Questions and Answers - Part2
SQL Server Analysis Services (SSAS) Interview Questions and Answers - Part3

SQL Server Reporting Services (SSRS) Interview Questions and Answers - Part1
SQL Server Reporting Services (SSRS) Interview Questions and Answers - Part2
SQL Server Reporting Services (SSRS) Interview Questions and Answers - Part3

MDX Interview Questions and Answers - Part1

DWH Interview Questions and Answers

SQL Server Database Administrator (DBA) Interview Q & A - Part1
SQL Server Database Administrator (DBA) Interview Q & A - Part2

SQL Server Database Administrator (DBA) Interview Q & A - Part3

PPS Interview Questions and Answers

PowerPivot Interview Questions and Answers

Power BI Interview Questions and Answers

Power Query Interview Questions and Answers

Power Map Interview Questions and Answers

Share Point Interview Questions and Answers

DAX Interview Questions and Answers

MDX Concepts

MDX- Introduction
SQL Vs MDX
Various MDX Queries

MDX Functions
Ascendants
AVG
BottomCount
BottomPercent
BottomSum
Children
ClosingPeriod
Cousin
FirstChild
FirstSibling
Head
LastChild
LastSibling
LastPeriods
Lag
Lead
NextMember
OpeningPeriod
ParallelPeriod
Parent
PeriodsToDate
PrevMember
Siblings
Tail
TopCount
TopPercent
TopSum

SQL Server Concepts

SQL Server - Pre-Requisites

SQL Server - History (Evolution)
SQL Server - Introduction
SQL Server - Versions
SQL Server - Editions
Highlights of SQL Server by Version
SQL Server  - System Requirements
Database Overview
E-R-MODEL (Entity-Relational)
Table Relationships
SQL Server - System Databases
SQL Server - Commands
SQL Server - T-SQL Basics
SQL Server - Data types
SQL Server - DateTime Functions

SQL Server -  Types of Keys

SQL Server - SSMS (SQL Server Management Studio)

SQL Server - Create Statements
SQL Server - Alter Statement

SQL Server - CREATE, ALTER, DROP Statements

SQL Server - Clauses

SQL Server - Constraints
SQL Server - Normalization
SQL Server - How Data Stored
SQL Server - Import and Export Wizard
SQL Server - Operators
SQL Server - Set Operators
SQL Server - System Functions
SQL Server - Ranking Functions
SQL Server - IDENTITY Column
SQL Server - Computed Column
SQL Server - CASE Expression
SQL Server - CTE (Common Table Expression)
SQL Server - Alias Names
SQL Server - Logical Functions
SQL Server - Temporary Tables
SQL Server - Table Variables
SQL Server - Sub Queries
SQL Server - Backup and Restore
SQL Server - Synonyms
SQL Server - Joins
SQL Server - System Views
SQL Server - Views
SQL Server - Indexes
SQL Server - Stored Procedures
SQL Server - Cursors
SQL Server - Control Flow Language
SQL Server - Dynamic SQL
SQL Server - User - Defined Functions
SQL Server - Triggers
SQL Server - Data Integrity
SQL Server - ACID Properties
SQL Server - Transactions
SQL Server - Isolation Levels with Examples
SQL Server - Error Handling
SQL Server - CDC (Change Data Capture)
SQL Server - DBCC Commands
SQL Server - Defaults and Rules
SQL Server - Naming Conventions and Standards
SQL Server - Best Practices
SQL Server - Differences 
SQL Server - Replace Function



SQL Server - Interview Questions and Answers

Scenarios:


Working with NULL Values in SQL Server

What is the use of SETNOEXEC Statement in SQL ServerHow to Convert Tabular data into Comma separated string in SQL ServerTRIGGERS, TRIGGERS PERFORMANCE AND RULES FOR CREATING THE TRIGGERSNew Features in Microsoft SQL ServerConvert Seconds to Minutes, Hours and Days in SQL ServerImprove Error Handling using Throw Statement in SQL Server 2012

Sub Queries Vs Joins

A Beginner’s Guide to the OUTPUT Clause in SQL Server

11 Keyboard Shortcuts Every SQL Server Geek Should Know

Inner and Left Outer Join with Where Clause vs ON Clause

How to Fetch all Numeric Values from String

Run SSIS ETL From SQL Server

Solution for SQL Server Error “Saving Changes is Not Permitted”

Open Query in SQL Server

Tips to Improve SQL Server Query Performance

SQL Server performance tip - Do not use NOT IN clause in Subquery use LEFT OUTER JOIN instead

Select Text Columns or Boxes Vertically in Notepad++ and SQL Server 2012

View and Edit Two Files Side By Side in SQL Server and Notepad++

Display Line Numbers in SQL Server Query Editor WindowRestore SQL Server system database master.mdf without BackupHow Does SQL Server work & perform DML OperationNew features of Microsoft SQL Server 2012 : DenaliInsert default values for all columns in table - SQL ServerScript to get Database Files detail - SQL ServerHow to Enable ‘sa’ Login in SQL ServerSQL Server Authentication ModesHow to Set Backup Compression in SQL ServerIdentify Database Bottlenecks with Performance Monitor CountersRowcount for all tables in SQL Server DatabaseHow to get a total row count in faster waySQL Server - Full Text Search

Deterministic and Non-deterministic Functions in SQL Server

SQL Server - Index Fragmentation

SQL Server - Database Snapshot

SQL Server Parallel Data Warehouse

Encrypt Database with Transparent Data Encryption (TDE)

SQL Server 2012: Pagination with Order By and Offset Fetch

SQL Server 2014 Upgrade Advisor Prerequisites, Download and Installation

Error: 15517 – SQL Server could not disable publishing and distribution on ‘YourDBName’

Is_ms_shipped Property in SQL Server

SSRS Concepts

SSRS (SQL Server Reporting Services)
SSRS Architecture
Report Server Project
Report Model Project
Report Builder
Data Source
    Embedded Data Source
    Shared Data Source
Data Set
    Embedded Data Set
    Shared Data Set
    Filters at Data set Level
Data Regions
RDL (Report Definition Language)
My First SSRS Report
Report Server Project Wizard
Report Server Project Wizard1
Create a Report using Wizard
Custom Report Template in SSRS
SSRS Query Designer
              Tabular Report
              Matrix Report
                     Filters at Tablix Report
                     Filter at Tablix Level
              Chart Report
                      Bar Chart
                      Pie Chart
                      Drill-Down Chart
                      Column Chart
              Text box
              Image Report
              Line
              List
              Rectangle
             Gauge Report
             Map Report
                  Document Map Report
             Data Bar
             Spark line
             Indicator
Types of Reports:
              Drilldown Report
              DrillThrough
                    Go To URL Action
              Sub Report
Tabbed Report
Parameterized Reports
           Parameters in Report
           Report Parameters
           Multiple Parameters
           Drop-Down List Parameters
           Cascading Parameters
           Multi-Value Parameter
Grouping in Report
Grouping in SSRS Report
Row Grouping
Sorting in SSRS
Sort the data at Tablix
Interactive Sorting in Report
Interactive Sorting
Page Header and Page Footer
Built-In-Functions
Commonly used functions
Linked Report
Caching
Snapshot
Subscriptions
      Standard Subscriptions
      Data-Driven Subscriptions
Roles
Security




Scenario Based:

Installations:

Install SSRS Report Builder 3.0

Development:

How to show tablix inside the tablix
Creating Calculate field in SSRS
Create a report with Excel as Source
Create a report with Excel as Source1
Create a report with Excel as Source2
Conditionally Setting column visibility in SSRS
Keep Headers Visible while scrolling
Repeat Table Header on Each page in SSRS
Repeat Table Header on Each page in SSRS1
Repeat Headers each page
Format Numbers in SSRS
Format Fonts and Background Color of a Textbox in SSRSSet an alternative color in Report
Display a fixed number of rows per page for an SSRS reportCreate a parameterized report in SSRS
Create a report using Expressions in SSRS

SSRS - How to add input parameters in the report

Creating a multi-option parameter report for SQL Server Reporting Services

Include Report Parameter Selection Values in Report Output for SQL Server Reporting Services

How to use a multi valued comma delimited input parameter for an SSRS report

Allow NULL value in Multi Value Report Parameter in SQL Server Reporting Services

Set Select All as Default for Multi-Value Report Parameters in SQL Server Reporting Services

SQL Server Reporting Services Text Box Orientation

SSRS- How to set Text Box Orientation in the report

SQL Server Reporting Services Reports With Optional Query Parameters

Lookup - How to use multiple datasets in a tablix

Passing Parameters to SSRS Report using URL

Representation of Geographical Information using SSRS 2008 R2

Calendar Date Picker for MDX based Reports in SSRS

How to change Rendering Extensions in SQL Server Reporting Services ?

Email Configuration in SSRS with SMTP in Windows Server 2008R2

Export SQL Server Reporting Services Report Data into Multiple Excel with Worksheets

Implementing Page Break while exporting bulk data to Excel 2003

How to resolve the sorting issue with exported excel report by replacing report header with column header

Deployment:

Deploy SSRS Report Server Project

Report Manager:

User Domain\User does not have required permissions.

SSRS- How to create Shared Schedule and how to utilize it

Report Services Configure Manager:

SQL Server 2008 Reporting Service Configuration

SQL Server Reporting Services - Interview Questions and Answers

Execute a SQL Server Reporting Services report from Integration Services Package

SSRS Reporting Services IE Issues
Back Up of SSRS Reports using RS Utility

Create Custom Report Viewer Using the WebBrowser Control in Windows ApplicationUse Report Viewer Control to View SSRS Report in Windows Application
Export SSRS Report into PDF Format from ASP.NET Application

Why ReportViewer Control not working on IIS 7?

WCF Service as DataSource in SSRS

WebService as DataSource in SSRS

Call SSRS Report With Prameters from ASP.NET Web Application

Call SSRS Report From ASP.NET              

SSAS Concepts

SSAS (SQL Server Analysis Services)OLAP (Online Analysis Processing)
UDM (Unified Defined Model)
BISM (BI Semantic Model)
Data Source
       Impersonation Information
Data Source View
         Named Query
         Named Calculation
          Logical Keys
          Add or Remove Tables
          Refresh
Dimension
          Hierarchy
          Attribute Relationships
         AttributeAllMemberName
         Unknown Member
         UnKnownMemberName
         AttributeHierarchyEnabled
         AttributeHierarchyVisible
         DefaultMember
         IsAggregatable (Property)
         Type (Property)
         Usage (Property)
         Name Column
         Value Column
         Key Column
         Order By
         OrderByAttribute
         FormatString
Cube
Measure Groups
       IgnoreUnrelatedDimensions
       ProcessingMode
Proactive Caching
Storage Modes
          MOLAP
          ROLAP
          HOLAP
Tabs:
    Cube Structure
    Dimension Usage
             Relationships
   Calculations
            Calculated Measure
            Named Set
  KPI
 Actions

    Custom Drill Through Action

 Partitions
 Aggregations
 Perspectives
 Translations
 Browser
Processing Options:
Deployment:  

      Transaction Deployment
Roles:
Assemblies

Scenarios:

Creation of cube top-down

Message group has zero dimensional overlap

SSIS Concepts

What is SQL Server Integration Services (SSIS) ?
SSIS Project Architecture ?
What are the main components of SSIS Project Architecture ?
Control Flow:
         Connection managers         Variables
          Parameters
          Package Configurations
                 XML Configuration
                 Environment Variable Configuration
                 Parent Package Configuration
                 Registry Entries
                 SQL Server Configurations
          Annotations
          Package Configurations
          Work Offline
          Logging
          Log Events
         Check Points
         Break Points
         Transactions
         SSIS Toolbox:
                      Favorites:
                             Dataflow Task
                             Execute SQL Task
                     Containers:
                             For Loop Container
                             Foreach Loop Container
                             Sequence Container
                             Task Host Container
                     Common:
                              Analysis Services Processing Task
                              Bulk Insert Task
                              Data Profiling Task
                              Execute Process Task
                              Execute Package Task
                              Expression Task
                              File System Task
                              FTP Task
                              Script Task
                              Send Mail Task
                              Web Service Task
                              XML Task
                   Other Tasks:
                              Analysis Services Execute DDL Task
                              Backup Database Task
                              CDC Control Task
                              Check Database Integrity Task
                              Data Mining Query Task
                              Execute SQL Server Agent Job Task
                              Execute T-SQL Statement Task
                              History Cleanup Task
                              Maintenance Cleanup Task
                              Message Queue Task
                              Notify Operator Task
                              Rebuild Index Task
                              Reorganize Index Task
                              Shrink Database Task
                              Transfer Database Task
                              Transfer Error Message Task
                              Transfer Jobs Task
                              Transfer Logins Task
                              Transfer Master Stored Procedure Task
                              Transfer SQL Server Objects Task
                              Update Statistics Task
                              WMI Data Reader Task
                              WMI Event Watcher Task
                 Control flow Properties:
                               Package Level Properties:
               
                                              Delay Validation:
                                              Propogate Property:
                                              RetainsameConnection Property:
                                              DisableEventHandler Property:
                                              Checkpoint FileName
                                              CheckPoint Usage:
                                              Configurations
                                               FailParentOnFailure
                                               IsolationLevel:
                                               LoogingMode:
                                               MaxConcurrentExecutables
                                               MaximumErrorCount
                                               PackagePassword
                                               ProtectionLevel
                                               SaveCheckPoints
                                               TransactionOption
                                Task level Properties:
                                         Data Flow Task Properties:
                                                     DefaultBufferMaxRows
                                                     DefaultBufferSize
                                                     DelayValidation
                                                     DisableEventHandlers
                                                     EngineThreads
                                                     FailPackageOnFailure
                                                     FailParentOnFailure
                                                     LoogingMode:
                                                     MaximumErrorCount
                                                     TransactionOption
                              Solution Explorere Properties:
                                        Solution File Properties:
                                                     Deploy:
                                                     Build:
                                                     Rebuild:
                                                     Convert to Package Deployment Model
                                               Configuration Properties:
                                                      Debugging:
                                                               Data Flow Optimizations:
                                                                          RunInOptimizedMode:
                                                               Debug Options:
                                                                          InteractiveMode
                                                                          Run64bitRuntime
                            Project Parameters
                            Connection Managers (Project Level)
                             SSIS Package Folder Properties:
                                             New SSIS Package
                                             SSIS Import and Export Wizard
                                             Convert Deployment Model
                                             Upgrade All Packages
                                             Add Existing Package
                                             Sort by Name
                            Miscellaneous
Data Flow:
            Favorites:
                  Source Assistant:
                 
                  Destination Assistant:
Parameters:
Event Handlers:
        Executables:
        Event Handler:
              OnError
              OnExecStatusChanged
              OnInformation
              OnPostExecute
              OnPostValidate
              OnPreExecute
              OnPreValidate
              OnProgress
              OnQueryCancel
              OnTaskFailed
              OnVariableValueChanged
              OnWarning
Package Explorer:
Execution Results:
Deployment:
Common Errors: