DA/BI developers

What is the primary purpose of data visualization?

• To store data

• To analyze data

• To present data in a graphical format

• To collect data

Which of the following is a key feature of the PowerBI interface?

• Data blending

• Drag-and-drop functionality

• Real-time collaboration

• Predictive analytics

In Tableau, what is the first step to create a dashboard?

• Connect to a data source

• Create a worksheet

• Publish the dashboard

• Export the data

Which of the following is NOT a type of data source you can connect to in PowerBI?

• Excel files

• SQL databases

• Google Sheets

• JSON files

What does DAX stand for in PowerBI?

• Data Analysis Expressions

• Data Aggregation Expressions

• Data Application Expressions

• Data Access Expressions

Which chart type is best suited for showing the relationship between two variables?

• Pie chart

• Bar chart

• Line chart

• Scatter plot

What is the purpose of the "Fields" pane in PowerBI?

• To create new reports

• To manage data connections

• To display available data fields for use in reports

• To publish reports online

In Tableau, which feature allows you to filter data on a dashboard?

• Parameters

• Filters

• Calculated fields

• Groups

Which of the following DAX functions is used to calculate the sum of a column?

• SUMX

• AVERAGE

• COUNT

• SUM

What type of chart is best for displaying parts of a whole?

• Line chart

• Bar chart

• Pie chart

• Histogram