microsoft pl-300 exam preparation and practice coursera week 2 answers
Self-review: What did you learn?
1. You are formatting the column properties of your data tables within your data model. In which section of Properties can you change the data type of the column?
- Advanced
- Formatting
- General
3. True or False: The DAX CALENDAR function automatically detects the data range of your dataset and creates a calculated date column.
- True
- False
4. Which of the following components of Microsoft Power BI allow you to add a description about your table? Select all that apply.
- Data view
- Power Query Editor
- Model view
- Report view
5. True or False: If your data model does not contain a date table, you will not be able to perform time intelligence calculations using DAX.
- True
- False
6. Which language can you use to create a common date table in Microsoft Power BI? Select all that apply.
- Python
- DAX
- M
- C++
7. Adventure Works' US sales manager wants insights into the sales of a few states, and she asked you to present the sales and profit for California and Arizona only. What DAX functions can you use to compute the measures? Select all that apply.
- SUM
- CALCULATE
- SUMX
- FILTER
8. The profit margin is an example of a/an _____________ measure.
- Non-additive
- Additive
- Semi-additive
9. You are handling a semi-additive measure in Microsoft Power BI. What DAX functions are useful in managing a semi-additive measure? Select all that apply.
- LASTNONBLANK
- FIRSTDATE
- DATEADD
- CALCULATE
10. Adventure Works wants a visualization displaying the opening balance of its products in stock for each month. Which DAX function is most suitable to use in computing your measure?
- LASTDATE
- FIRSTNONBLANK
- FIRSTDATE
11. True or False: In Microsoft Power BI, you do not need to write DAX script to visualize implicit measures on the report canvas.
- True
- False
12. What is the maximum number of levels you can create in a hierarchy in Microsoft Power BI?
- 5
- 4
- 3
13. How can you create a data hierarchy in Microsoft Power BI? Select all that apply.
- By adding fields to the visual axis well
- By using the Power Query editor
- Creating a new hierarchy and adding fields to the hierarchy
- By using DAX
14. True or False: In Microsoft Power BI, you can only create calculated tables using DAX.
- True
- False
15. Microsoft Power BI’s Q&A visual lets users ask user-defined questions about the data. To help them swiftly analyze information and draw insights, what features of the Q&A visual can you configure? Select all that apply.
- Visual formatting
- Synonyms
- Teach Q&A
- Relationships
16. True or False: When you write your question in the Q&A visual text box, Microsoft Power BI provides you with autocomplete suggestions. Can you modify the suggestions that appear in the Q&A visual?
- True
- False
17. In addition to using DAX to create calculated tables, what is an alternative way to create calculated tables without using any external tool?
- M language
- SQL
- Python
18. You have Sales and Cost columns in your data table. The data type of the columns is set to Text. Which Microsoft Power BI element allows you to update the data types of the columns to Currency? Select all that apply.
- Report view
- Query Editor
- Model view
- Data view
19. How does the Performance Analyzer assist in analyzing user interactions in Microsoft Power BI reports?
- By capturing the impact of user interactions on report elements.
- By recommending the alteration in data refresh frequency.
- By suggesting a better visual to use in the report.
20. What is the primary benefit of correctly categorizing the location-based columns of your data model in Microsoft Power BI?
- To enhance the visual appearance of map visuals
- To eliminate data redundancy
- To enable accurate geographical analysis and mapping
