DP-500: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI

What level are user permissions set at in Microsoft Purview? -Tenant. -Data catalog. -Collection.

Collection. User permissions are set at the collection level in Microsoft Purview.

Where would you register your data sources for use in Microsoft Purview? -In the Overview tab of the Microsoft Purview account page. -In the Managed Resources tab of the Microsoft Purview account page. -In the Microsoft Purview governance portal.

In the Microsoft Purview governance portal. The Microsoft Purview governance portal is where you register your data sources.

Which of the following is a key benefit of deployment pipelines? -Dataset creation is streamlined -Reports can be published from multiple workspace environments -Enhanced user access to BI report source data -Less manual work and fewer errors

Less manual work and fewer errors Using deployment pipelines leads to less manual work and fewer errors.

Akira is a data modeler at Adventure Works who is developing a model for a data warehouse. The model includes a table that stores products and another table that stores sales monthly targets of product categories. Akira adds a relationship to relate the two tables.Which cardinality type should Akira set to achieve an optimal model? -One-to-one. -One-to-many. -Many-to-many.

Many-to-many. The product table category column and the sales target category column will contain duplicate categories.

Power BI paginated reports are created by using which tool? -Power BI Desktop -Power BI service -Power BI Report Builder

Power BI Report Builder They are only built by using the Power BI Report Builder.

Which of the following embed scenario allows you to easily embed interactive Power BI content in blog posts, websites, emails, or social media? -Embed in PowerApps -SharePoint Online web part -Publish to web -Embed in Microsoft Teams

Publish to web This Power BI embed scenario allows a user to embed interactive Power BI content in blog posts, websites, emails, or social media.

Power BI paginated reports is an evolved technology that was built from which original tool? -SQL Server Analysis Services -SQL Server Reporting Services -Microsoft SharePoint

SQL Server Reporting Services Power BI paginated reports was built from SQL Server Reporting Services.

Which one of the following ISN'T a permission level available in workspaces v2? -Admin -Member -Contributor -Steward

Steward Steward isn't a permission level in the workspaces v2.

Geoffrey is a data modeler at Adventure Works who developed a DirectQuery model that connects to the data warehouse. To improve the query performance of higher-grain sales queries, Geoffrey added an import aggregation table. What else should Geoffrey do to improve query performance of the higher-grain queries? -Set related dimension tables as aggregation tables. -Set related dimension tables to dual storage mode. -Set related dimension tables to import storage mode.

Set related dimension tables to dual storage mode. Setting the related dimension tables to dual storage mode will allow Power BI to satisfy higher-grain queries entirely from cache.

Which of the following best practices for Power BI data modeling is relevant only to DirectQuery models? -Set relationships to enforce integrity using the assume referential integrity property on relationships. -Use a star schema as opposed to wide tables. -Disable auto date/time in Power BI Desktop.

Set relationships to enforce integrity using the assume referential integrity property on relationships. Setting the assume referential integrity setting on relationships enables more efficient queries against your data source in DirectQuery.

A Power BI Premium P1 capacity supports how many concurrent dataset refreshes? -Two -Four -Six -Eight

Six Power BI Premium P1 supports up to six simultaneous dataset refreshes.

Fiafia is a developer at Adventure Works who is needs to deliver a real-time Power BI dashboard. It should present real-time manufacturing data with the lowest possible latency. The dashboard only shows manufacturing events for the past hour. The solution should use the minimum of Power BI resources. What type of dataset should Fiafia develop? -DirectQuery dataset. -Push dataset. -Streaming dataset.

Streaming dataset. A streaming dataset would result in the lowest latency of about one second.

Why is it important to understand the difference between structured and unstructured data? -There is no difference between structured and unstructured data -Understanding the difference can determine where data should be stored and what kind of analysis is most appropriate -Understanding the difference will determine if the business requirements have been met

Understanding the difference can determine where data should be stored and what kind of analysis is most appropriate Understanding the difference between structured and unstructured data will aid in planning for the analytics process.

What type of data is best suited for batch processing? -IoT gas sensor data that monitors and detects the presence of toxic or hazardous gasses. -Real-time personalized advertising data. -Daily sales report data.

Daily sales report data. Batch processing is the processing of transactions in a group or batch. In this case sales data are batched by day.

What are the two types of classification in Microsoft Purview? -System classifications and custom classifications. -Microsoft Information Protection Sensitivity Labels and system classifications. -Custom classifications and user-defined classifications.

System classifications and custom classifications. Microsoft Purview contains out of the box, system classifications and custom classifications.

What is a limitation of result-set caching? -The maximum size of the result set cache is 1 TB per database. -Users cant manually empty the result set cache. -Pausing the database will clean the cache.

