If you have two queries that contain different data with the same structure, and you want to combine them into one query, which operation should you perform?

Power BI comes with a range of visualizations to portray any data story you wish. There is one particular visual that is perfect to help users understand and analyze cash-flow during the ups and downs of all months in a financial year. Which visualization is this?

The process of shaping data by converting your flat data into a table that contains an aggregation value for each unique value in a column is called what?

What do you need to append to the URL of a Power BI dashboard in order to open it with the navigation pane collapsed by default?

Imagine you have created a query named Customers in a Power BI Desktop to append the rows from three external tables with customer data into a single output table named Customers. What would be the best approach to add a new fabricated ID column to the Customers table to ensure that every row in the Customers table contains a unique ID value?

Which of the following visuals is not included as part of Power BI and must be added as a custom visual?

What functionality lets you see the code that is generated as part of each transformation step?

What happens to the data types of Query Editor that are not available in data model while loading data?

Which of the following types of real-time data set in Power BI do not store their data in Azure SQL Database?

As part of a large BI project you have created a new dashboard for consumption by the HR team. After opening the Get Data menu option and selecting SQL Server, you are not sure which Data Connectivity mode to select. If you want the data to automatically refresh as you interact with visualizations which option should you choose?