Coursera Microsoft Power BI Data Analyst • STUDY MODE

Practice Quiz

QUESTION 1 OF 23

Which window should you use to select and load tables from an Excel workbook in Power BI Desktop?

The Navigator window

The Fields paneCorrect Answer

The Overview tab

QUESTION 2 OF 23

Which data sources can Power BI connect to?

Local, cloud, and SaaS sourcesCorrect Answer

Only local sources

Only SaaS sources

QUESTION 3 OF 23

How should you optimize data ranges in an Excel workbook for better visualization in Power BI?

Leave them as simple worksheets.

Format them as tables.Correct Answer

Convert them into charts.

QUESTION 4 OF 23

You are setting up Power BI connectors for Adventure Works. What kind of services can the company use PowerBI to connect to?

Power BI connects to many external apps and cloud services.Correct Answer

Power BI connectors are limited to local computers or personal accounts.

Power BI connectors only link to Microsoft services

QUESTION 5 OF 23

What should you do if you need to change the location of your source file in Power BI? 

Select the correct option.

Update the connection string.Correct Answer

Create a new connection string and leave the old one unchanged.

Clear permissions.

QUESTION 6 OF 23

What is the difference between a dataset and a data source in Power BI?

A dataset is a container that holds some of the data from a data source, whereas a data source is where the data actually comes from.Correct Answer

A dataset is the same as a data source, but with fewer features.

A dataset and data source are the same thing.

QUESTION 7 OF 23

True or False: You can create data sets that are reusable across multiple reports using basic data sources, which saves you the time and effort of having to import the same data repeatedly for each report.

TrueCorrect Answer

False

QUESTION 8 OF 23

What are the types of workbooks that Power BI supports? Select all that apply:

Workbooks with ranges or tables of data.Correct Answer

Workbooks with connections to external data sources.Correct Answer

Workbooks with shapes and images

Workbooks with data models.Correct Answer

QUESTION 9 OF 23

What is the maximum size of an Excel workbook that can be uploaded to Power BI? 

100 GB

10 GB

1 GBCorrect Answer

QUESTION 10 OF 23

True or False: When using DirectQuery in Power BI, there is a limit on the number of rows that can be returned to your underlying data source.

TrueCorrect Answer

False

QUESTION 11 OF 23

Adventure Works asks you if it can change its Power BI model from Import Mode to Direct Query mode once the initial storage mode has been created. How should you respond?

A model cannot change from Import to Direct Query mode.Correct Answer

A model can easily be switched from Import to Direct Query mode.

A model can only be changed within the latest version of Power BI.

QUESTION 12 OF 23

Why would you, as a data analyst, configure Adventure Works’ storage modes in Power BI?

To determine how visuals access back-end data sources.Correct Answer

To establish many-to-many relationships between tables.

To import data to Power BI.

QUESTION 13 OF 23

How should your data look before loading it into Power BI?

Each column contains different data types.

The table should display columns and rows that show totals.

Each column contains the same data type and the table should have a header row.Correct Answer

QUESTION 14 OF 23

How can you validate that notifications of failure refreshes will be sent to the dataset owner?

Validating that the check box Send refresh failure notification is marked.Correct Answer

Setting the correct time zone.

Specifying the email address of the dataset owner.

QUESTION 15 OF 23

To ensure the scheduled refresh will start at 10 PM every night, you should check the __________________ window.

Get Data window

Time zone window

Scheduled refresh windowCorrect Answer

QUESTION 16 OF 23

What is the benefit of understanding the difference between structured and unstructured data?

Understanding the difference can define the correct storage solution and the best kind of analysis needed.Correct Answer

Understanding the difference can enhancing data quality and reduce data processing time.

QUESTION 17 OF 23

What two main factors do you need to consider when determining the appropriate data connector for Power BI?

The type of data source and the data’s business requirements.Correct Answer

The size of the data source and the file format.

The level of security and the financial cost of the connector.

QUESTION 18 OF 23

What is the first step to set up an online refresh schedule in Power BI services?

Select the Schedule Refresh button under the Refresh menu.

Navigate to the Datasets + Dataflows tab in your workspace.Correct Answer