The maximum size of the result set cache is 1 TB per database. When the result set cache approaches the maximum size, cache eviction will start.

Which of the following is NOT a recognized option to create or build on top of a dataflow? -Use define new tables -Use linked tables -Use entity tables -Use a computed table

Use entity tables Use entity tables is not a recognized way to create or build on top of a dataflow.

What elements can be changed with personalized visuals? -Custom theme color. -Visualization type. -Background images.

Visualization type. Consumers can change visualization type to their preference such as bar to pie chart.

After creating a pipeline, what step must you take to add content to your pipeline? -Create a workspace -Assign a workspace containing the content you wish to manage in your pipeline -Configure your deployment rules -Add content to a workspace

Assign a workspace containing the content you wish to manage in your pipeline Assign a workspace containing the content you wish to manage in your pipeline.

If you wanted a single product to provide source control and deployment management in Power BI service, which of the following products would you choose? -OneDrive -SharePoint -Azure DevOps

Azure DevOps Azure DevOps can be configured to publish directly to Power BI deployment pipeline workspaces.

What is the primary advantage of the Compare view capability between pipeline stages? -Compare view helps you determine the dependency of all items in sequential pipeline stages. -Compare view allows you to determine the last time content was deployed to a stage. -Compare view includes a comparison of the content and refresh time between stages. -Compare view helps you identify and track changes between items in each pipeline stage.

Compare view helps you identify and track changes between items in each pipeline stage. Using the Compare view option helps you identify and track changes between items in each pipeline stage.

For application lifecycle management, what is the process called for automating code deployment from development to production? -Constant Update / Constant Deployment -Continuous Integration / Continuous Delivery -Continuous Update / Continuous Development

Continuous Integration / Continuous Delivery The correct answer is Continuous Integration / Continuous Delivery.

Which element of data governance defines policies for use of data in a Power BI system? -Visibility -Control -Support Compliance

Control Control is a key component of BI data governance and defines policies for use of data in a Power BI system.

Which of the following pipeline activities records data lineage data in a connected Purview account? -Get Metadata -Copy Data -Lookup

Copy Data A Copy Data activity and its data lineage from source to target is recorded in a connected Purview account.

If you're developing a report that relies on a global data source and you need to add more data sources for each continent, which solution below would you implement? -Create dataset in Analysis Services with all data sources, then use row-level security to limit what data users see based on their location. -Create separate global and continent reports in Power BI Desktop, then use a Power BI service dashboard to highlight details for each location. -Create and publish a global dataset, then connect to the dataset through Power BI Desktop, and add other tables to create the specialized dataset for each location.

Create and publish a global dataset, then connect to the dataset through Power BI Desktop, and add other tables to create the specialized dataset for each location. By creating a core global dataset, you can reduce the size of continental reports and limit assets while maintaining functionality.

Which external database object encapsulates the connection information to a file location in a data lake store? -FILE FORMAT -DATA SOURCE -EXTERNAL TABLE

DATA SOURCE a DATA SOURCE provides the connection information to the files in a data lake store.

Which of the following sequence of steps would you follow to create a pipeline from a Premium workspace? -From the navigation panel on the left side of your Power BI home page, select Deployment pipelines. Next select Create pipeline and in the dialog box, enter a name for your pipeline. -Assign a pipeline to a workspace. Navigate to the workspace and enter a name and description for the pipeline. Select the Create button to create your pipeline. -From the navigation panel on the left side of your Power BI home page, select Create. Next assign a pipeline to a workspace and enter a name and description for the pipeline. Select Create. -From an existing workspace, select Create a pipeline, then enter a name and description for the pipeline and select Create.

From an existing workspace, select Create a pipeline, then enter a name and description for the pipeline and select Create. You can create a pipeline from a Premium workspace in three easy steps. Select Create a pipeline and then enter a name and description and select Create.

Which one of the following statements accurately describes searching through a Power BI activity log? -It is currently a manual task -You can use the Microsoft 365 security center to search an audit log -You can use the Microsoft 365 compliance center to search an audit log -Export the activity log to a searchable file format, for example Excel workbook

It is currently a manual task There currently is no user interface to search the activity logs.

What are the two views you can use to see the assets within a Power BI workspace? -Line and lineage view. -Line and relationship view. -File and lineage view.

Line and lineage view. You can see line items or relationship representation with lineage view.

What details of an asset would be helpful in performing an impact analysis? -Lineage. -Properties. -Schema.

Lineage. Viewing lineage details will help users perform an impact analysis.

Rupali is a data modeler at Adventure Works who is developing an import model to analyze employee timesheet data. The employee table stores the employee social security number (SSN) in a column. While the model will be available for all company managers, it will also be available to employees in the Payroll department. However, reports must only reveal employee SSNs to payroll employees. What feature should Rupali use to restrict access to the SSN column? -RLS. -SSO. -OLS.

