Microsoft PL-300 Exam Questions Instant Access

Question 1

You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?

ACreate a new workspace, copy the datasets and reports, and add the HR managers as members of the workspace.

BPublish the reports to a different workspace other than the one hosting the datasets.

CPublish the reports in an app and grant the HR managers access permission.

DAdd the HR managers as members of the existing workspace that hosts the reports and the datasets.

Answer : C

Note: Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

Question 2

You have a Power B1 semantic model that contains tour queries named Query 1, Query2, Query3, and Query4, Query1 loads customer data Into the model and is referenced by the other three queries. You discover that data refresh for the model is slow.

You need to improve the data refresh time. The solution must minimi2e costs. What should you do?

ARun the Table. buffer function in Query 1.

BFrom the Power B1 Admin portal. Increase the Capacity settings.

CReconfigure Query1 as a dataflow entity.

DDuplicate Query1 to all the other queries.

Answer : C

Question 3

You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting.

What should you do?

AFrom Power Bl Desktop, customize the current theme,

BFrom power Bl Desktop, use a built in report theme.

CCreate a theme as a JSON file and import the theme into Power Bl Desktop.

DCreate a theme as a PBIVlZ file and import the theme into Power Bl Desktop.

Answer : C

Question 4

You use Power BI Desktop to open a PBIX file that contains a Microsoft Excel data source.

You attempt to refresh the data and receive the following error message.

Expression.Error: The Colum 'cost' of the table wasn't found.

What is a possible cause of the error?

AThe Cost column was renamed in the data source.

BThe data in the Cost column cannot be converted into the target data type.

CThe privacy level of the data source does not allow combining the data with other data sources.

DThe source file was moved to a new location.

Answer : A

Question 5

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?

AMerge tables by using Power Query.

BHide unused columns in the model.

CSplit the model into multiple models.

DTranspose.

Answer : A

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.

When you have one or more columns that you'd like to add to another query, you merge the queries.

Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression.

CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data

Question 6

You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.

You need to ensure that the users will see the current data when they view the dashboard.

How should you configure the connection to the data source?

ADeploy an on-premises data gateway (personal mode). Import the data by using the Import Data Connectivity mode.

BDeploy an on-premises data gateway. Import the data by using the Import Data Connectivity mode.

CDeploy an on-premises data gateway. Import the data by using the DirectQuery Data Connectivity mode.

DDeploy an on-premises data gateway (personal mode). Import the data by using the DirectQuery Data Connectivity mode.

Answer : D

Question 7

You have a CSV file that contains user complaints. The file contains a column named Logged logged contains the date and time each complaint occurred. The data in Logged is m the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

ACreate a column by example that starts with 2018-12-31.

BCreate a column by example that starts with 2018-12-31 and set the data type of the new column to Date

CApply the parse function from the Date transformations options to the Logged column.

DAdd a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number.

Answer : A

Microsoft Power BI Data Analyst PL-300 Exam Questions