Modify the schedule in the Schedule Refresh pane. 

QUESTION 19 OF 23

What makes Azure Blob Storage an ideal option for storing unstructured data, such as photos and videos, for Adventure Works’ online retail website?

Azure Blob Storage is a scalable and cost-effective Cloud Storage Service, suitable for storing large amounts of unstructured data.Correct Answer

Azure Blob Storage automatically converts unstructured data into structured data for easier analysis.

Azure Blob Storage offers structured query language (SQL) support for complex queries.

QUESTION 20 OF 23

What is the purpose of the Data Source Settings option in Power BI?

To select the data tables to import into Power BI.

To change the connection details and credentials for the data source.Correct Answer

To specify the location of the data source file.

QUESTION 21 OF 23

Considering the data classification at Adventure Works for their online retail website, which type of data is most appropriately stored and queried using a SQL database? 

Financial business data that is structured for year-to-year comparison and is mainly read-only.Correct Answer

Customer feedback in the form of audio files.

Product images and video files used on the website.

QUESTION 22 OF 23

True or False: In Power BI, triggers and actions are used primarily for visualizing data, enabling data analysts to create more complex and interactive reports.

True

FalseCorrect Answer

QUESTION 23 OF 23

What is the primary purpose of setting up a scheduled data refresh in Power BI for a data analyst team?

To automatically email the latest sales report to the management team at specified intervals.

To ensure that sales report datasets are regularly updated without manual intervention, improving data accuracy and workflow efficiency.Correct Answer

To convert sales data from unstructured to structured formats for more straightforward analysis.

Ready to test your recall?

Which window should you use to select and load tables from an Excel workbook in Power BI Desktop?

The Navigator window

The Fields pane

The Overview tab

How confident are you in this answer?

Practice Quiz

Which window should you use to select and load tables from an Excel workbook in Power BI Desktop?

Which data sources can Power BI connect to?

How should you optimize data ranges in an Excel workbook for better visualization in Power BI?

You are setting up Power BI connectors for Adventure Works. What kind of services can the company use PowerBI to connect to?

What should you do if you need to change the location of your source file in Power BI?&nbsp;

What is the difference between a dataset and a data source in Power BI?

True or False: You can create data sets that are reusable across multiple reports using basic data sources, which saves you the time and effort of having to import the same data repeatedly for each report.

What are the types of workbooks that Power BI supports? Select all that apply:

What is the maximum size of an Excel workbook that can be uploaded to Power BI?&nbsp;

True or False: When using DirectQuery in Power BI, there is a limit on the number of rows that can be returned to your underlying data source.

Adventure Works asks you if it can change its Power BI model from Import Mode to Direct Query mode once the initial storage mode has been created. How should you respond?

Why would you, as a data analyst, configure Adventure Works’ storage modes in Power BI?

How should your data look before loading it into Power BI?

How can you validate that notifications of failure refreshes will be sent to the dataset owner?

To ensure the scheduled refresh will start at 10 PM every night, you should check the __________________ window.

What is the benefit of understanding the difference between structured and unstructured data?

What two main factors do you need to consider when determining the appropriate data connector for Power BI?

What is the first step to set up an online refresh schedule in Power BI services?

What makes Azure Blob Storage an ideal option for storing unstructured data, such as photos and videos, for Adventure Works&#8217; online retail website?

What is the purpose of the Data Source Settings option in Power BI?

Considering the data classification at Adventure Works for their online retail website, which type of data is most appropriately stored and queried using a SQL database?&nbsp;

True or False: In Power BI, triggers and actions are used primarily for visualizing data, enabling data analysts to create more complex and interactive reports.

What is the primary purpose of setting up a scheduled data refresh in Power BI for a data analyst team?

Ready to test your recall?

What should you do if you need to change the location of your source file in Power BI?

What is the maximum size of an Excel workbook that can be uploaded to Power BI?

What makes Azure Blob Storage an ideal option for storing unstructured data, such as photos and videos, for Adventure Works’ online retail website?

Considering the data classification at Adventure Works for their online retail website, which type of data is most appropriately stored and queried using a SQL database?