OLS. You can use OLS (object-level security) to secure the SSN column in the employee table.

Belle is a data modeler at Adventure Works who is developing a model for a data warehouse. The model includes a table that stores products and another table that stores sales of those products. Belle adds a relationship to relate the two tables.Which cardinality type should Belle set to achieve an optimal model? -One-to-one. -One-to-many. -Many-to-many.

One-to-many. A one-to-many relationship relates the product table to the sales table. Filters applied to the product table will propagate to the sales table to allow analysis of product sales.

Which feature of Azure Synapse Analytics enables you to transfer data from one store to another and apply transformations to the data at scheduled intervals? -Serverless SQL pool -Apache Spark pool -Pipelines

Pipelines Pipelines provide a way to encapsulate one or more actions that can be applied to data as it is transferred from one data store to another.

What are the data model size limits on a dataset with large dataset storage format determined by? -Power BI Premium 10 GB size limit. -Power BI Premium capacity size or the maximum size set by the administrator. -There are no size limits if large dataset storage format is enabled.

Power BI Premium capacity size or the maximum size set by the administrator. When enabled, dataset size is limited by the Premium capacity size or the maximum size set by the administrator.

Which of the following administrator roles is NOT responsible for configuring tenant settings? -Global administrator -Power BI service administrator -Microsoft Power Platform service administrator -Power BI billing administrator

Power BI billing administrator The Power BI billing administrator is responsible for administrating BI billing and not configuring tenant settings.

What feature must be enabled for you to manage Power BI datasets from external tools? -Power BI Service API. -Read-write XMLA endpoint. -Read-only XMLA endpoint.

Read-write XMLA endpoint. To do more than view, you need the read-write option enabled.

What are the first three steps in the data analytics process? -Data exploration, data analysis, and deploy analytics solution -Data analysis, deploy analytics solution, and request feedback -Requirements gathering, data ingestion and processing, and data exploration

Requirements gathering, data ingestion and processing, and data exploration Requirements gathering is a critical first step, followed by data ingestion and processing, and data exploration.

A new data analyst in the Finance department is creating a new report. They're connected to a single Azure SQL database through Power BI desktop to develop the dataset and report. Once finished, they need to allow testing before deploying to production workspace. Which is the best source control and deployment strategy for this scenario? -Save the .pbix file in a shared OneDrive folder, then use Power BI deployment pipelines for testing and production release. -Save the .pbix file in Git repository, then publish to a development workspace and request final approval for production. -Save the .pbix file on a network share, then publish to a development and test workspace before requesting release to production.

Save the .pbix file in a shared OneDrive folder, then use Power BI deployment pipelines for testing and production release. OneDrive and deployment pipelines is the easiest way to have source control and limited overhead.

What character in file path can be used to select all the file/folders that match rest of the path? & * /

* The asterisk character in file path can be used to select all the file or folders that match rest of the path.

You want to write code in a notebook cell that uses a SQL query to retrieve data from a view in the Spark catalog. Which magic should you use? -%%spark -%%pyspark -%%sql

%%sql The %%sql magic instructs Spark to interpret the code in the cell as SQL.

You use the RANK function in a query to rank customers in order of the number of purchases they have made. Five customers have made the same number of purchases and are all ranked equally as 1. What rank will the customer with the next highest number of purchases be assigned? 2 6 1

6 There are five customers with a higher number of purchases, and RANK takes these into account.

What can be considered a benefit of materialized views? -A different data distribution compared to the base tables. -Decreased query performance for complex queries with JOINs and aggregate functions, but increased performance for simple queries. -Instant query response times for repetitive query patterns.

A different data distribution compared to the base tables. The data in a materialized view can be distributed differently from the base tables.

Which definition best describes Apache Spark? -A highly scalable relational database management system. -A virtual server with a Python runtime. -A distributed platform for parallel data processing using multiple languages.

A distributed platform for parallel data processing using multiple languages. Spark provides a highly-scalable distributed platform on which you can run code written in many languages to process data.

Which of the following is an example of descriptive analytics? -A monthly sales report looking at sales data over the last year -A social media algorithm that recommends curated content -An annual HR report that forecasts predicted attrition for the next year

A monthly sales report looking at sales data over the last year Descriptive analytics answers questions about what happened, based on historical data.

You create a dimension table for product data, assigning a unique numeric key for each row in a column named ProductKey. The ProductKey is only defined in the data warehouse. What kind of key is ProductKey? -A surrogate key -An alternate key -A business key

A surrogate key A surrogate key uniquely identifies each row in a dimension table, irrespective of keys used in source systems.

