Question 1

Which of the following are key strategies to improve collaboration between analytics engineers and architects in Microsoft Fabric?

Options :

A : Sharing performance metrics and analytics dashboards regularly

B : Limiting access to data models to only one team

C : Avoiding documentation of system changes and updates

D : Using a collaborative platform for code reviews and feedback

Answer: D

Question 2

You have a Fabric workspace that contains an eventstream named EventStreaml. EventStreaml outputs events to a table named Tablel in a lakehouse. The streaming data is souiced from motorway sensors and represents the speed of cars. You need to add a transformation to EventStream1 to average the car speeds. The speeds must be grouped by non-overlapping and contiguous time intervals of one minute. Each event must belong to exactly one window. Which windowing function should you use?

Options :

A : sliding

B : hopping

C : tumbling

D : session

Answer: C

Question 3

Which of the following transformations can be performed using Azure Data Factory?

Options :

A : Data classification

B : Data transformation using mapping data flows

C : Data aggregation

D : Data cleansing

E : Machine learning model training

Answer: B,C,D

Question 4

What is the primary purpose of implementing data masking in Microsoft Fabric?

Options :

A : To ensure compliance with regulatory standards

B : To prevent unauthorized access to sensitive data

C : To optimize data storage efficiency

D : To accelerate data processing

Answer: B

Question 5

Which of the following would be the best practice to optimize query performance in a Microsoft Fabric solution?

Options :

A : Adding unnecessary joins in the query

B : Running all queries as a single large operation

C : Avoiding the use of indexes in frequently queried columns

D : Breaking complex queries into smaller, more manageable subqueries

Answer: D