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?
A
The Navigator window
B
The Fields paneCorrect Answer
C
The Overview tab
QUESTION 2 OF 23
Which data sources can Power BI connect to?
A
Local, cloud, and SaaS sourcesCorrect Answer
B
Only local sources
C
Only SaaS sources
QUESTION 3 OF 23
How should you optimize data ranges in an Excel workbook for better visualization in Power BI?
A
Leave them as simple worksheets.
B
Format them as tables.Correct Answer
C
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?
A
Power BI connects to many external apps and cloud services.Correct Answer
B
Power BI connectors are limited to local computers or personal accounts.
C
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?
A
Select the correct option.
B
Update the connection string.Correct Answer
C
Create a new connection string and leave the old one unchanged.
D
Clear permissions.
QUESTION 6 OF 23
What is the difference between a dataset and a data source in Power BI?
A
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
B
A dataset is the same as a data source, but with fewer features.
C
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.
A
TrueCorrect Answer
B
False
QUESTION 8 OF 23
What are the types of workbooks that Power BI supports? Select all that apply:
A
Workbooks with ranges or tables of data.Correct Answer
B
Workbooks with connections to external data sources.Correct Answer
C
Workbooks with shapes and images
D
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?
A
100 GB
B
10 GB
C
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.
A
TrueCorrect Answer
B
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
A model cannot change from Import to Direct Query mode.Correct Answer
B
A model can easily be switched from Import to Direct Query mode.
C
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?
A
To determine how visuals access back-end data sources.Correct Answer
B
To establish many-to-many relationships between tables.
C
To import data to Power BI.
QUESTION 13 OF 23
How should your data look before loading it into Power BI?
A
Each column contains different data types.
B
The table should display columns and rows that show totals.
C
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?
A
Validating that the check box Send refresh failure notification is marked.Correct Answer
B
Setting the correct time zone.
C
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.
A
Get Data window
B
Time zone window
C
Scheduled refresh windowCorrect Answer
QUESTION 16 OF 23
What is the benefit of understanding the difference between structured and unstructured data?
A
Understanding the difference can define the correct storage solution and the best kind of analysis needed.Correct Answer
B
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?
A
The type of data source and the data’s business requirements.Correct Answer
B
The size of the data source and the file format.
C
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?
A
Select the Schedule Refresh button under the Refresh menu.
B
Navigate to the Datasets + Dataflows tab in your workspace.Correct Answer
C
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?
A
Azure Blob Storage is a scalable and cost-effective Cloud Storage Service, suitable for storing large amounts of unstructured data.Correct Answer
B
Azure Blob Storage automatically converts unstructured data into structured data for easier analysis.
C
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?
A
To select the data tables to import into Power BI.
B
To change the connection details and credentials for the data source.Correct Answer
C
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?
A
Financial business data that is structured for year-to-year comparison and is mainly read-only.Correct Answer
B
Customer feedback in the form of audio files.
C
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.
A
True
B
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?
A
To automatically email the latest sales report to the management team at specified intervals.
B
To ensure that sales report datasets are regularly updated without manual intervention, improving data accuracy and workflow efficiency.Correct Answer
C
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?