Question 6

You have a Fabric tenant that contains a machine learning model registered in a Fabric workspace. You need to use the model to generate predictions by using the predict function in a fabric notebook. Which two languages can you use to perform model scoring? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
  • Question 7

    You have a Fabric tenant that contains a new semantic model in OneLake.
    You use a Fabric notebook to read the data into a Spark DataFrame.
    You need to evaluate the data to calculate the min, max, mean, and standard deviation values for all the string and numeric columns.
    Solution: You use the following PySpark expression:
    df.show()
    Does this meet the goal?
  • Question 8

    You have a Fabric tenant that contains a warehouse named Warehouse1. Warehouse1 contains three schemas named schemaA, schemaB. and schemaC You need to ensure that a user named User1 can truncate tables in schemaA only.
    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.

    Question 9

    You have a Fabric tenant that uses a Microsoft tower Bl Premium capacity. You need to enable scale-out for a semantic model. What should you do first?
  • Question 10

    You have a Fabric workspace named Workspace 1 that contains a dataflow named Dataflow1. Dataflow! 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?