Free DP-700 Exam Braindumps (page: 3)

Page 3 of 31

You have a Fabric workspace.
You have semi-structured data.
You need to read the data by using T-SQL, KQL, and Apache Spark. The data will only be written by using Spark.
What should you use to store the data?

  1. a lakehouse
  2. an eventhouse
  3. a datamart
  4. a warehouse

Answer(s): A

Explanation:

A lakehouse is the best option for storing semi-structured data when you need to read it using T-SQL, KQL, and Apache Spark. A lakehouse combines the flexibility of a data lake (which can handle semi-structured and unstructured data) with the performance features of a data warehouse. It allows data to be written using Apache Spark and can be queried using different technologies such as T-SQL (for SQL-based querying), KQL (Kusto Query Language for querying), and Apache Spark (for distributed processing). This solution is ideal when dealing with semi-structured data and requiring a versatile querying approach.



You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on- premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

  1. a Dataflow Gen1 dataflow
  2. a data pipeline
  3. a KQL queryset
  4. a notebook

Answer(s): B

Explanation:

To copy data from an on-premises Microsoft SQL Server database (Database1) to a warehouse (Warehouse1) in Microsoft Fabric, the best option is to use a data pipeline. A data pipeline in Fabric allows for the orchestration of data movement, from source to destination, using connectors, transformations, and scheduled workflows. Since the data is being transferred from an on-premises database and requires the use of a data gateway, a data pipeline provides the appropriate framework to facilitate this data movement efficiently and reliably.



You have a Fabric workspace that contains a warehouse named Warehouse1.
You have an on-premises Microsoft SQL Server database named Database1 that is accessed by using an on- premises data gateway.
You need to copy data from Database1 to Warehouse1.
Which item should you use?

  1. an Apache Spark job definition
  2. a data pipeline
  3. a Dataflow Gen1 dataflow
  4. an eventstream

Answer(s): B

Explanation:

To copy data from an on-premises Microsoft SQL Server database (Database1) to a warehouse (Warehouse1) in Fabric, a data pipeline is the most appropriate tool. A data pipeline in Fabric is designed to move data between various data sources and destinations, including on-premises databases like SQL Server, and cloud- based storage like Fabric warehouses. The data pipeline can handle the connection through an on-premises data gateway, which is required to access on-premises data. This solution facilitates the orchestration of data movement and transformations if needed.



You have a Fabric F32 capacity that contains a workspace. The workspace contains a warehouse named DW1 that is modelled by using MD5 hash surrogate keys.
DW1 contains a single fact table that has grown from 200 million rows to 500 million rows during the past year.
You have Microsoft Power BI reports that are based on Direct Lake. The reports show year-over-year values.
Users report that the performance of some of the reports has degraded over time and some visuals show errors.
You need to resolve the performance issues. The solution must meet the following requirements:
Provide the best query performance.
Minimize operational costs.
Which should you do?

  1. Change the MD5 hash to SHA256.
  2. Increase the capacity.
  3. Enable V-Order.
  4. Modify the surrogate keys to use a different data type.
  5. Create views.

Answer(s): B

Explanation:

Correct:
* Increase the capacity.
We need to upgrade the capacity.
Direct Lake in Fabric F32 Capacity supports tables up to 300 million rows. F64 can handle 500 million rows.
Incorrect:
* Change the MD5 hash to SHA256.
* Create views.
* Disable V-Order on the warehouse.
* Enable V-Order.
* Modify the surrogate keys to use a different data type.






Post your Comments and Discuss Microsoft DP-700 exam with other Community members:

DP-700 Exam Discussions & Posts