You need to compare approximate production volumes by product while optimizing query response time. Which function should you use? COUNT NTILE APPROX_COUNT_DISTINCT

APPROX_COUNT_DISTINCT APPROX_COUNT_DISTINCT returns an approximate count within 2% of the actual count while optimizing for minimal response time.

Which BI REST API operations group supports automating tasks for working with administrative tasks? -Apps -Admin -Users -Tasks

Admin The admin operations group is designed to help automate common administrative tasks.

What are the different methods of sharing Power BI content? -Apps -Sharing dashboards or reports -Publish to web -Embed content -All of the above

All of the above Apps, sharing dashboard or reports, publish to web, and embed content are the different methods to share Power BI content.

Mary-Jo is responsible for managing the maintenance and deployment of Power BI assets for the entire organization. What tool can Mary-Jo use to ensure all data models adhere to data modeling best practices? -DAX Studio. -Best Practice Analyzer in Tabular Editor. -Performance analyzer.

Best Practice Analyzer in Tabular Editor. The Best Practice Analyzer in Tabular Editor can be run manually or automated to ensure all models adhere to best practices.

Which of the following tasks are completed by a data analyst? -Build monthly sales reports and gather feedback from the business on how reports are being used. -Design, implement, and maintain operational aspects of on-premises and cloud-based database systems. -Manage and secure the flow of structured and unstructured data from multiple sources into analytical data storage.

Build monthly sales reports and gather feedback from the business on how reports are being used. Data analysts processes raw sales data into relevant insights.

The ability to combine multiple data connections describes which data connectivity mode? -Live/exploration -Direct query -Composite -Import

Composite The composite data connectivity mode allows for combining multiple data connections including direct query or import or a combination of both.

Mousef is a business analyst at Adventure Works who wants to create a new model by extending the sales dataset, which is delivered by IT. Mousef wants to add a new table of census population data sourced from a web page. Which model framework should Mousef use? -Composite. -DirectQuery. -Live connection.

Composite. A composite model would comprise a DirectQuery source group containing the sales dataset tables, and an import source group containing the imported web page data.

You want data analysts using Synapse Studio to be able to find data assets that are registered in a Microsoft Purview collection. What should you do? -Register an Azure Synapse Analytics source in the Purview account -Add a Data Explorer pool to the Synapse Workspace -Connect the Purview account to the Synapse analytics workspace

Connect the Purview account to the Synapse analytics workspace Connecting the Purview account to the workspace makes it searchable in Synapse Studio.

Ivor is working on an analytics solution that requires ETL logic to be applied to a table that sits outside of the data warehouse. Multiple analysts need to use this supplemental cleaned data in their reports, and it's important that all reports reflect the exact version of the cleansed data. Analysts don't have access to the data source. What should Ivor do to provide analysts with this data at the lowest access level necessary? -Create a Power BI dataset in a shared workspace and give all analysts contributor access. -Create a Power BI dataflow in a shared workspace and give all analysts viewer access. -Create a Power BI dataflow in a shared workspace and give all analysts admin access.

Create a Power BI dataflow in a shared workspace and give all analysts viewer access. A Power BI dataflow will provide access to transformed data. Viewer access provides the ability to use the dataflow in reports.

What feature of Microsoft Purview can analysts and other data consumers use to find trustworthy data for reports? -Data map. -Data catalog. -Data policies.

Data catalog. Microsoft Purview data catalog helps users find trusted data sources by browsing and searching data assets across a data estate.

What is the most efficient approach for data transformation when designing data models for scalability? -Data transformation should always be done using Power Query in Power BI. -Data transformation should be done as close to the source as possible, before reaching Power BI. -Data transformation should be done using DAX, after data is ingested and loaded to the model.

Data transformation should be done as close to the source as possible, before reaching Power BI. When you're considering scalability and large data, transformation should be done as close to the source as possible. This will enable reduced processing during data import in Power BI.

You want to create a data warehouse in Azure Synapse Analytics in which the data is stored and queried in a relational data store. What kind of pool should you create? -Serverless SQL pool -Dedicated SQL pool -Apache Spark pool

Dedicated SQL pool A dedicated SQL pool defines a relational database in which data can be stored and queried.

In which of the following table types should an insurance company store details of customer attributes by which claims will be aggregated? -Staging table -Dimension table -Fact table

Dimension table Attributes of an entity by which numeric measures will be aggregated are stored in a dimension table.

What calculation item property should a report creator define to allow conditional application of format strings to measures? -Dynamic format strings. -Precedence. -Ordering.

Dynamic format strings. Dynamic format strings enable report creators to overwrite the format string by setting the format string expression property.

