Test your Power Bi

What is Power BI?

• A spreadsheet software

• A business intelligence tool

• A project management software

• A video editing tool

• none

Which company develops Power BI?

• Microsoft

• Google

• Adobe

• Apple

What is the file extension of Power BI Desktop files?

• .pptx

• .ppcx

• .pbix

• .xlsx

A critical aspect of data aggregation is that it allows you to focus on

• A.The important and most meaningful data

• B.Disabling interactive analysis over big data

• C.Larger cache size and decreased query performance

• D.All of the above

This chart is used when a timeline is associated with data

• Bar Chart

• Box Plot

• Line Chart

• Tree Map

The complete design and functionality of a dashboard can be controlled by

• KPI Cards

• Breakers

• Slicers

• Groupers

What are the three core views in Power BI desktop?

• Report, Data, Queries

• Report, Queries, Relationships (Model)

• Report, Data, Relationships (Model)

• Queries, Data, Relationships (Model)

These charts are also called speedometer charts:

• Gantt Charts

• Gauge Charts

• Sankey Charts

• Line Charts

49 You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

• A.Add a SQL statement

• B.Set Data Connectivity mode to DirectQuery

• C.Set the Command timeout in minutes setting

• D.Set Data Connectivity mode to Import"

23 You need to store details about business entities Which of the following table should you use ?

• A.Fact table

• B.Dimension table

• C.Date table

• D.table