Mock Exam PL300 Flashcards by Ally whitt

Your company’s product data is held in an Azure SQL Server database. Your company has an endorsed dataset available in the Power BI service that contains the company’s product catalog and sales data in a common model that standardizes how product data is reported. You use Power BI Desktop to create reports.
You need to create a new report on product data that is consistent with the standardized data.

What should you do?

A. Create a new local dataset connecting to the Azure SQL database.
B. Create a new .pbix file and use Power BI dataflows to connect to the endorsed dataset.
C. Edit a .pbix file with an existing connection to the Azure SQL database and connect to the endorsed dataset.
D. Create a new .pbix file and connect to the endorsed dataset.

D. Create a new .pbix file and connect to the endorsed dataset.

The Power BI Desktop can connect to datasets in the Power BI service that have been shared or published. This is called Power BI service live connection. You can then build your own reports based on this dataset and publish those reports to the Power BI service.

You should not use Power BI dataflows to connect to the dataset. You create datasets from a dataflow. Dataflows are the Data Transformation layer in Power Bl. Datasets are where modeling, calculations, and measures are created.

How well did you know this?

Not at all

Perfectly

You are importing data into a dataset from two data tables using Power Query and DirectQuery. TableA contains the Vendor details and TableB contains the products that are sold by each vendor. You need to combine the data from the two tables into a single table to make the dataset easier to navigate.

You must ensure that all of the vendors are included in the dataset.
What should you do?

A. Enable Assume Referential Integrity in Power BI Desktop.
B. Create a surrogate key.
C. Merge TableA with TableB using a left-outer join.
D. Append the queries for TableA and TableB

C. Merge TableA with TableB using a left-outer join.

How well did you know this?

Not at all

Perfectly

You are a data analyst using Visual Studio Data Tools (VSDT). You create a new Power BI organization and a premium workspace named workspace1 for a new customer.

You plan to connect and deploy a tabular model project in workspace1. What should you do first?

A. From Visual Studio Data Tools (VSDT), deploy the tabular model.
B. From the Power BI Admin portal, configure the XMLA endpoint as None.
C. From the Power BI Admin portal, configure the XMLA endpoint as Read Write.
D. From Visual Studio Data Tools (VSDT), update the tabular model compatibility level to 1500.

C. From the Power BI Admin portal, configure the XMLA endpoint as Read Write.

By default, a premium workspace has the XMLA endpoint enabled as Read only. Before trying to deploy the tabular model from Visual Studio Data Tools (VSDT), you need to change the XMLA endpoint to Read Write.

How well did you know this?

Not at all

Perfectly

You are using Power Query Editor to import the data of a single business entity from different data sources with different schemas into Power Bl. All of the data sources share a common ID that uniquely identifies each record of the entity.

You need to use the entity to filter on your report using slicers, in order to unify the data. Which feature should you use?

A. Combine files
B. Append Queries
C. Merge columns
D. Merge Queries
E. Group by

D. Merge Queries

You should use Merge queries to unify the data of a single business entity. Since the data comes from different data sources, it is a good practice to unify it to build a single dimension table that represents a single business entity according to the widely adopted star schema modeling approach. This dimension table would be used to filter on the fact table using a relationship, so it is a good fit to be used as a slicer. Since each data source has a different schema, merging based on matching values from one or multiple columns would be the appropriate choice. If there are no 100% similarities between values of the matching columns, you can still use fuzzy matching (only on text format columns).

How well did you know this?

Not at all

Perfectly

You are a business intelligence developer. You need to use data contained in Azure Analysis Services to build your report. You need to connect this data source.

What two solutions can you use to achieve this goal? Each correct answer presents a complete solution.
Correct!

A. Import
B. DirectQuery
C. Dual
D. Connect Live

A. Import
D. Connect Live

You can use Connect live. It is used when connecting to multidimensional data sources, such as Analysis Services. Connect live is one of the two solutions available when connecting to Azure Analysis Services in Power BI Desktop.
You can also use Import. Connect live is preferred because there are some limitations with Import mode.

How well did you know this?

Not at all

Perfectly

Your data model contains the following tables:

