DP-750試験問題はグローバルなものであるとMicrosoft誇らしく言えます。 したがって、どんな種類のDP-750テストトレントを求めても、当社のアフターサービスサービススタッフは、最も専門的な方法でDP-750練習問題の問題を解決するお手伝いをします。 DP-750のImplementing Data Engineering Solutions Using Azure Databricks学習ツールを目指しているお客様は世界中のさまざまな国から来ており、間違いなく時間差があるため、DP-750トレーニングガイドで1日24時間、7日間、思いやりのあるJpexamオンラインアフターサービスを提供します 週に数日、いつでもどこでも気軽にご連絡ください。
| Section | Weight | Objectives |
|---|---|---|
| Set up and configure an Azure Databricks environment | 15–20% | - Integrate with Azure services
|
| Secure and govern Unity Catalog objects | 15–20% | - Manage data sharing and permissions
|
| Prepare and process data | 30–35% | - Ingest and transform data
|
| Deploy and maintain data pipelines and workloads | 30–35% | - Build and orchestrate pipelines
|
従来の試験によってJpexam が今年のMicrosoftのDP-750認定試験を予測してもっとも真実に近い問題集を研究し続けます。Jpexamは100%でMicrosoftのDP-750「Implementing Data Engineering Solutions Using Azure Databricks」認定試験に合格するのを保証いたします。
質問 # 84
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains:
A catalog named Finance
A schema named Purchases in the Finance catalog
A table named Transactions in the Purchases schema
You need to ensure that a user named finance_user can query the Transactions table. The solution must follow the principle of least privilege.
Which permission should you grant to finance_user for each object? To answer, drag the appropriate permissions to the correct objects. Each permission may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
The Finance catalog: USE CATALOG
The Purchases schema: USE SCHEMA
The Transactions table: SELECT
質問 # 85
You have an Azure Databricks workspace that contains a job in Lakeflow Jobs named Job1.
Job! runs every hour.
Occasionally, the job run takes longer than one hour to complete. Overlapping runs must be prevented to avoid data corruption.
You need to configure the job scheduling behavior.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
Two settings address the overlapping-run problem:
Concurrent Runs policy set to ' Skip ' (or ' Allow only one concurrent run ' ). When a new scheduled trigger fires while the previous run is still in progress, the new run is skipped rather than starting alongside the ongoing one. This prevents two runs from writing to the same tables at the same time - which is the data corruption risk the question highlights.
Cron-based schedule for the hourly trigger. A cron expression defines the regular execution cadence.
Combined with the concurrency setting, the job runs hourly but never overlaps.
An alternative to ' Skip ' is ' Wait ' (queue the new run), which ensures every scheduled run eventually executes - but for this scenario where overlapping is the primary concern, skipping the missed run is typically preferable to building up a queue of back-to-back executions.
Reference: https://learn.microsoft.com/en-us/azure/databricks/jobs/configure-jobs#concurrent-runs
質問 # 86
You have an Azure Databricks workspace that contains a job in Lakeflow Jobs named Job1. Job1 contains multiple tasks. Some tasks are business-critical, and others are not.
You need to configure alerting so that:
* Failures in non-critical tasks do not send notifications.
* Notifications are sent only for failures in the critical parts of the workflow.
What should trigger a notification?
正解：D
解説：
The notification should be triggered by a task failure and configured only on the business-critical tasks.
Lakeflow Jobs supports notifications at both the overall job level and the individual task level. By attaching failure notifications specifically to the critical tasks, a notification is sent when one of those tasks fails, while failures in non-critical tasks do not generate unnecessary alerts. Microsoft Learn A job-level failure notification is too broad because it evaluates the result of the entire workflow. If a non- critical task causes Job1 to enter a failed state, the job-level notification could be sent even though the failed task was not considered business-critical. Job-success and task-success notifications report successful execution and do not satisfy the failure-alerting requirement.
Task-level failure notifications provide the required granularity and allow the alert configuration to follow the operational importance of each workflow component. If retries are configured, notifications can also be muted until the final retry to prevent repeated alerts for temporary failures. Therefore, task failure is the correct notification trigger.
質問 # 87
You have an Azure Databricks workspace.
Users report that a Databricks notebook that runs each day takes longer than expected to run.
When reading the Directed Acyclic Graph (DAG), you discover the following issues concerning the Apache Spark stage:
* Most tasks in the stage finish quickly.
* A few tasks in the stage run more slowly.
* The CPU is underutilized at the end of the stage.
* The slow tasks process many more input records.
* The stage is blocked while it waits for the few slow tasks.
What is the root cause of the issues?
正解：B
解説：
The symptoms indicate data skew. Spark partitions the stage's work into tasks, but a few partitions contain substantially more records than the others. Tasks processing the smaller partitions finish quickly, leaving the cluster underutilized while the stage waits for the oversized partitions. Caching would concern whether reused data is stored in memory and does not inherently explain an uneven distribution of input records. Shuffling transfers data between executors and can be expensive, but the decisive evidence is that only a few tasks process far more records. Spilling occurs when an executor cannot keep intermediate data in memory and writes it to disk; the scenario does not identify high spill volumes. Examining per-task input sizes in the Spark UI would confirm the skewed partition distribution.
質問 # 88
Note: This section contains one or more sets of questions with the same scenario and problem. Each question presents a unique solution to the problem. You must determine whether the solution meets the stated goals. More than one solution in the set might solve the problem. It is also possible that none of the solutions in the set solve the problem.
After you answer a question in this section, you will NOT be able to return. As a result, these questions do not appear on the Review Screen.
You have an Azure Databricks workspace named Workspace1 that contains a lakehouse and is enabled for Unity Catalog.
You have a connection to a Microsoft SQL Server database named DB1.
You need to expose the schemas and tables of DB1 to meet the following requirements:
- The schemas and tables can be queried in Databricks.
- The schemas and tables appear alongside other Unity Catalog objects.
- The data is NOT copied into Databricks-managed storage.
Solution: You create a new native catalog in Unity Catalog.
Does this meet the goal?
正解：A
解説：
Correct:
* You create a foreign catalog in Catalog Explorer.
You should create a Foreign Catalog using Lakehouse Federation.
Data Copying: Lakehouse Federation queries data directly in the source SQL Server without moving or copying it.
Seamless Integration: The database schemas and tables appear right inside Unity Catalog alongside your other data objects.Real-time Access: It provides immediate access to live SQL Server data.
Incorrect:
* You create a Databricks access connector.
* You create a Lakeflow Connect pipeline and connect it to DB1.
Data Copying: Lakeflow Connect is an ingestion tool that physically replicates and copies data into Databricks-managed storage (Delta tables).
Storage Costs: It violates your requirement to keep data out of Databricks storage.
* You create a new native catalog in Unity Catalog.
Note:
To expose the external SQL Server database in Unity Catalog without copying the data, you must use Lakehouse Federation.
Here are the step-by-step actions you need to take:
1. Create a Connection
Create a securable object in Unity Catalog that specifies the path and credentials to access the SQL Server database.
Go to Catalog Explorer or use SQL.
Select External Data > Connections.
Create a connection using the SQL Server connection details (URL, host, port, and database credentials).
*-> 2. Create a Foreign Catalog
Create a specific type of catalog in Unity Catalog that mirrors the external database.
Use the CREATE FOREIGN CATALOG SQL command or the Catalog Explorer UI.
Link this foreign catalog directly to the connection you created in step 1.
3. Query the DataOnce the foreign catalog is created, Unity Catalog automatically syncs the schemas and tables from SQL Server.
Reference:
https://docs.databricks.com/gcp/en/database-objects/
質問 # 89
......
DP-750認定を迅速に取得するために、Jpexam人々は多くのDP-750学習教材を購入しましたが、これらの教材は適切ではなく、助けにもならないこともわかっています。 適切なDP-750テストガイドも見つからない場合は、DP-750学習資料を使用することをお勧めします。 当社の製品は問題の解決に役立つため、DP-750の最新の質問を購入して実践することを決定しても、決して失望させません。 また、DP-750試験問題のImplementing Data Engineering Solutions Using Azure Databricks合格率は99％〜100％です。
DP-750テスト問題集: https://www.jpexam.com/DP-750_exam.html