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.

1.Question 1Which of the following is true about shared workspaces in Power BI?1 pointThey can only be created by Power BI administrators, unlike personal workspaces.They allow multiple users to collaborate.They can’t be accessed by external users.2.Question 2What role in Power BI lets users create content and add or remove other users?1 pointMemberContributorViewerAdmin3.Question 3True or False: A single report can be added to multiple apps in the same workspace.1 pointFalse True4.Question 4Lucas wants to analyze his report's usage metrics to discover how long his content takes to load. Which report page should Lucas access to view the loading times?1 pointThe Report usage page.The Report performance page.The FAQ page.5.Question 5True or False: You must install a Power BI personal gateway when publishing content with an on-premises data source for the first time in a workspace. 1 pointFalseTrue6.Question 6Which refresh option in Power BI desktop requires the user to set parameters?1 pointOn-demand refresh.Incremental Refresh.Scheduled Refresh.7.Question 7What is the primary purpose of endorsing datasets in Power BI?1 pointTo highlight high-quality content.To endorse the report’s accessibility.To transfer ownership of datasets to other users.8.Question 8What is the primary purpose of Deployment Pipelines in Power BI?1 pointTo delete outdated reports and dashboards.To maintain separate environments for efficient deployment processes.To deploy Power BI content on external websites9.Question 9Lucas has created a sales report for Adventure Works management. In which deployment pipeline environment should Lucas initially place this report?1 pointDevelopmentTestProduction10.Question 10What is the primary purpose of conducting Impact Analysis on a dataset in Power BI Service?1 pointTo identify what reports or dashboards could be influenced by the changes.To troubleshoot potential connectivity issues.To calculate the storage impact of a workspace.

Question 20Which actions are part of a typical Microsoft Power BI workflow? Select all that apply.1 pointPublish the report to the Power BI service. Use Power BI Mobile apps to view and interact with reports and dashboards.Import data and create the report in Power BI Desktop.Share your reports and dashboards with relevant stakeholders and manage access.

On a simple level, Power BI is an application that allows you to create reports and more. But on a granular level, Power BI is actually ______ .1 pointA collection of software services and connectors that work together to help you gain insight into your data A collection of applications, software services, and connectors that work together to help you gain insight into your data A collection of applications and connectors that work together to help you gain insight into your data A collection of applications and software services that work together to help you gain insight into your dat

Question 16As a data analyst, you work with the Microsoft Power Query Editor in Microsoft Power BI Desktop. What are some of the core functionalities provided by the Power Query Editor? Select all that apply.1 pointIt enables you to clean, transform, and reshape data.It allows you to merge and append queries.It provides a platform to share and collaborate on reports and dashboards.It permits you to visualize data using bar charts and maps.

What is the purpose of Power Query in Power BI?*To create custom visuals for data visualizationTo analyze and visualize dataTo create and manage data sourceTo import, transform, and combine data from various sources