Calendar table: 25K rows that are updated rarely
Product table: 2K rows that are updated monthly
Sales table: 10M rows that are updated regularly, and changes need to be reflected immediately

You need to identify the best storage mode for the data model tables. Which storage mode should you use for the Product table and the Calendar table?

A. Product table - Import, Calendar table - DirectQuery
B. Product table - DirectQuery, Calendar table - Import
C. Product table - Import, Calendar table - Import
D. Product table - DirectQuery, Calendar table - DirectQuery

C. Product table - Import, Calendar table - Import

You should use Import as the storage mode for the Product and Calendar tables. The Import method is preferred when you have fixed or static rows with a low volume of data, meaning a few thousand rows that are updated infrequently. In the Import method, data is cached into Power BI

You should use DirectQuery as the storage mode for the Sales table. The DirectQuery method is preferred when you have a huge volume of data consisting of millions of rows. It is also useful when changes to the table need to be reflected immediately in the data model or report. In the DirectQuery method, queries are directly sent to the underlying data source.

How well did you know this?

Not at all

Perfectly

You create a report about product sales and customer churn rates. You need to restrict the visual to show the top five products with the highest churn rates.

Solution: You create a measure of the top five products using the TOPN DAX function. Does this solution meet the goal?

A. True
B. False

A. True

This solution meets the goal. The measure will return the top five records. However, the TOPN DAX function does not guarantee the order of the results.

How well did you know this?

Not at all

Perfectly

CompanyA is a consulting firm specialized in human resources (HR) processes for large retail companies in Europe. CompanyA manages an HR solution that uses multiple Azure SQL Server databases. Each retail company has its own database provisioned in an Azure subscription managed by CompanyA.

The data engineers are interested in building a report to measure employee turnover using Power BI Desktop. Each retail company may have different requirements for building the report. Each data engineer should work to build a report for a specific company, using a different database from their peers.

You need to support the data engineers to connect to the correct database.

Solution: Create a read-write XMLA endpoint for each customer. Does this solution meet the goal?

A. True
B. False

B. False

This solution does not meet the goal. You can use XML for Analysis (XMLA) endpoint to connect applications to access datasets published in Power BI service workspaces. This is useful for consuming Power BI datasets from Excel or for performing administrative tasks in SQL Server Management Studio (SSMS). XMLA is the same protocol as Microsoft Analysis Services, which is the engine that is used by Power BI under the hood.

How well did you know this?

Not at all

Perfectly

You are analyzing data quality for a dataset in Power Bl. You use Power Query to preview the data. You need to examine the quality of the data.

Identify if the below statement is factually correct:
Using Column profile in Data Preview, you can gain an insight into only the first 1,000 rows in the dataset.

A. True
B. False

B. False

By default, you can use Power Query to examine the first 1,000 rows of your dataset, but you can change this configuration to analyze the whole dataset instead. This applies to the Column profile, Column distribution, and Column quality options in Data Preview.

How well did you know this?

Not at all

Perfectly

You create a report about product sales and customer churn rates. You need to restrict the visual to show the top five products with the highest churn rates.

Solution: You create a measure of the top five products using the RANKX DAX function. Does this solution meet the goal?

A. True
B. False

A. True

This solution meets the goal. The measure will return the top five records. The RANKX DAX function returns the order (rank) for each product, and this rank can be used to display products in order from highest to lowest.

How well did you know this?

Not at all

Perfectly

You have a large dataset containing four million rows. The dataset primarily stores manufacturing and shipping-related information of medicines manufactured at a facility on a given day. The table has a column of data type Date/Time/Timezone.

You need to create some views day by day, while optimizing performance and reduce the size of the data model. What should you do?

A. Convert the column to Date.
B. Convert the column to Date/Time.
C. Convert the column to Text.
D. Convert the column to Duration.

A. Convert the column to Date.

You should convert the column to the Date data type. The key to choosing an optimal data type such that you have the optimized data captured for a given column is determined by the specific use-case. In this scenario, although the dataset is large, all of the data is being captured for a manufacturing facility for a given day. So, the capturing date is the required granularity for this use-case. Therefore, storing Date/Time/Timezone is excessive and will result in loading a large amount of data that is not required in visualizations or reporting

