You need to design a semantic model for the customer satisfaction report.
Which data source authentication method and mode should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:

For the semantic model design required for the customer satisfaction report, the choices for data source authentication method and mode should be made based on security and performance considerations as per the case study provided.
Authentication method: The data should be accessed securely, and given that row-level security (RLS) is required for users executing T-SQL queries, you should use an authentication method that supports RLS.
Service principal authentication is suitable for automated and secure access to the data, especially when the access needs to be controlled programmatically and is not tied to a specific user ' s credentials.
Mode: The report needs to show data as soon as it is updated in the data store, and it should only contain data from the current and previous year. DirectQuery mode allows for real-time reporting without importing data into the model, thus meeting the need for up-to-date data. It also allows for RLS to be implemented and enforced at the data source level, providing the necessary security measures.
Based on these considerations, the selections should be:
Authentication method: Service principal authentication
Mode: DirectQuery

Comment: *

Name: *

Email: *

Verification: *

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD).
Which two actions should you include in the process? Each correct answer presents part of the solution.
NOTE: Each correct answer is worth one point.

• A.Update the effective end date of rows when the non-key attribute values have changed.
• B.Update rows when the non-key attributes have changed.
• C.Insert new records when the natural key is a new value in the table.
• D.Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.

Comment: *

Name: *

Email: *

Verification: *

You plan to use Fabric to store data.
You need to create a data store that supports the following:
- Writing data by using T-SQL
- Multi-table transactions
- Dynamic data masking
Which type of data store should you create?

• A.warehouse
• B.lakehouse
• C.KQL database
• D.semantic model

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric tenant that contains a workspace named Workspace1. Workspace1 contains a lakehouse named Lakehouse1 and a warehouse named Warehouse1.
You need to create a new table in Warehouse1 named POSCustomers by querying the customer table in Lakehouse1.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow1 has a query that returns 2.000 rows. You view the query in Power Query as shown in the following exhibit.

What can you identify about the pickupLongitude column?

• A.The column has duplicate values.
• B.All the table rows are profiled.
• C.The column has missing values.
• D.There are 935 values that occur only once.

Comment: *

Name: *

Email: *

Verification: *