Question 380
For Riverbend Automotive, an operational assessment affecting vehicle engineering and customer services uncovers: An initial SQL copy is rerun after failure and a naive CREATE TABLE command errors because the destination already exists. The team reports that the correction is complete. Which result BEST verifies that the specific issue was resolved?
Explanation
Correct Answer
The controlled rerun yields the desired table contents without leaving a partially duplicated destination. The observation provides evidence that the proposed fix (Choose the supported CREATE OR REPLACE TABLE or appropriately guarded creation workflow based on retention needs.) addressed the reported issue (An initial SQL copy is rerun after failure and a naive CREATE TABLE command errors because the destination already exists.) for Riverbend Automotive and its vehicle engineering and customer services. It verifies an observable outcome instead of relying only on a completed task ticket.
Incorrect Answers
Historical rows remain intact and the new daily records are present exactly once. This is suitable evidence for another condition (A batch pipeline needs to write new daily records without overwriting historical rows, but it uses overwrite mode on its entire destination table.) after a different response (Choose an append or keyed merge write matching the intended incremental update contract.). For Riverbend Automotive, it does not prove the required result: The controlled rerun yields the desired table contents without leaving a partially duplicated destination.
Only the initial full load is followed by verified changes in later ingestion cycles. This is suitable evidence for another condition (A supported source database needs managed change-based ingestion but a custom script reloads its entire multi-terabyte table hourly.) after a different response (Use Lakeflow Connect with an eligible incremental or CDC connector and appropriate cursor or log configuration.). For Riverbend Automotive, it does not prove the required result: The controlled rerun yields the desired table contents without leaving a partially duplicated destination.
The created table matches the query's schema and rows without driver-side row iteration. This is suitable evidence for another condition (A scheduled SQL load must derive a destination table from a single query and the team performs row-by-row inserts from a driver process.) after a different response (Use a suitable CREATE TABLE AS SELECT operation for the required initial relational materialization.). For Riverbend Automotive, it does not prove the required result: The controlled rerun yields the desired table contents without leaving a partially duplicated destination.