How well did you know this?

Not at all

Perfectly

Your manager encounters slowness with a Power BI report. The network and server are operating at optimal speed. You need to identify issues affecting report performance.

Which two tools can you use to meet your goal? Each correct answer presents a complete solution.

A. SQL Server Profiler
B. Query Diagnostics
C. Performance Analyzer
D. Performance Monitor

B. Query Diagnostics
C. Performance Analyzer

You can use Performance Analyzer to identify Power BI report performance issues. Performance analyzer shows you how much time it takes to render a visual. It also measures the amount of time it takes to retrieve data.

You can also use Query Diagnostics to identify Power BI report performance issues. Query Diagnostics allows you to diagnose query performance and transformations included in it. A query could have multiple steps. A step could be a transformation or a simple query. A transformation involves adding or removing a column, replacing a value, or calculating age from dates.

How well did you know this?

Not at all

Perfectly

Your company requirement is to define a fiscal year that starts from May. You need to create a common date for a data model using DAX. How should you complete the DAX expression?

A. DATE = CALENDARAUTO(3)
B. DATE = CALENDAR(3)
C. DATE = CALENDARAUTO(4)
D. DATE = CALENDAR(4)

C. DATE = CALENDARAUTO(4)

You should use the CALENDARAUTO() function to automatically create the common date table for the data model. This DAX function creates the date table based on the minimum and maximum available dates in a data model. You can provide 4 as an argument to this function to end the fiscal year in April and start the new fiscal year from May to meet the requirements.

How well did you know this?

Not at all

Perfectly

You have a table of Purchase Orders (POs), with the columns PO Number, PO Date, Vendor, and PO Amount.

[PO Number is formatted with PO Followed by the number. Date is YYYY-MM-DD Format, Vendor is text, and PO Number is a decimal ]

There are relationships with other tables on the PO Number, PO Date, and Vendor columns. You need to optimize model performance. Which two actions should you perform?

A. Remove the PO prefix from the PO Number column and change the data type to Whole Number.
B. Add a new column to the Purchase Order table and perform a lookup to set the Vendor Id from Vendor column.
C. Change the format of the PO Amount column to Currency.
D. Mark the Purchase Orders table as the date table.

A. Remove the PO prefix from the PO Number column and change the data type to Whole Number.

B. Add a new column to the Purchase Order table and perform a lookup to set the Vendor Id from Vendor column.

You should remove the PO prefix from the PO Number column and change the data type to Whole Number. The model will achieve the highest optimizations with numeric column data, which uses value encoding. Text columns use hash encoding that will adversely affect performance.

You should also add a new column to the Purchase Order table and perform a lookup to set the Vendor Id from Vendor column. The column should use the following function:
Vendor Id = LOOKUPVALUE (Vendor [Vendor Id], Vendor [Vendor], ‘Purchase Order’[Vendor]).
You should then recreate the relationship using the Vendor ID and not the Vendor name. Using numeric values in relationships instead of text will improve the model performance.

How well did you know this?

Not at all

Perfectly

You import a table into Power Bl.

You need to configure the columns in the table. Which Summarize option should you recommend for aggregating the Amount column for use in visualizations and calculating totals?

A. SUM
B. AVERAGE
C. Count
D. None

A. SUM

You should use the Sum aggregation for the Amount field. Amount is a decimal number, and analysis of total sales will be required for visualizations. Adding aggregations will reduce the size of the model and improve performance.

How well did you know this?

Not at all

Perfectly

You import a table into Power Bl.

You need to configure the columns in the table. Which Summarize option should you recommend for aggregating the Order Number column for use in visualizations and calculating totals?

A. SUM
B. AVERAGE
C. Count
D. None

C. Count

You should use the Count aggregation for the Order Number field. Order Number is an integer and is the unique reference for the Sales table. The type of visualizations that will be required for Order Number relates to the number of orders placed, so a count is the best aggregation option.

How well did you know this?

Not at all

Perfectly

You are creating a report of financial transactions showing monthly trends. The source transaction table has in excess of 10 million rows.
You need to optimize the report’s performance.

Which two actions should you perform? Each correct answer presents part of the solution.

