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. - 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 - 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 - ANSWER Abbreviate column names.
Your social media engagement officer has requested your help in boosting followers and re-
tweets 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
1
, 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. Config-
ure a Power BI report to capture and analyze data from Twitter, allowing you to better un-
derstand why certain posts elicit more responses - 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. - ANSWER All of the above.
What are the three modalities of Power BI designed to let people create, share, and con-
sume 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. - 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 - 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
2
That function SUM of data will be incorrect.
That function MAX of data will be incorrect.
That function AVERAGE of data will be incorrect. - 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 - 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 - ANSWER Abbreviate column names.
Your social media engagement officer has requested your help in boosting followers and re-
tweets 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
1
, 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. Config-
ure a Power BI report to capture and analyze data from Twitter, allowing you to better un-
derstand why certain posts elicit more responses - 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. - ANSWER All of the above.
What are the three modalities of Power BI designed to let people create, share, and con-
sume 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. - 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 - 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
2