In the context of data model calculations, which statement best describes time intelligence? Snapshot balance reporting -Filter context modifications involving a date table -Complex calculations involving time -Calculations involving hours, minutes, or seconds

Filter context modifications involving a date table Time intelligence calculations modify date filter contexts.

What key factor should be considered when sizing your gateway hardware? -Data center proximity to data sources -Network availability -Available rack space in the data center -Frequency and data volume of data model refreshes in Power BI

Frequency and data volume of data model refreshes in Power BI When determining the power and type of hardware to use for your gateway, a key factor would be the frequency and data volume of data model refreshes in your Power BI environment as this will represent a major processing load on the machine.

What is a primary reason you would use scripting to automate common Power BI administrative tasks? -Reduce system production overhead -Implement governance policies -Lessen your workload -Optimize your Power BI system performance

Implement governance policies Automating common administrative tasks supports the implementation of governance policies.

How can users download Power BI data source files that contain connections to assets discovered in Microsoft Purview? -In the Microsoft Purview data catalog, in the asset view. -In the Microsoft Purview insights report. -Users can't download Power BI data source files from Microsoft Purview.

In the Microsoft Purview data catalog, in the asset view. There's a button in the asset view to open the asset in Power BI desktop.

What does Microsoft Purview do with the data it discovers from your registered sources? -It catalogs and classifies the data that is scanned. -It moves the data to your Azure subscription, automatically creating the necessary storage accounts. -It performs data transformations to match your on-premises schemas.

It catalogs and classifies the data that is scanned. It creates a holistic, up-to-date map of your data landscape with automated data discovery, sensitive data classification, and end-to-end data lineage. Empower data consumers to find valuable, trustworthy data.

Power BI Template Apps allow Power BI Pro and Power BI Premium users to gain immediate insights through prepackaged dashboards and reports that can be connected to what source? -SharePoint Online -.NET gallery -O365 -Live data sources

Live data sources Live data sources are a source that allows Power BI Pro and Premium users to gain insights through prepackaged dashboards and reports.

You're developing a data model in Power BI Desktop. You've just added a date table by using the CALENDARAUTO function. You've extended it with calculated columns, and you've related it to other model tables. What else should you do to ensure that DAX time intelligence calculations work correctly? -Add time intelligence measures to the date table. Mark as a Date table. -Add a fiscal hierarchy. -Add a date column.

Mark as a Date table. You must mark the date table so that Power BI can correctly filter its dates.

A cmdlet is a single command that participates in the pipeline semantics of PowerShell and performs an action that typically returns what type of object to the next command in the pipeline. -Microsoft .NET -Advance script -CDXML -Workflow

Microsoft .NET A cmdlet typically returns a Microsoft.NET object to the next command in the pipeline.

James has been asked to troubleshoot a report that contains a matrix visual that renders visibly slower than any other visuals on the page. After James runs the Performance analyzer, he notices the need to dig further into the DAX query for the matrix using DAX Studio to understand what's causing the trouble. That same query is running in less than a second in DAX Studio. Has James solved the problem? -Yes. James doesn't need to make any more changes to the DAX query. -No. James needs to use Tabular Editor to continue to investigate. -No. James needs to clear the model cache to ensure that query results aren't cached in the model.

No. James needs to clear the model cache to ensure that query results aren't cached in the model. James may be seeing inaccurate results in either DAX Studio or the Performance analyzer because the query results have been cached.

What function is used to read the data in files stored in a data lake? -FORMAT -ROWSET -OPENROWSET

OPENROWSET The OPENROWSET is used to read the data in files stored in a data lake.

Which of the following workspaces v2 migration options are available to Power BI users? -Migration is optional even after general availability (GA). -Opt-in migration will be available at general availability (GA). -After general availability (GA), migration exemptions will be available to users. -There's little advantage to migrating, so the opt-out option should be selected.

Opt-in migration will be available at general availability (GA). This will be a migration option available to Power BI users.

Stephanie is an enterprise data analyst, working as a resource to data analysts sitting in the finance department. One of the finance analysts asked Stephanie to help troubleshoot why report visuals take 5 seconds to render after a slicer selection is made. What tool should Stephanie use first to begin troubleshooting? -Visual Studio. -DAX Studio. -Performance analyzer.

Performance analyzer. The Performance analyzer is a great tool to start investigating performance issues with visuals in a report.

In what resource can you find a list of available Power BI cmdlets? -My workspace -REST API database -PowerShell Gallery -AppSource

PowerShell Gallery Cmdlets are available on PowerShell Gallery.

Authors working with data models containing multiple calculation groups must be sure to specify what to control the order of application of calculation groups? -Ordering. -Precedence. -Calculation group name.

Precedence. Power BI provides secure distribution and sharing options for distribution of insights across an organization.

