Power Bi 300 Exam Questions and Answers 2023 Graded
A+
What is a risk of having null values in a numeric column?
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect.
That function AVERAGE of data will be incorrect.
If you have two queries that have different data but the same column headers,
and you want to combine both tables into one query with all the combined rows,
which operation should you perform?
Append
Merge
Combine Column
Append
Which of the following selections are not best practices for naming conventions
in Power BI?
Rename columns to have spaces in them.
Abbreviate column names.
Replace values that have integers with human readable results.
Check your answers
Abbreviate column names.
Your social media engagement officer has requested your help in boosting
followers and retweets on Twitter. How could you help her get more information
to better understand and subsequently increase engagement?A. Power Apps
portals can create a new customer site for our followersB. Power Automate can
handle our content approvals for us, reducing the time it takes to produce new
content and ensure our quality procedure is followedC. Configure a Power BI
report to capture and analyze data from Twitter, allowing you to better understand
why certain posts elicit more responses
Which of the below is a way in which Power BI can help you effectively leverage
your data?
Analyze sales data to better allocate resources and place orders, optimizing
operations.
Analyze customer data to better target and promote specific items to specific
customers.
All of the above.
All of the above.
What are the three modalities of Power BI designed to let people create, share,
and consume business insights in the way that serves them, or their role, most
effectively?
, Desktop, service, and Mobile apps.
Tiles, visualizations, and dashboards.
Reports, dashboards, and tiles.
Desktop, service, and Mobile apps.
How can you get Power BI to spot outliers and trends in your data?
Use the Spotlight feature
Export data to Microsoft Excel
Use Quick insights
Use Custom Q&A
Use Quick insights
How could you gather, arrange, and share interesting Power BI visuals from
several different sources?
Pin them to a Power BI report
Pin them to a Power BI dashboard
Export them to PDF
Use the Get Data feature
Pin them to a Power BI dashboard
If you think of some interesting questions to ask in your report, how could you
share them to help your Q&A users?
Use the Spotlight feature
Include your questions in a text box on the report canvas
Use the "Featured Q&A questions" feature
Use the "Edit Queries" feature
Check your answers
Use the "Featured Q&A questions" feature
How do you get Power BI Desktop to find relationships in data after it has been
imported?
Open the Power Query Editor
Select Manage Relationships and then Autodetect
Select the New Parameter button to map the relationship
Use the Performance Manager
Select Manage Relationships and then Autodetect
If your months were sorted alphabetically, how could you sort them by month
order?
Click the Edit Queries button
Add a slicer to your visual
Change the visualization type
Apply the MonthNo category sort option
Apply the MonthNo category sort option
A+
What is a risk of having null values in a numeric column?
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect.
That function AVERAGE of data will be incorrect.
If you have two queries that have different data but the same column headers,
and you want to combine both tables into one query with all the combined rows,
which operation should you perform?
Append
Merge
Combine Column
Append
Which of the following selections are not best practices for naming conventions
in Power BI?
Rename columns to have spaces in them.
Abbreviate column names.
Replace values that have integers with human readable results.
Check your answers
Abbreviate column names.
Your social media engagement officer has requested your help in boosting
followers and retweets on Twitter. How could you help her get more information
to better understand and subsequently increase engagement?A. Power Apps
portals can create a new customer site for our followersB. Power Automate can
handle our content approvals for us, reducing the time it takes to produce new
content and ensure our quality procedure is followedC. Configure a Power BI
report to capture and analyze data from Twitter, allowing you to better understand
why certain posts elicit more responses
Which of the below is a way in which Power BI can help you effectively leverage
your data?
Analyze sales data to better allocate resources and place orders, optimizing
operations.
Analyze customer data to better target and promote specific items to specific
customers.
All of the above.
All of the above.
What are the three modalities of Power BI designed to let people create, share,
and consume business insights in the way that serves them, or their role, most
effectively?
, Desktop, service, and Mobile apps.
Tiles, visualizations, and dashboards.
Reports, dashboards, and tiles.
Desktop, service, and Mobile apps.
How can you get Power BI to spot outliers and trends in your data?
Use the Spotlight feature
Export data to Microsoft Excel
Use Quick insights
Use Custom Q&A
Use Quick insights
How could you gather, arrange, and share interesting Power BI visuals from
several different sources?
Pin them to a Power BI report
Pin them to a Power BI dashboard
Export them to PDF
Use the Get Data feature
Pin them to a Power BI dashboard
If you think of some interesting questions to ask in your report, how could you
share them to help your Q&A users?
Use the Spotlight feature
Include your questions in a text box on the report canvas
Use the "Featured Q&A questions" feature
Use the "Edit Queries" feature
Check your answers
Use the "Featured Q&A questions" feature
How do you get Power BI Desktop to find relationships in data after it has been
imported?
Open the Power Query Editor
Select Manage Relationships and then Autodetect
Select the New Parameter button to map the relationship
Use the Performance Manager
Select Manage Relationships and then Autodetect
If your months were sorted alphabetically, how could you sort them by month
order?
Click the Edit Queries button
Add a slicer to your visual
Change the visualization type
Apply the MonthNo category sort option
Apply the MonthNo category sort option
