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

• A.a warehouse
• B.an external Hive metaStore
• C.a lakehouse
• D.a data lake

Comment: *

Name: *

Email: *

Verification: *

Which syntax should you use in a notebook to ac cess the Research division data for Productlinel?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a warehouse.
You use a dataflow to load a new dataset from OneLake to the warehouse.
You need to add a PowerQuery step to identify the maximum values for the numeric columns.
Which function should you include in the step?

• A.Table.MaxN
• B.Table.Max
• C.Table.Range
• D.Table.Profile

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains a fact table named FactSales that has one billion rows. You run the following T-SQL statement.
CREATE TABLE test.FactSales AS CLONE OF Dbo.FactSales;
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
* A replica of dbo.Sales is created in the test schema by copying the metadata only. - Yes
* Additional schema changes to dbo.FactSales will also apply to test.FactSales. - No
* Additional data changes to dbo.FactSales will also apply to test.FactSales. - No The CREATE TABLE AS CLONE statement creates a copy of an existing table, including its data and any associated data structures, like indexes. Therefore, the statement does not merely copy metadata; it also copies the data. However, subsequent schema changes to the original table do not automatically propagate to the cloned table. Any data changes in the original table after the clone operation will not be reflected in the clone unless explicitly updated.
References =
* CREATE TABLE AS SELECT (CTAS) in SQL Data Warehouse

Comment: *

Name: *

Email: *

Verification: *

You have Fabric tenant.
You need to create a sematic model that delivers fast report rendering, minimizes query latency, and maximizes flexibility for DAX calculations.
Which storage mode should you select?

• A.Direct Lake
• B.Import
• C.Composite Mode
• D.DirectQuery

Comment: *

Name: *

Email: *

Verification: *