A. Set the Storage mode on the transactions table to DirectQuery.
B. Create all visualizations on a single report page.
C. Set the Storage mode on the transactions table to Import. O
D. Create a summary table in the data source with the transaction data grouped by month.

A. Set the Storage mode on the transactions table to DirectQuery.
D. Create a summary table in the data source with the transaction data grouped by month.

Choice D is the most effective technique to reduce the size of the model. The transaction table will contain records for each transaction, but a summary table will contain one record per month, aggregating all of the transactions over the month. This will significantly reduce the number of records in the dataset.

By using DirectQuery, the data will not be held in the model, and queries will be sent to the database when users access visualizations. If you use DirectQuery, the performance will rely on the capacity of the data sources.

How well did you know this?

Not at all

Perfectly

You have a table named Sales with the columns: year, sales, prior year sales.
You need to create a measure that calculates sales from the previous year based on a dynamic period (_PY Sales).

Which two DAX expressions can you use to achieve the goal? Each correct answer presents a complete solution.

A. _PY Sales = CALCULATE(SUM(Sales[Sales]), SAMEPERIODLASTYEAR(‘Calendar’[Date]))

B. _PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar’[Date].[Date], -1, MONTH))

C. _PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar’[Date].[Date], -1, YEAR))

D. _PY Sales = CALCULATE(SUM(Sales[Sales]), PARALLELPERIOD(‘Calendar’[Date], -1, YEAR))

B. _PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar’[Date].[Date], -1, MONTH))

C. _PY Sales = CALCULATE(SUM(Sales[Sales]), DATEADD(‘Calendar’[Date].[Date], -1, YEAR))

Learn more - https://radacad.com/dateadd-vs-parallelperiod-vs-sameperiodlastyear-dax-time-intelligence-questionLinks to an external site.
https://learn.microsoft.com/en-us/dax/calculate-function-daxLinks to an external site.

How well did you know this?

Not at all

Perfectly

Which of the following statements about creating a portrait version of your reports/dashboards for mobile devices is TRUE ?

A. You can create a portrait version of your reports for mobile devices only on Power BI Desktop

B. You can create a portrait version of only your dashboards for mobile devices

C. You can create a portrait version of your reports for mobile devices on both Power BI Desktop and service

D. You can create a portrait version of your reports for mobile devices only on the Power BI service

C. You can create a portrait version of your reports for mobile devices on both Power BI Desktop and service.

When you publish a report to the Power BI service and view the report on a mobile device, you see the report in landscape orientation. However, you can create an additional view for mobile devices (portrait mode).
Either you can create a mobile layout in Power BI Desktop and publish the reports to service, or directly create the mobile layout in service. Either way, if a mobile layout for a report exists, the mobile-optimized version (portrait) will be shown to users on a mobile device.

How well did you know this?

Not at all

Perfectly

Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North.

You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?

A. Create a new group on the state column and set the Group type to List.
B. Create a new aggregation that summarizes by employee.
C. Create a new aggregation that summarizes by state.
D. Create a new group on the state column and set the Group type to Bin.

A. Create a new group on the state column and set the Group type to List.

How well did you know this?

Not at all

Perfectly

I am using the “on-object interaction” preview.

My bar chart visual, which is on the “Summary” page of my report, shows the Year of the “Hire Date” field in the X-axis and Employee Count in the Y-axis.

I want to add a drill-through that goes from this “Summary” page to a “Detail page”, which shows an analysis by quarter for a particular year. What do I need to do?

A. In the Format pane for the “Detail” page, go to “Canvas settings”.
B. In the Format pane for the “Summary” page, go to “Canvas settings”.
C. In the Format pane for the “Summary” page, go to “Page information”.
D. In the Format pane for the “Detail” page, go to “Page information”.

D. In the Format pane for the “Detail” page, go to “Page information”.

You then change the “Page type” to “Drillthrough”, and then add “Hire Date” into the “Drill through from”.

I have an Employee table in Power BI. I want to analyze Salary data by drilling down into various fields. I also want to be able to change the order of exploration when I want to.

Which AI visual is designed for this purpose?

A. Decomposition tree
B. Q&A
C. Key influencers
D. Smart narrative

