Power Bi 300 Exam 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
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
