DP-600 Practice Online

You have a Fabric tenant that contains a warehouse named Warehouse!. Warehousel contains two schemas name schemal and schema2 and a table named schemal.city. You need to make a copy of schemal.city in schema2. The solution must minimize the copying of data. Which T-SQL statement should you run?  

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?

You have a Fabric tenant that contains a workspace named Workspace"!. You plan to deploy a semantic model named Model 1 by using the XMLA endpoint. You need to optimize the deployment of Model!. The solution must minimize how long it takes to deploy Modell. What should you do in Workspace1?

You have a Fabric tenant that contains a warehouse. You use a dataflow to load a new dataset from OneLake to the warehouse. You need to add a Power Query step to identify the maximum values for the numeric columns. Which function should you include in the step? 

You have a Fabric tenant that contains a lakehouse named lakehouse1. Lakehouse1 contains a table named Table1. You are creating a new data pipeline. You plan to copy external data to Table1. The schema of the external data changes regularly. You need the copy operation to meet the following requirements: Replace Table1 with the schema of the external data. Replace all the data in Table1 with the rows in the external data. You add a Copy data activity to the pipeline. What should you do for the Copy data activity?