A. Decomposition tree

You put the measure you want to breakdown in the Analyze section, and how you want to break down in the “Explain by”.

I have a field called “Comments”.
I want to create a filter on this field to retrieve the words “Start”, “State”, “Streets” and any other words which start with “St” and include another “t”.

As shown below,
* I create a Filter on the field “Comments”,
* I change the filter type to “Advanced filtering”, and
* I change the Show items when the value to “contains”.

What do I put into the “Show items when the value contains” to capture all of these values? (Which wildcard do I use to represent zero-to-many characters?)

A. st_t_
B. st%t%
C. st?t?
D. st⭐️t⭐️

D. st⭐️t⭐️

The * represents zero, one or many characters.

You have a report page named Sales which contains visual A, showing total sales for each city for the selected year, as shown in the exhibit.

You need to configure an interaction for this visual. When clicking Drill through, it should redirect to a detail page that shows Sales for the selected city by Product Line and will preserve all the filters from the Sales page.

Which four actions should you perform? Each correct answer presents part of the solution.

A. Create a table visual named Visual B to show total sales by city and product line.
B. On the Sales page, under the Drillthrough option, add the City column as the drill through field.
C. On the Detail page, under the Drillthrough option, add City column as the drill through field.
D. Create a new page named Detail.
E. On the Sales page, under the Drillthrough option, set Keep all filters to On.
F. On the Detail page, under the Drillthrough option, set Keep all filters to On.

D. Create a new page named Detail.
A. Create a table visual named Visual B to show total sales by city and product line.
C. On the Detail page, under the Drillthrough option, add City column as the drill through field.
F. On the Detail page, under the Drillthrough option, set Keep all filters to On.

To create a drillthrough interaction on Visual A, you first need to create a Detail page.
Then, place a table visual on this page to show total sales by city and product line.
Next, on the Detail page, under the Drillthrough option, add City column as the drill through field.
Finally, set Keep all filters to On on the Detail page, so that it can preserve all the filters from the Sales page.

You are a data analyst at a company that uses Power BI. The company has 12 departments. You have created a Power BI report that shows data for the organization's staff and training from the HR dataset. You have been asked to create the same report for each department. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. A. Create a dataset for each department, copy the report, and use the report with the department dataset. B. Create a workspace for each department and add the report to the workspace C. Create a URL for each department to filter the report by department. D. Add a parameter to the report.

C. Create a URL for each department to filter the report by department. D. Add a parameter to the report. You can add a parameter to a report to make the report dynamic. Dynamic reports are valuable, because a single report can be used for multiple purposes. By using parameters, you can reuse the same report for all departments. You can also create a URL using a parameter that filters the report. You can specify the department in the QueryString for the URL and the report will show the data for the department. You can simply create a separate URL for each department.

You create a Power BI report containing a corrplot R visual for a dataset that has one million rows of sales data. You publish the report to the Power BI service. Users can only see some of the sales data and an error is displayed. You need to identify the root cause of this issue. What is preventing all the data from being displayed? Choose the correct answer A. Corrplot is not supported in Powerbi.com. B. The visual has too many rows. C. The data rows are unique. D. The report has been published in an app.

B. The visual has too many rows. The visual has too many rows. R visuals are limited to 150,000 rows. If there are more than 150,000 rows, only the top 150,000 rows are displayed and a message is displayed on the image. R aggregates similar data automatically, but there must still be fewer than 150,000 data points for the R visual to display data. If the data is unique, it will be displayed for R visuals. R visuals group data by default, and duplicate rows are not displayed.

You create a report with Power BI Desktop. You are tasked with distributing the report to both internal and external recipients in your organization. The report has the following requirements: * To be accessible from IOS and Android mobile devices * To maximize branding and other look and feel aspects You need to select a distribution option for the report. Which distribution option should you use? A. Share a workspace that includes the report. B. Share the report from Power BI Service. C. Publish to web and use embed code. D. Package content and publish an app.

D. Package content and publish an app. You should first create an app using Power BI Service. Then, use the Add Content option to add the Power BI report and any other content you need, such as additional reports or dashboards. Once you have your app completed, you publish the app to the intended audience; both internal and external to your organization. This also supports the requirements of being able to access the report from mobile devices as well as maximizing control over the branding and other look and feel aspects of the report.

