Question 740 A job is configured to start when a UC source table is updated, but the business needs to process only rows where status=approved. Which separation is sound? Assume the trigger only fires for approved status values automatically Use a table update trigger as if it supported status=approved row predicates Delete nonapproved records from the source table to control the trigger Use the table update trigger to start the job and filter approved rows in the task Explanation Correct Answer D:The table update event indicates new table activity; the notebook transformation enforces business row selection. Incorrect Answers A:An update trigger is not a business-row predicate for the entire table. B:Table update events indicate table changes; they do not replace the filter logic inside the task. C:Deleting source records is unnecessary and damages data fidelity.
Question 741 A file arrival trigger is configured, but the job run cannot read the monitored external location. Which issue should be investigated first? Grant the caller job run permission but never verify storage access for the monitored path Only whether the job DAG contains more than two tasks The effective storage and Unity Catalog permissions of the trigger and run identities Only the string length of the trigger name Explanation Correct Answer C:An input event cannot compensate for missing authorization to access the monitored and processed data. Incorrect Answers A:Permission to start a job does not provide the file trigger or run identity with its needed external-location or volume access. B:The count of tasks does not explain storage authorization failure. D:Trigger naming does not determine location privileges.
Question 742 A workflow starts as soon as any object lands in an incoming prefix, but the supplier writes five related files over ten minutes. What could prevent processing an incomplete batch? Assume every first file represents the finished five-file batch Immediately publish the first file as the full batch Change the job from Python to SQL without validating the supplier’s five-file batch boundary Add an explicit source-completeness contract or marker validation task before transformation Explanation Correct Answer D:A file trigger detects arrivals but cannot by itself guarantee that a multi-file business batch is complete. Incorrect Answers A:The source contract explicitly describes additional files arriving later. B:Publishing before completion violates the completeness requirement. C:The programming language does not indicate whether the upstream delivery is complete; explicit markers or completeness checks are required.
Question 743 A business requires a report to run at 09:00 in a local time zone that observes daylight saving changes. What should an engineer inspect when setting a cron schedule? Use only a fixed UTC timestamp for every calendar day and ignore regional daylight-saving shifts Choose the scheduling time zone based solely on the cloud region where the compute runs Use a fixed UTC offset instead of the selected local time zone for every month The selected time zone and daylight saving effects on the intended local execution time Explanation Correct Answer D:Time-zone-aware scheduling must be tested against local civil-time shifts to maintain the business expectation. Incorrect Answers A:A fixed UTC time does not continue representing 09:00 local time through DST transitions. B:Compute hosting geography does not necessarily match the report recipient’s required local wall-clock time zone. C:A fixed offset can shift the intended 09:00 local execution when daylight saving changes the local UTC offset.
Question 744 A workflow normally runs at midnight, but an operator starts it manually at 23:59 while the previous run is still active. What control prevents unsafe concurrent writes? Grant all team members the ability to force-start runs Assume manually started runs bypass job concurrency controls safely Clear the target table before every invocation Enforce an appropriate maximum concurrent runs together with idempotent output logic Explanation Correct Answer D:Concurrency restrictions limit overlapping executions, and idempotent writes help protect retry or overlap behavior. Incorrect Answers A:More operators do not solve the underlying concurrent-writing risk. B:A manual invocation does not make two conflicting output writers harmless. C:Truncation can cause data loss when both executions are operating.
Question 745 A task writes an append-only target and then crashes before recording completion. The job retries the task and inserts the same events again. What is the root integrity defect? Increase the retry count while keeping unconditional append writes The job has too many output column descriptions The task has non-idempotent side effects under at-least-once execution Delta transactions can never atomically commit writes Explanation Correct Answer C:A repeated append without event identity or deduplication can duplicate already committed events. Incorrect Answers A:More retries amplify duplicated side effects when the first attempt wrote events before reporting failure. B:Metadata descriptions have no bearing on duplicate logical writes. D:Delta supports atomic commits; the issue is a subsequent valid retry repeating the logical event.
Question 746 A five-task job has a diagnostic notebook task that engineers want to test independently with current inputs. Which UI action can limit the manual run to selected tasks? Run now with different settings and select the intended tasks Change the default job schedule to every minute Delete all other tasks from the saved job definition Clear the entire job history first Explanation Correct Answer A:The manual-run settings can scope execution to selected tasks rather than launching the whole graph unnecessarily. Incorrect Answers B:More frequent runs do not isolate the diagnostic task. C:Deleting tasks permanently changes a production workflow for a temporary test. D:History deletion is unrelated to task selection.
Question 747 A Python script task takes positional arguments, and a job parameter named region is declared. The task does not receive region automatically. What is required? Grant SELECT on unrelated metadata tables Declare the job-level region parameter but omit its reference in the Python-script positional argument array Create a notebook widget and assume the script reads it Explicitly reference the job parameter in the script task's JSON argument array Explanation Correct Answer D:Automatic pushdown is for key-value tasks, while positional-argument tasks must reference parameters explicitly. Incorrect Answers A:Permissions cannot substitute for passing the configured argument. B:A job parameter is not automatically injected as a positional Python argument. The script task must explicitly bind it. C:A Python script launched with positional args does not automatically consume a notebook widget.
Question 748 A Lakeflow Jobs SQL query task fails because its assigned SQL warehouse is unavailable. Which required execution resource should be restored? A new data-sharing recipient A notebook-only cluster attached to a developer session Reassign the notebook's Spark cluster without fixing the SQL task warehouse An appropriate available SQL warehouse for the SQL query task Explanation Correct Answer D:The query task needs SQL execution capacity; a missing warehouse prevents it from running. Incorrect Answers A:Recipients authorize distribution of data, not SQL execution capacity. B:Notebook interactive compute does not replace a SQL query task's warehouse assignment. C:Notebook compute cannot substitute for the unavailable warehouse configured to execute a SQL query task.
Question 749 A single job contains a notebook task and a SQL query task and both require a common business_date input. What avoids separately hard-coding dates in each task? Assume SQL statements read Python widgets automatically Embed today's date in both source files permanently Define a job parameter and reference it with each task's supported parameter syntax Use the last-modified timestamp of the workspace folder Explanation Correct Answer C:A shared job-level value can feed multiple task types with their respective parameter-consumption mechanisms. Incorrect Answers A:The SQL task uses its own supported parameter syntax rather than another task's widget state. B:Hard-coded dates will be incorrect for backfill and future scheduled executions. D:Folder edit times are not the intended business-date argument.
Question 750 A multi-task workflow has three compatible Spark notebook tasks run sequentially and wants to avoid starting a separate cluster for each task. What design is relevant? Configure a shared job cluster for the tasks when supported Copy all source data between clusters after each task Replace each Spark task with an email task Use three unrelated interactive user clusters permanently Explanation Correct Answer A:A shared job cluster can serve multiple tasks within the job run instead of provisioning separate task compute for each. Incorrect Answers B:Unnecessary copies do not solve cluster startup overhead. C:Email notifications do not execute Spark transformations. D:Persistent development compute creates idle cost and weak operational isolation.