DP-700 Practice Test

DP-700 Practice Test practice questions, page 4 of 7, with answer review and explanations.

Question 16

You have a Google Cloud Storage (GCS) container named storage1 that contains the files shown in the following table. You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the shortcuts shown in the following table. You need to read data from all the shortcuts. Which shortcuts will retrieve data from the cache?

  1. Stores only
  2. Products only
  3. Stores and Products only
  4. Products, Stores, and Trips
  5. Trips only
  6. Products and Trips only

Question 17

You have a Fabric workspace named Workspace1 that contains an Apache Spark job definition named Job1. You have an Azure SQL database named Source1 that has public internet access disabled. You need to ensure that Job1 can access the data in Source1. What should you create?

  1. an on-premises data gateway
  2. a managed private endpoint
  3. an integration runtime
  4. a data management gateway

Question 18

You have an Azure Data Lake Storage Gen2 account named storage1 and an Amazon S3 bucket named storage2. You have the Delta Parquet files shown in the following table. You have a Fabric workspace named Workspace1 that has the cache for shortcuts enabled. Workspace1 contains a lakehouse named Lakehouse1. Lakehouse1 has the following shortcuts: A shortcut to ProductFile aliased as Products A shortcut to StoreFile aliased as Stores A shortcut to TripsFile aliased as Trips The data from which shortcuts will be retrieved from the cache?

  1. Trips and Stores only
  2. Products and Store only
  3. Stores only
  4. Products only
  5. Products, Stores, and Trips

Question 19

You have a Fabric workspace named Workspace1 that contains the items shown in the following table. For Model1, the Keep your Direct Lake data up to date option is disabled. You need to configure the execution of the items to meet the following requirements: Notebook1 must execute every weekday at 8:00 AM. Notebook2 must execute when a file is saved to an Azure Blob Storage container. Model1 must refresh when Notebook1 has executed successfully. How should you orchestrate each item? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 20

Your company has a sales department that uses two Fabric workspaces named Workspace1 and Workspace2. The company decides to implement a domain strategy to organize the workspaces. You need to ensure that a user can perform the following tasks: Create a new domain for the sales department. Create two subdomains: one for the east region and one for the west region. Assign Workspace1 to the east region subdomain. Assign Workspace2 to the west region subdomain. The solution must follow the principle of least privilege. Which role should you assign to the user?

  1. workspace Admin
  2. domain admin
  3. domain contributor
  4. Fabric admin