Free Microsoft DP-600 Exam Questions

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?Script

You have a Fabric tenant named Tenant! that contains a lakehouse named Lakehouse1.You need to add data to Lakehouse1 from a CSV file in an Azure Storage account outside of Fabric. Thesolution must minimize development effort.What should you use to add the data?

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 workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit.

When planning a data analytics environment, what factors should be considered in selecting appropriate data storage solutions? (Select all that apply)