Data Loading & Visualization in Power BI: Loading Data from Databases

 

Question:

This is a pie chart visualizing the $ amount earned from sales in different segments of a superstore’s products. Please match the segments to the % of sales they contribute.

• Home office - 18.27%
• Corporate - 30.25%
• Consumer - 51.48%

Question:

When connecting to a remote MySQL server from Power BI using the MySQL connector, which details should you be cognizant about?

• That the version of MySQL and MySQL connector match

• That the MySQL connector is installed on the machine where Power BI is running

Question

:

Identify the benefits of reading data into Power BI from SQL Server with the Import method.

• You do not require an internet connection to work with data

• Your visualizations will be extremely performant

Question

:

This is a treemap visualizing the sales of each country and category for a superstore. Based on this chart, which country has the highest sales in the furniture category?

• United States

Question

:

There are 3 ways to authenticate yourself when connecting from Power BI to SharePoint. Please match the method to the statement which best describes it.

• Anonymous - 

  No authentication i.e., someone who is logged out can access data
• Windows - Authentication using valid Windows credentials accepted by that SharePoint site
• Microsoft account - Authentication using the account to which the data is uploaded to SharePoint

Question

:

When loading data from SQL Server into Power BI, there are two ways to go about it. Please match the method of loading data to the statements that are applicable to that method.

• This method is ideal for very large data - 

  DirectQuery

• The data is accessed directly from the data source and not loaded into Power BI - 

  DirectQuery

• This method is ideal for fairly small data - 

  Import

• The data is loaded into the .pbix file so analysis is very fast - 

  Import

Question

:

You have connected to MySQL from Power BI - however you would like to modify the credentials you use. How can you do this?

• You click through File >> Options and Settings >> Data Source Settings >> <your database> >> Edit Permissions

Question

:

These are four visualizations labeled A, B, C, and D. Of these charts, which one is an example of an area chart?

• D

Question

:

Identify the benefits of reading data into Power BI from SQL Server with the DirectQuery method.

• If your data is very large, it will not slow down your performance

• Your data will update based on the changes in the source

Categories: Power BI