You create a Power BI dataset and report for a multinational organization. You configure row-level security (RLS) in the data model. Users are restricted to accessing rows for their own country only. You should follow best practices for managing security. You create roles for each country. You add a DAX Filter expression for each role in the country table. You add the Azure AD security group for the country to each role. A new user starts in Country A. You need to ensure that the user can only view data for Country A. What should you do? A. Manage roles in Power BI Desktop and change the DAX filter expression on the role for Country A. B. Change Access in the Power BI workspace and add the user's email address to the Member role. C. Add the user to the Azure AD security group for Country A. D. Edit Security on the dataset in Power BI service and add the user's email address to the role for Country A.

C. Add the user to the Azure AD security group for Country A. You should add the user to the Azure AD security group for Country A. You have configured the row-level security (RLS) groups to control the membership of each role. You should therefore add and remove users from roles by changing their membership of Azure AD security groups.

You are building 20 Power BI reports from 20 data files. Each report requires you to select 10 date fields. On the report visual, each date field should appear as a whole date and not be broken down into granular parts such as Year, Quarter, Month and Day. You need to configure Power BI to turn off the Date Hierarchy option for your date fields. What should you configure? A. The data source settings B. The regional settings C. The Data Load option D. The report settings

C. The Data Load option You should configure the Data Load option. You should select the Auto date/time option to turn off the automatic inclusion of Date Hierarchy on all date fields. This option is on by default, both at the Global and Current File level because there are Time intelligence and drill down type features that depend on this option being turned on. Depending on your needs, you can choose between Global and Current File to turn on or off the Auto date/time option. If you change this option at the Global level, it would impact all reports you create. However, if you change this option at the Current File level, it would only impact the report you are currently building.

You create a Power BI report with a very large dataset. You want to improve the performance of the dataset refresh by using incremental refresh. For the following statement, select True if the statement is true. Otherwise, select False. "The incremental refresh feature should only be used on data sources that support query folding. " A. True B. False

A. True The incremental refresh feature should only be used on data sources and queries that support query folding. If query folding is not supported, the incremental refresh feature will pull all of the data multiple times.

You create a Power BI report with a very large dataset. You want to improve the performance of the dataset refresh by using incremental refresh. For the following statement, select True if the statement is true. Otherwise, select False. "Two PowerQuery parameters named RangeStart and RangeEnd are required for incremental refresh. " A. True B. False

A. True For incremental refresh, the datasets are filtered by two date/time parameters in PowerQuery. These parameters are named RangeStart and RangeEnd.

You create a Power BI report with a very large dataset. You want to improve the performance of the dataset refresh by using incremental refresh. For the following statement, select True if the statement is true. Otherwise, select False. "A date/time field is required on a table in the dataset " A. True B. False

A. True You need a date/time field to specify how the filter will return the incremental record changes. Without a date/time field, you cannot use incremental refresh.

You import the the Orders table in Power BI, which has some null values in the Order Value column. Select the correct M query expression you would use to replace null values with a 0 in Power Query. A. "=Table.ReplaceValue(Orders, null, 0, {"Order Value"})" B. "=Table.ReplaceValue("Order Value", null, 0, {Orders})" C. "=Table.ReplaceValue("Order Value", null, Replacer.ReplaceValue, {Orders})" D. "=Table.ReplaceValue(Orders, null, 0, Replacer.ReplaceValue, {"Order Value"})"

D. "=Table.ReplaceValue(Orders, null, 0, Replacer.ReplaceValue, {"Order Value"})"

You have created a Power BI dataset and need to create multiple reports. What is a benefit of using a Power BI dataset as a data source for multiple reports compared to each report having a separate dataset A. It increases the number of scheduled refreshes that can be configured for the Power BI dataset B. It prevents sensitive data from being shared with report consumers C. It increases the speed of the reports and visuals connected to the Power BI datasets D. It reduces the number of datasets, refreshes and storage requirements in the Power BI service

D. It reduces the number of datasets, refreshes and storage requirements in the Power BI service

