MCQs on Getting Started with Data Sources | Power BI
Dive into essential Power BI concepts with these 30 multiple-choice questions covering connecting to data sources, import vs. direct query modes, and data models/relationships. Perfect for beginners and experts.
Connecting to Data Sources (Excel, CSV, Databases, Online Services)
- Which of the following is a supported data source in Power BI?
- a) Excel
- b) SQL Server
- c) Online Services
- d) All of the above
- In Power BI, what tool is used to establish a connection to a database?
- a) Power Query
- b) Power Pivot
- c) Data Gateway
- d) Visual Studio
- Which file formats are directly supported for import into Power BI?
- a) Excel and CSV
- b) JSON and XML
- c) PDF
- d) All of the above
- What is required to connect Power BI to an online service like Google Analytics?
- a) API Key
- b) Microsoft Azure Subscription
- c) Direct Database Link
- d) SQL Connector
- How can you connect to an Excel workbook stored in OneDrive using Power BI?
- a) Use the Get Data > Web option
- b) Download and import the file
- c) Connect via the OneDrive connector
- d) All of the above
- What is the main purpose of Power BI’s Data Gateway?
- a) To extract and clean data
- b) To enable cloud-based access to on-premises data
- c) To visualize datasets in real time
- d) To create relationships between tables
- Which of the following is NOT a step in connecting Power BI to a SQL Server database?
- a) Specifying the server name
- b) Entering authentication credentials
- c) Configuring visual filters
- d) Selecting tables or views to load
- Which connector should you use to import a CSV file from a local machine into Power BI?
- a) File
- b) Database
- c) Web
- d) Online Services
- What role does Power Query play in connecting to data sources in Power BI?
- a) Allows users to transform and shape data during connection
- b) Builds reports and dashboards
- c) Sets up relationships between tables
- d) Configures visual styles
- Which of the following online services is natively integrated with Power BI for data connections?
- a) Google Sheets
- b) Azure Synapse Analytics
- c) Salesforce
- d) Both b and c
Data Import vs. Direct Query
- What is the primary advantage of using Direct Query mode in Power BI?
- a) Real-time data updates
- b) Improved performance for large datasets
- c) Reduced reliance on network connections
- d) Availability of all DAX functions
- Which mode stores a copy of the data in Power BI?
- a) Direct Query
- b) Import Mode
- c) Composite Mode
- d) Real-Time Mode
- In Direct Query mode, where is the data processing primarily performed?
- a) In Power BI Desktop
- b) In the data source
- c) In the Power BI service
- d) In the Power BI dataset
- Which of the following features is unavailable in Direct Query mode?
- a) Custom measures using DAX
- b) Scheduled refreshes
- c) Calculated columns
- d) Real-time dashboards
- What is a limitation of Import Mode in Power BI?
- a) It requires frequent manual updates
- b) It cannot handle large datasets
- c) It doesn’t allow real-time reporting
- d) It depends on the data gateway
- Which Power BI storage mode combines Import and Direct Query features?
- a) Hybrid Mode
- b) Composite Mode
- c) Mixed Mode
- d) Advanced Mode
- What happens when you switch from Direct Query to Import Mode?
- a) Data is cached in the Power BI file
- b) All connections are lost
- c) Reports are updated in real-time
- d) Visual filters are disabled
- In which mode are Power BI dashboards updated based on live queries to the source database?
- a) Import Mode
- b) Direct Query Mode
- c) Real-Time Mode
- d) Hybrid Mode
- How does Direct Query mode impact data source performance?
- a) It improves performance for large datasets
- b) It can put additional load on the source database
- c) It prevents large queries from executing
- d) It requires fewer resources from the data source
- Which mode allows Power BI users to leverage pre-aggregated data from a source system?
- a) Import Mode
- b) Direct Query Mode
- c) Composite Mode
- d) All of the above
Understanding Data Models and Relationships
- What does a “one-to-many” relationship mean in Power BI?
- a) A single row in one table relates to multiple rows in another table
- b) Multiple rows in one table relate to a single row in another table
- c) A single row relates only to itself
- d) None of the above
- What is the default relationship cardinality created by Power BI when linking two tables?
- a) Many-to-Many
- b) One-to-One
- c) One-to-Many
- d) None
- How can you define relationships manually in Power BI?
- a) Using the Relationships view
- b) Using DAX expressions
- c) By merging queries in Power Query
- d) All of the above
- What is the purpose of a “lookup table” in Power BI models?
- a) To store summary data
- b) To act as a source for relationships
- c) To combine data from multiple sources
- d) To filter visualizations
- What happens when a circular relationship is detected in Power BI?
- a) Power BI automatically removes the relationship
- b) Power BI prevents the model from being saved
- c) Power BI allows the relationship but disables calculated columns
- d) Power BI reports the issue but permits saving
- Which of the following is true about inactive relationships in Power BI?
- a) They can be used in DAX calculations with the USERELATIONSHIP function
- b) They are automatically deleted by Power BI
- c) They cannot be used in reports
- d) They are always replaced by active relationships
- What role does the “Primary Key” field play in creating relationships in Power BI?
- a) It serves as a unique identifier for connecting tables
- b) It aggregates data for visualizations
- c) It eliminates the need for table joins
- d) None of the above
- Which of the following relationship types allows bi-directional filtering in Power BI?
- a) One-to-Many
- b) Many-to-Many
- c) One-to-One
- d) All of the above
- What tool in Power BI helps identify and visualize table relationships?
- a) Model View
- b) Data View
- c) Report View
- d) Query Editor
- Which of the following is true about hierarchical data models in Power BI?
- a) They support parent-child relationships
- b) They are only available in Direct Query mode
- c) They prevent drill-down capabilities
- d) They cannot handle large datasets
Here is the answer key for the 30 MCQs on Power BI topics:
| Qno | Answer (Option with Text) |
|---|---|
| 1 | d) All of the above |
| 2 | a) Power Query |
| 3 | d) All of the above |
| 4 | a) API Key |
| 5 | c) Connect via the OneDrive connector |
| 6 | b) To enable cloud-based access to on-premises data |
| 7 | c) Configuring visual filters |
| 8 | a) File |
| 9 | a) Allows users to transform and shape data during connection |
| 10 | d) Both b and c |
| 11 | a) Real-time data updates |
| 12 | b) Import Mode |
| 13 | b) In the data source |
| 14 | c) Calculated columns |
| 15 | c) It doesn’t allow real-time reporting |
| 16 | b) Composite Mode |
| 17 | a) Data is cached in the Power BI file |
| 18 | b) Direct Query Mode |
| 19 | b) It can put additional load on the source database |
| 20 | c) Composite Mode |
| 21 | a) A single row in one table relates to multiple rows in another table |
| 22 | c) One-to-Many |
| 23 | a) Using the Relationships view |
| 24 | b) To act as a source for relationships |
| 25 | b) Power BI prevents the model from being saved |
| 26 | a) They can be used in DAX calculations with the USERELATIONSHIP function |
| 27 | a) It serves as a unique identifier for connecting tables |
| 28 | d) All of the above |
| 29 | a) Model View |
| 30 | a) They support parent-child relationships |