Question 76

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 77

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Fabric tenant that contains a semantic model named Model1.
You discover that the following query performs slowly against Model1.

You need to reduce the execution time of the query.
Solution: You replace line 4 by using the following code:

Does this meet the goal?
  • Question 78

    You have a Fabric tenant that contains a warehouse named WH1. You run the following T-SQL query against WH1.

    For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

    Question 79

    You have a Fabric notebook that has the Python code and output shown in the following exhibit.

    Which type of analytics are you performing?
  • Question 80

    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.explain()
    Does this meet the goal?