Question 1

In Power Query Editor, you have a query named Sales Data that contains the following columns.

You need to create two queries named Product Dimension and Sales Fact based on the Sales Data query. The solution must minimize maintenance effort and the site of the semantic model. Which two actions should you perform? Each correct answer presents part of the solution. NOTE Each correct selection is worth one point.

Options :

A : Disable the load for the Sales Fact query.

B : Reference the Sales Data query to create the new queries.

C : Clear Include in report refresh for the Sales Data query.

D : Disable the load for the sales Data query.

E : Duplicate the Sates Data query to create the new queries.

Answer: B,C

Question 2

You publish a semantic model to the Power Bl service. The semantic model contains a connection to an onpremises Microsoft SQL Server database. You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway. You confirm the following with the administrator of the gateway: • You have the appropriate permissions to use the gateway. • The data source was created on the gateway. • The gateway has a status of Running. What is the most likely reason the gateway is unavailable?

Options :

A : The server name in the PBIX file does not match the data source name in the gateway.

B : The type of data source is not supported by the on-premises data gateway.

C : The data source is configured to use single sign-on (SSO).

D : The credentials for the data source are invalid.

Answer: A

Question 3

You have a Power Bl model that contains two tables named Population and Date. The Population table contains two columns named Population Amount and Date Key. DateKey contains date values that represent the first day of a year and are used to create a many-to The Power Bl model contains two measures that have the following definitions. Total Population = Sum ('Population'[Population Amount]) 2023 Population = CALCULATE ([Total Population]"Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show?

Options :

A : one row per year that contains blank values for every year except 2023

B : one row per date that contains the population value for the corresponding year repeated in each row

C : a single row for the year 2023 that contains the related population value

D : one row per year that contains the same value repeated for each year

Answer: C

Question 4

You have sales data in a star schema that contains four tables named Sales, Customer, Date, and Product. The Sales table contains purchase and ship dates. Most often, you will use the purchase date to analyze the data, but you will analyze the data by both dates independently and together. You need to design an imported dataset to support the analysis. The solution must minimize the model size and the number of queries against the data source. Which data modeling design should you use?

Options :

A : Use the Auto Date/Time functionality in Microsoft Power BI and do NOT import the Date table.

B : Duplicate the Date query in Power Query and use active relationships between both Date tables.

C : On the Date table, use a reference query in Power Query and create active relationships between Sales and both Date tables in the modeling view.

D : Create an active relationship between Sales and Date for the purchase date and an inactive relationship for the ship date.

Answer: D

Question 5

You have a Power BI dashboard that displays different visualizations of company sales. You enable Q&A on the dashboard. You need to provide users with sample questions that they can ask when using Q&A. Which settings should you modify from the Power BI Settings?

Options :

A : Subscriptions

B : Dashboards

C : Datasets

D : Workbooks

Answer: C

Confidently Practice Online with Free PL-300 Exam Cram

Buying Options: