Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric tenant that contains a semantic model named Model1.

You discover that the following query performs slowly against Model1.

You need to reduce the execution time of the query.

Solution: You replace line 4 by using the following code:

Does this meet the goal?

A.

Yes

B.

No

You have a Fabric workspace named Workspace1 and an Azure SQL database.

You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join The solution must minimize development effort. What should you do?

A.

Append the queries by using fuzzy matching.

B.

Merge the queries by using fuzzy matching.

C.

Append the queries by using a lookup table.

D.

Merge the queries by using a lookup table.

You are the administrator of a Fabric workspace that contains a lakehouse named Lakehouse1. Lakehouse1 contains the following tables:

• Table1: A Delta table created by using a shortcut

• Table2: An external table created by using Spark

• Table3: A managed table

You plan to connect to Lakehouse1 by using its SQL endpoint. What will you be able to do after connecting to Lakehouse1?

A.

ReadTable3.

B.

Update the data Table3.

C.

ReadTable2.

D.

Update the data in Table1.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Fabric tenant that contains a semantic model named Model1.

You discover that the following query performs slowly against Model1.

You need to reduce the execution time of the query.

Solution: You replace line 4 by using the following code:

Does this meet the goal?

A.

Yes

B.

No

You have a Fabric notebook that has the Python code and output shown in the following exhibit.

Which type of analytics are you performing?

A.

predictive

B.

descriptive

C.

prescriptive

D.

diagnostic

You have a Microsoft Power Bl report named Report1 that uses a Fabric semantic model.

Users discover that Report1 renders slowly.

You open Performance analyzer and identify that a visual named Orders By Date is the slowest to render. The duration breakdown for Orders By Date is shown in the following table.

What will provide the greatest reduction in the rendering duration of Report1?

A.

Change the visual type of Orders By Dale.

B.

Enable automatic page refresh.

C.

Optimize the DAX query of Orders By Date by using DAX Studio.

D.

Reduce the number of visuals in Report1.

You have a Fabric tenant that contains a warehouse named Warehouse!. Warehousel contains two schemas name schemal and schema2 and a table named schemal.city.

You need to make a copy of schemal.city in schema2. The solution must minimize the copying of data.

Which T-SQL statement should you run?

A.

INSERT INTO schema2.city SELECT * FROM schemal.city;

B.

CREATE TABLE schema2.city AS CLONE OF schemal.city;

C.

CREATE TABLE schema2.city AS SELECT * FROM schemal.city;

D.

SELECT * INTO schema2.eity FROM schemal.city;

You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1. Dataflow1 contains a query that returns the data shown in the following exhibit.

You need to transform the date columns into attribute-value pairs, where columns become rows.

You select the VendorlD column.

Which transformation should you select from the context menu of the VendorlD column?

A.

Group by

B.

Unpivot columns

C.

Unpivot other columns

D.

Split column

E.

Remove other columns

You have a Fabric tenant that contains a semantic model. The model contains data about retail stores.

You need to write a DAX query that will be executed by using the XMLA endpoint. The query must return the total amount of sales from the same period last year.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Which type of data store should you recommend in the AnalyticsPOC workspace?

A.

a data lake

B.

a warehouse

C.

a lakehouse

D.

an external Hive metaStore