When grouping data in Power BI, what happens to the original dataset?1 pointThe original dataset remains unchanged.The data is automatically sorted based on grouping criteria.The original dataset is deleted.The data is aggregated into the new group values

The function which is used to re-arrange data according to speciccriteria is called:a) Filtering b) Sortingc) Organizing d) Grouping

Question 4True or False.One must convert the dataset into a csv format before importing into Power BI. 1 pointTrueFalse

Your team at Adventure Works is working on a new project to analyze customer feedback. The feedback comes from various channels and in multiple formats. As a data analyst, you're asked to transform this data using Microsoft Power BI. What is the primary objective of data transformation in Power BI?1 pointTo automate the process of data entry. To create meaningful and impactful data visualizations. To facilitate real-time collaboration with team members. To convert raw data into a more meaningful and usable format.

1.Question 1What is the purpose of a Power BI Workspace?1 pointIt is used to create reports and visualizations.It is used to install Power BI Desktop on your computer.It is a space for collaborating on reports and dashboards.2.Question 2True or False: You can only share reports in Power BI Service by upgrading to Power BI Premium.1 pointTrueFalse3.Question 3You've received a sales dataset that contains duplicate data. You need to remove the duplicate rows for accurate reporting. At which stage of the data flow process must this action occur?1 pointDuring the data connection stage. During the data transformation stage. During the data cleansing stage.4.Question 4Adventure Works sales datasets contains data from multiple regions, each stored in a separate Excel file. The company must import these files to access the data. At which stage of the data flow process does this action occur?1 pointDuring the data cleansing stage.During the reporting stage. During the data connection stage.5.Question 5Which feature of Power BI Service reduces the risk of data loss due to unforeseen events like hardware failures?1 pointReal-Time CollaborationCloud ScalabilityData Backup and Recovery6.Question 6True or False: Data analysts can help to implement fraud detection and prevention procedures.1 pointTrueFalse7.Question 7What is the purpose of using normalization in SQL databases?1 pointTo divide data into multiple related tables.To efficiently return specific subsets of data.To enable simultaneous access by multiple users.8.Question 8You are creating a presentation on Import and DirectQuery connection modes for Adventure Works. Which of the following statements must you include in your presentation? Select all that apply:1 pointDirectQuery mode loads data directly into Power BI for fast visualizations.DirectQuery mode can potentially lead to slower performance.Import mode may not reflect real-time updates.Import mode connects Power BI directly to the source database.9.Question 9How do parameters contribute to creating multi-value dynamic reports in Power BI?1 pointParameters support both integer and decimal numerical values for customization.Parameters enable users to modify dataset values.Parameters allow users to input multiple values to customize data views.10.Question 10Which of the following scenarios best illustrates the use of multi-value dynamic reports?1 pointAn analyst using parameters to create multiple reports simultaneously.An analyst using parameters to analyze monthly sales data for multiple regions simultaneously in a single report.An analyst using parameters to restrict report views to a single product category within a single report.

In Quick BI, which of the following approaches can be used to group and aggregate data sets?1) Create a group dimension in the dataset2) Use the function COUNT(DISTINCT[string])3) Use the SUBSTRING function4) Use the CASE WHEN functionQuestion 6Select one:a.1,4b.1,2c.2,3d.3,4