POWER BI QUESTIONS

___________in Microsoft Power BI models are either implicit or explicit

• Tables

• Measures

• Keys

• Fact Tables

________ measures are automatic behaviors that allow visuals to summarize model column data.

• Explicit

• Numeric column.

• Implicit

• Panes Table

_______ measures, also known simply as measures, are calculations that you can add to your model.

• Explicit

• Implicit

• Measures

• Model

You have a large dataset that contains more than 1 million rows. The table has a datetime column named Date.

You need to reduce the size of the data model without losing access to any data. What should you do?

• Trim the Date column.

• Change the data type of the Date column to Text.

• Split the Date column into two columns, one that contains only the time and another that contains only the date

•  Round the hour of the Date column to startOfHour

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions. You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

• Merge tables by using Power Query

• Transpose

• Hide unused columns in the model

• Split the model into multiple models.

You create a dashboard by using the Microsoft Power BI Service. The dashboard contains a card visual that shows total sales from the current year.

You grant users access to the dashboard by using the Viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications.

What should you do?

• Create a data alert.

• Share the dashboard to the user.

• Create a subscription.

• Tag the user in a comment

You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month.

You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment.

How should the visual interactions be set on the column chart when the bar chart is selected?

• no impact

• highlight

• key

•  filter

You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success. Which type of visualization should you use?

•  Line and clustered column chart

• Key influencers

• Q&A

• Funnel chart

You’ve created a report that you published to a workspace. A few  business users need to have the ability to view the reports. What’s the most  appropriate way to achieve this? 

Your solution must consider that the report audience may change in the  future and that you’ve already created other reports in the workspace that  will be ready to be shared at a later date.

• Share an app with individual users.

• Share an app with a security group.

• Share report from workspace with individuals. 

• Give the users the Viewer role in the workspace.

What is a key benefit of data analysis?

• Decisive analytics

• Descriptive analytics

• Complex reports

• Informed business decisions