Question 71

You have a Fabric tenant that contains a workspace named Workspace1 and a user named User1. User1 is assigned the Contributor role for Workspace1.
You plan to configure Workspace1 to use an Azure DevOps repository for version control.
You need to ensure that User1 can commit items to the repository.
Which two settings should you enable for User1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
  • Question 72

    What should you use to implement calculation groups for the Research division semantic models?
  • Question 73

    You have a Fabric tenant.
    You are creating a Fabric Data Factory pipeline.
    You have a stored procedure that returns the number of active customers and their average sales for the current month.
    You need to add an activity that will execute the stored procedure in a warehouse. The returned values must be available to the downstream activities of the pipeline.
    Which type of activity should you add?
  • Question 74

    You have a Fabric tenant that contains a lakehouse named Lakehouse1. Lakehouse1 contains a table named Nyctaxi_raw. Nyctaxi_raw contains the following columns.

    You create a Fabric notebook and attach it to lakehouse1.
    You need to use PySpark code to transform the dat
    a. The solution must meet the following requirements:
    * Add a column named pickupDate that will contain only the date portion of pickupDateTime.
    * Filter the DataFrame to include only rows where fareAmount is a positive number that is less than 100.
    How should you complete the code? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

    Question 75

    You have a Fabric tenant that contains a lakehouse named Lakehouse1.
    You need to prevent new tables added to Lakehouse1 from being added automatically to the default semantic model of the lakehouse.
    What should you configure? (5)