Microsoft BI Stack
1
What is the default port number for SQL Server?
8080
443
1433
1521
2
Which tool in the Microsoft BI stack is primarily used for building ETL processes?
Power BI
SSIS
SSRS
Excel
3
In SSIS, which of the following is used to connect to data sources like SQL Server?
Data Flow Task
Connection Manager
Control Flow Task
Package Explorer
4
Which language is used to write queries in SQL Server?
HTML
DAX
MDX
T-SQL
5
What is the primary use of SQL Server Reporting Services (SSRS)?
Data storage
Data mining
Report generation
Data transformation
6
Which component of SQL Server allows for data warehousing and data analysis?
SSAS
SSIS
SSRS
Power BI
7
In Power BI, what is a 'dashboard'?
A set of data sources
A collection of reports
A visual display of key metrics
A single chart
8
Which file format is used to store SSIS packages?
.dtsx
.rdl
.mdx
.pbix
9
In SSRS, which tool is used to design and deploy reports?
SQL Server Management Studio (SSMS)
SQL Server Data Tools (SSDT)
Power BI Desktop
Visual Studio Code
10
What is the main purpose of a data warehouse in a BI system?
To execute transactions quickly
To store historical data for analysis
To manage database users
To generate real-time reports
11
Which SSIS task is used to load data into a SQL Server table?
Execute SQL Task
Data Flow Task
Control Flow Task
Script Task
12
In SSAS, what is the role of a dimension?
To aggregate data
To filter data
To organize data by different perspectives
To store calculated measures