Power BI

Which of the following best describes Power BI’s data connectivity capabilities?

• Limited to Excel files only
  
  

• Can connect to a wide range of data sources, including cloud-based services and databases

• Can only connect to on-premises data sources

• Only supports data connections from Microsoft Access

What is Power Query Editor used for in Power BI?

• Creating and managing data models

• Designing and formatting reports

• Data transformation and preparation

• Defining security settings for reports

How can users share their Power BI reports and dashboards with others?

• By exporting them to PDF or Excel format
  
  

• By printing them and distributing physical copies
  
  

• By sharing links to the reports or dashboards through the Power BI service

• By sending the PBIX file via email

What is the purpose of using Power BI Mobile App?

• To access and interact with reports and dashboards on a mobile device
  
  

• To edit and design reports on a mobile device

• To play games and watch videos on a mobile device

• To send emails and make phone calls

What is the benefit of using Power BI Desktop?

• It allows users to access reports and dashboards from any device
  
  

• It is a cloud-based version of Power BI
  
  

• It enables users to create and design reports locally before publishing them to the Power BI service

• It allows direct connection to on-premises data sources without cloud services

What is the purpose of using Power BI gateways?

• To block unauthorized access to reports and dashboards

• To enable secure data transfer between on-premises data sources and the Power BI service

• To schedule data refreshes in Power BI

• To create backups of Power BI content

Which of the following is a type of Power BI content pack?

• A collection of custom visuals
  
  

• A collection of reports and dashboards bundled for specific data sources or services
  
  

• A collection of connections to data sources
  
  

• A collection of datasets

You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?

• Microsoft Teams Personal Analytics

• SQL Server database

• Dataverse

• Dataflows

You have a Microsoft SharePoint Online site that contains several document libraries.
One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure.
You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis.
What should you do?

•  Get data from a SharePoint folder and enter the site URL Select Transform, then filter by the folder path to the manufacturing reports library.

• Get data from a SharePoint list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

• Get data from a SharePoint folder, enter the site URL, and then select Combine & Load.

•   Get data from a SharePoint list, enter the site URL, and then select Combine & Load.

You have a Microsoft Excel file in a Microsoft OneDrive folder.
The file must be imported to a Power BI dataset.
You need to ensure that the dataset can be refreshed in powerbi.com.
Which two connectors can you use to connect to the file? Each correct answer presents a complete solution

A. Excel Workbook

B. Text/csv

C. Folder

D. Sharepoint Folder

E. Web

• A and C

• C and D

• D and E

• None