If a data analyst is looking for a specific resource for reporting, what should they use? -Purview Data Catalog to search. -The business glossary. -Import into Power BI and create a custom report.

Purview Data Catalog to search. Searching the Purview Data Catalog will help analysts find resources.

Which one of the following is NOT a Power BI tenant metric available through the O365 admin portal? -Number of user dashboards -Number of user reports -Report peak usage time during the day -Number of user datasets

Report peak usage time during the day Number of dashboards, reports, and datasets in a tenant are all metrics available metrics through the O365 admin portal. The metric - report peak usage time during the day, is not a metric currently available through the O365 admin portal.

What's the best way to share a custom theme? -Save and share custom theme JSON file. -Send the modified Power BI (.PBIX) file. -Set the default theme for the organization.

Save and share custom theme JSON file. Saving and sharing the JSON file allows others to import and use the theme.

What aspect of Microsoft Purview is used to configure the data discovery for your data sources? -Scan rules -Collections -Classifications

Scan rules In a Microsoft Purview catalog, you can create scan rule sets to enable you to quickly scan data sources in your organization.

If an analyst is looking for a specific asset by name and type, what is the most efficient way to find that asset in the data catalog? -Browse assets. -Manage glossary. -Search catalog.

Search catalog. Searching the data catalog can help users quickly find assets they're looking for.

What are the prerequisite steps to register and scan a Power BI tenant in Microsoft Purview? -Set up authentication between Purview and Power BI, and configure the Power BI tenant. -Set up and deploy a Power BI data gateway. -Configure the Power BI tenant only.

Set up authentication between Purview and Power BI, and configure the Power BI tenant. Authentication must be established using either Managed Identity or Delegated Authentication, and the Power BI tenant must be configured to allow service principles to use the read-only API.

Margaret is a data modeler at Adventure Works who is adding a measure to sales model. When evaluated, the measure must filter by filters already applied to an unrelated table.Which DAX function should Margaret use to create a virtual relationship? -RELATEDTABLE. -TREATAS. -USERELATIONSHIP

TREATAS. The TREATAS function applies the result of a table expression as filters to columns from an unrelated table.

Why are parameters important in Power BI paginated reports? -They allow the report developer to control the refresh interval of the report. -They allow the user to control aspects of how the report is rendered when the report is run. -They are required so that Power BI can call the paginated report.

They allow the user to control aspects of how the report is rendered when the report is run. Parameters can be used in the report dataset, the report design surface, and other places. Users insert values into the available parameters, and the report author uses those values in the appropriate location in the report.

You need to write a query to return the total of the UnitsProduced numeric measure in the FactProduction table aggregated by the ProductName attribute in the FactProduct table. Both tables include a ProductKey surrogate key field. What should you do? -Use two SELECT queries with a UNION ALL clause to combine the rows in the FactProduction table with those in the FactProduct table. -Use a SELECT query against the FactProduction table with a WHERE clause to filter out rows with a ProductKey that doesn't exist in the FactProduct table. -Use a SELECT query with a SUM function to total the UnitsProduced metric, using a JOIN on the ProductKey surrogate key to match the FactProduction records to the FactProduct records and a GROUP BY clause to aggregate by ProductName.

Use a SELECT query with a SUM function to total the UnitsProduced metric, using a JOIN on the ProductKey surrogate key to match the FactProduction records to the FactProduct records and a GROUP BY clause to aggregate by ProductName. To aggregate measures in a fact table by attributes in a dimension table, include an aggregate function for the measure, join the tables on the surrogate key, and group the results by the appropriate attributes.

Which of the following is NOT one of the single sign-on (SSO) user-mapping options covered in this module? -Local Active Directory accounts synchronization with Azure Active Directory -User attribute auto conversion in SSAS -Manual user remapping -On-premises Active Directory Property Lookup to remap UPNs to AD users

User attribute auto conversion in SSAS User attribute auto conversion in SSAS is not a viable option to support the SSO user-mapping process.

What's an inclusive benefit of designing a report with accessibility features? -Users don't have auto-play videos slowing the performance. -Users will admire the bright colors and decorative images used for cohesiveness. -Users can understand the report using a screen reader or keyboard.

Users can understand the report using a screen reader or keyboard. Accessibility features allow high and low vision users to interpret the report equally.

A data analyst wants to analyze data by using Python code combined with text descriptions of the insights gained from the analysis. What should they use to perform the analysis? -A notebook connected to an Apache Spark pool. -A SQL script connected to a serverless SQL pool. -A KQL script connected to a Data Explorer pool.

A notebook connected to an Apache Spark pool. A notebook enables you to interactively run Python code in an Apache Spark pool and embed notes using Markdown.

