Pre-test ASCC - Data Analytic (Day 2)

Which of the following is not a visualization type available in Power BI?

• Bar chart

• Line chart

• Gantt chart

• Network graph

What is the main purpose of Power BI?

• Creating financial reports

• Managing inventory

• Analyzing and visualizing data

• Editing images

Which formula language is specific to Power BI for data analysis?

• SQL

• Python

• DAX

• R

What is Power Query in Power BI used for?

• Writing database queries

• Writing Python scripts

• Extracting, transforming, and loading data

• Creating 3D models

What is a 'report' in the context of Power BI?

• A collection of visualizations saved on one page

• A collection of raw data

• A collection of tables

• A collection of programming scripts

What is a Data Model in Power BI?

• A tool for creating visualizations

• A tool for managing user access

• A collection of tables with relationships and calculations

• A tool for database administration

Which of the following is an interactive visual component in Power BI?

• Slicer

• Spreadsheet filter

• Toolbar

• Status bar

What is the function of a 'Slicer' in Power BI?

• Creating new data visualizations

• Filtering data on visualizations

• Editing source data

• Managing user access

Which feature allows users to automatically refresh data in Power BI?

• Manual Refresh

• Automatic Update

• Scheduled Refresh

• Data Sync

How do you combine data from two different tables in Power BI?

• Using Slicer

• Using Relationship

• Using Data View

• Using Dashboard