You have a Power BI model that contains a table named Person. Person contains a whole number column named Age. You need to write a DAX measure that finds the middle value in the range of Age values. What formula should you use? A. MEDIAN('Person'[Age]) B. AVERAGE('Person'[Age]) C. RANK.EQ('Person'[Age], 'Person'[Age]) D. STDEV.P('Person'[Age])

A. MEDIAN('Person'[Age])

You are creating a report in Power BI Desktop by using a dataset that contains sales data. You need to create a measure that always provides the value of the total sales for the year 2022, regardless of which year is selected in any visual in the same report. Which DAX function should you use in combination with the SUM function to override the context and provide the result? A. SUMX B. CALCULATE C. IGNORE D. FILTER

B. CALCULATE

What are the building blocks of Power BI? A. Tiles, dashboards, databases, mobile devices B. Visual Studio, C#, and JSON files C. Datasets, Visualizations, Reports, Dashboards, and Tiles

C. Datasets, Visualizations, Reports, Dashboards, and Tiles

You have the following Power Query M formula that generates a range of dates =List.Dates(#date(2020,05,31),365,#duration(1,0,0,0)) What is the resulting date range? A. A list of days ending on May 31,2020 and starting 365 days later B. A list of days starting on May 31,2020 and ending 365 days later C. A list of months starting in May 2020 and ending 12 months later D. A list of months ending in May 2020 and starting 12 months earlier

B. A list of days starting on May 31,2020 and ending 365 days later

You plan to create a report in Power BI Desktop that will display sales opportunities by five sales stages, including lead, prospect, qualified, committed, and transacted. You need to identify the type of visualization that will display a linear process with sequentially connected stages, with one stage transitioning to the next. What visualization should you use? A. Slicer B. Slicer C. Tree Map D. Funnel

D. Funnel

You create a report to help sales users understand their data. You need to use appropriate visualization to meet the requirements of the sales team as mentioned below. Identify the correct type of visualization that can be used to identify outliers in customers with sales opportunities A. Treemap B. Waterfall Chart C. KPI Visual D. Scatter Plot

D. Scatter Plot Scatter Plots are ideal for identifying outliers because they display individual data points across two variables.

What does XMLA stand for?

Extensible Markup Language for Analysis

What is an XMLA Endpoint in Power BI?

An XMLA Endpoint is a web service that allows direct access to Power BI datasets using the XMLA protocol, enabling querying, management, and advanced data modeling.

What are the two access modes for XMLA Endpoints?

.Read-only mode - Allows querying Power BI datasets. Read/Write mode - Allows modifying datasets, including schema changes and partition management.

What does DAX stand for?

DAX (Data Analysis Expressions) and MD

What does MDX stand for?

MDX (Multidimensional Expressions).

What kind of database technology does XMLA Endpoints work with in Power BI?

Tabular model databases based on Azure Analysis Services.

Which function in Power BI (DAX) is used to shift a date or date range forward or backward by a specified number of intervals, such as days, months, quarters, or years. It is commonly used in time intelligence calculations, such as comparing sales from the previous period or forecasting future trends. It only works with columns containing continuous dates. A. PARALLELPERIOD B. DATEADD C. SAMEPERIODLASTYEAR

B. DATEADD Note: it’s useful when looking at rolling time periods.

Which function shifts the date context by a specified number of whole periods (days, months, quarters, or years) and returns the entire shifted period? A. PARALLELPERIOD B. DATEADD C. SAMEPERIODLASTYEAR

A. PARALLELPERIOD

Which function returns the same period from the previous year based on the current date context, maintaining the exact range of dates from one year earlier. If you have a sales report and the current selection includes January 1-31, 2024, this measure will return sales for January 1-31, 2023. A. PARALLELPERIOD B. DATEADD C. SAMEPERIODLASTYEAR

C. SAMEPERIODLASTYEAR

A ___________ is a visual element that users can click to trigger an action. They can have text, icons, or images and can be formatted to fit the report’s design. However, on their own, they do not perform any action—they need to be assigned an action.

Buttons

What is the key difference between a button and a bookmark?

A button is a clickable action, such as going to the next page. A bookmark is a saved view. You can create a button to toggle between bookmark views.