Power Bi 300 UPDATED Exam Questions
and CORRECT Answers
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. - CORRECT ANSWER- 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 - CORRECT ANSWER- 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 - CORRECT ANSWER- 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 - CORRECT ANSWER-
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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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 - CORRECT ANSWER- 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 - CORRECT ANSWER- 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
and CORRECT Answers
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. - CORRECT ANSWER- 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 - CORRECT ANSWER- 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 - CORRECT ANSWER- 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 - CORRECT ANSWER-
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. - CORRECT ANSWER- 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. - CORRECT ANSWER- 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 - CORRECT ANSWER- 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 - CORRECT ANSWER- 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