In which of the following ways can you provide access to workspaces? -Security groups -O365 groups -Distribution groups -All of the above

All of the above Security groups, O365 groups, and distribution groups are all available ways you can provide access to workspaces.

Which one of the following is NOT a part of Power BI's Bring your own key (BYOK) feature? -Organization's keys are stored in Azure Key Vault. -An organization's encryption keys expire on an annual basis. -Both data-at-rest and in-process encryption are supported. -You can revoke your organization's keys if you exit the Power BI service.

An organization's encryption keys expire on an annual basis. All these statements are correct except for an organization's encryption keys expiring on an annual basis. Organizations can set an expiry date, but it's not required or based on a timespan.

Joshua is a data modeler at Adventure Works who is developing a model for a large data warehouse. The model must enforce RLS, and the Power BI reports that connect to the model should deliver the fastest possible performance. What should Joshua do? -Apply rules to dimension tables. -Apply rules to hierarchies. -Apply rules to fact tables.

Apply rules to dimension tables. It's efficient to apply rules to dimension tables. Power BI filters the dimension tables (that usually have a small number of rows) and uses model relationships to propagate those filters to fact tables (that contain millions of rows).

What limitation of calculation groups should Power BI report authors be aware of? -There are no limitations of calculation groups. -Applying calculation groups to a model disables the use of implicit measures in a Power BI report. -Applying calculation groups disables the ability to refresh data models in the Power BI service.

Applying calculation groups to a model disables the use of implicit measures in a Power BI report. Implicit measures are not supported in reports with calculation groups applied.

You want to scan data assets in the default data lake used by your Azure Synapse Analytics workspace. What kind of source should you register in Microsoft Purview? -Azure Synapse Analytics -Azure Data Lake Storage Gen2 -Azure Cosmos DB

Azure Data Lake Storage Gen2 Azure Synapse Analytics uses an Azure Data Lake Storage Gen2 storage account for the default data lake storage.

You want to scan data assets in a dedicated SQL pool in your Azure Synapse Analytics workspace. What kind of source should you register in Microsoft Purview? -Azure Synapse Analytics -Azure Data Lake Storage Gen2 -Azure SQL Database

Azure Synapse Analytics An Azure Synapse Analytics source is used to scan database in SQL pools in a workspace.

What Microsoft tools do data analysts use for enterprise-scale analytics solutions? -Azure Machine Learning and Azure Cosmos DB. -Microsoft Excel. -Azure Synapse Analytics and Microsoft Power BI

Azure Synapse Analytics and Microsoft Power BI Azure Synapse Analytics and Microsoft Power BI are enterprise-scale analytics tools used by data analysts.

What people focused strategies can help an organization achieve analytics at scale? -Azure Synapse Analytics and Microsoft Power BI can help achieve analytics at scale in an organization. -Building a data culture, establishing a Center of Excellence, and creating a community of practice. -Achieving analytics at scale should be technology focused rather than people focused.

Building a data culture, establishing a Center of Excellence, and creating a community of practice. Building a data culture, establishing a Center of Excellence, and creating a community of practice can assist in scaling analytics in an organization.

Which one of the following is correct? Power BI Premium is all about -Capacity or content -Number of users -Dataset refreshes -Dataset evictions

Capacity or content Power BI Premium is about capacity, or content. Power BI Pro is about the number of users.

Kasper is a data modeler at Adventure Works who is developing a model that must enforce RLS. It must restrict access to only the sales regions assigned to the report consumer. The source database includes a table that stores employee usernames and their assigned region(s). What should Kasper do? -Create an OLS role and use a dynamic rule. -Create an RLS role and use a dynamic rule. -Create an RLS role and use a static rule.

Create an RLS role and use a dynamic rule. An RLS role with a dynamic rule that uses the USERPRINCIPALNAME (or USERNAME) function can filter model data to the report consumer's assigned region(s).

Gladys is a developer at Adventure Works who needs to create a real-time Power BI solution to monitor their call center. When there are excessive numbers of callers waiting on hold, Power BI should notify the call center manager. What type of Power BI artifact should Gladys develop? -Dashboard. -Power BI report. -Streaming dataflow.

Dashboard. The call center manage can create an alert based on a dashboard tile.

Which link is NOT available for customization in the custom help and support menu? -Training documentation -Embed code list -Help desk -Licensing requests

Embed code list Embed code list provides a list of all available embed codes to users but is not a customizable link option in the custom help and support menu.

What steps are required in the Power BI admin portal to enable the scanning and display of enhanced metadata? -There are no other steps required. Enhanced metadata displays by default. -Enable enhanced metadata scanning in the Azure portal. -Enable an admin API setting in the Power BI admin portal.

Enable an admin API setting in the Power BI admin portal. Enabling the admin API settings will enable enhanced metadata scanning.

Benny is a report author at Adventure Works who needs to set up a Power BI report page to show real-time manufacturing data with latency of 5 minutes. The report connects to a dataset that represents a DirectQuery model. Because the DirectQuery source is an operational system, it should be queried only when necessary. What should Benny do? -Set the AutoRefresh property to a value greater than zero. -Enable automatic page fresh with a change detection measure. -Set up incremental refresh for the dataset and enable the DirectQuery partition.

Enable automatic page fresh with a change detection measure. Automatic page refresh is the appropriate setting, and using a change detection measure will reduce the burden placed on the DirectQuery data source.

The process whereby an inactive dataset is removed from memory to make room for another dataset is known as -Eviction -Checkpointing -Transference -Load balancing

Eviction Eviction is the process whereby an inactive dataset is removed from memory to make room for another dataset. Dataset eviction is a normal, beneficial process and enables the support of a larger number of datasets than memory resources can handle at one time.

What distribution option would be best for a sales fact table that will contain billions of records? -HASH -ROUND_ROBIN -REPLICATE

HASH Hash distribution provides good read performance for a large table by distributing records across compute nodes based on the hash key.

Breana is a data modeler at Adventure Works who developed a manufacturing model, which is an import model. Breana needs to ensure that manufacturing reports deliver real-time results. Which type of table should Breana create? -Aggregation table. -Hybrid table. -Partitioned table.

Hybrid table. A hybrid table includes a DirectQuery partition for the current period to deliver near-real time results.

What data source connection method loads all of the data into the Power BI cache, and runs queries against the ingested data? -DirectQuery. -Import Connection. -Hybrid Connection

Import Connection. You can use Get Data in Power BI Desktop to connect to a data source like SQL Server for import.

You have a table that stores account balance snapshots for each date, excluding weekends. You need to ensure that your measure formula only filters by a single date. Also, if no record is on the last date of a time period, it should use the latest account balance. Which DAX time intelligence function should you use? -FIRST -FIRSTNONBLANK -LAST -LASTNONBLANK

LASTNONBLANK The LASTNONBLANK function will return the last date in the filter context where a snapshot record exists. This option will help you achieve the objective.

You need to use Spark to analyze data in a parquet file. What should you do? -Load the parquet file into a dataframe. -Import the data into a table in a serverless SQL pool. -Convert the data to CSV format.

Load the parquet file into a dataframe. You can load data from files in many formats, including parquet, into a Spark dataframe.

In what resource would you find client tools that provide the ability to produce and consume .NET packages? -.NET resource library -SharePoint Online gallery -REST API directory -NuGet gallery

NuGet gallery NuGet gallery is the central package repository.

What is one advantage of using Power BI over a Synapse notebook for data visualization? -There is no advantage, Power BI and Azure Synapse Analytics are comparable for data visualization -Power BI was designed for distribution of data products outside of the data team. -Power BI displays simple visualizations compared to Synapse notebooks.

Power BI was designed for distribution of data products outside of the data team. Power BI provides secure distribution and sharing options for distribution of insights across an organization.

Which of the following is NOT a common component of an effective BI governance model? -Data engineering -Service and support -Training and education -Enterprise reporting

Service and support Service and support are associated with supporting the operations of a BI environment and not a common component to the BI governance model.

Sherry is using a dataflow in Power BI Premium to refresh data from a web API. The volume of data is large and Sherry is using incremental refresh. Sherry notices that the dataflow refresh is suddenly taking much longer than it used to. Where can she check dataflow performance and investigate what might be going on? -The refresh history in the dataflow settings. -The performance analyzer in Power BI desktop. -The performance profiler in Visual Studio.

The refresh history in the dataflow settings. The refresh history provides an overview of refreshes and the run status. Sherry can also download details in a CSV file from the refresh history.

Juliane is creating a dataset to be used in multiple reports. To avoid duplicating logic, she wants to create a dataflow that references an existing dataflow. What requirement does Juliane need to confirm prior to creating her dataflow that contains the linked entity? -Juliane must have access to both of the underlying data sources. -The workspace where the dataflow resides must be in Premium capacity. -Both dataflows must reside in the same workspace.

The workspace where the dataflow resides must be in Premium capacity. Linked and computed entities require a Power BI Premium subscription.

What's the easiest way to convert a usage metrics report into a full featured editable Power BI report? -Run the report through the Power BI report converter -Use the "save as" command -Set up your report request to render an editable Power BI object -The usage metrics report is rendered in an editable format

Use the "save as" command Usage metrics reports are read-only. However, you can personalize a usage metrics report by using "Save as." This creates a brand-new dataset and converts the read-only report to a full-featured Power BI report that can be edited.