Question 50
After the approved change, engineers revisit: A BI tool connects using an outdated driver and sees unsupported authentication failures after a platform security update. Which result establishes the intended state?
Explanation
Correct Answer
The updated client establishes an authorized session and runs the same controlled query. This validates the relevant action: Upgrade to a supported Snowflake connector or driver version and configure its approved authentication method. The underlying Snowflake behavior is: Client drivers implement authentication and protocol compatibility, not just SQL formatting.
Incorrect Answers
The pipeline loads representative events with measured latency and manageable operational overhead. This evidence tests a DIFFERENT situation: A data app needs to ingest events from Kafka but engineers build one file per message and a new warehouse COPY for each row. The correction required in this case is: Upgrade to a supported Snowflake connector or driver version and configure its approved authentication method.
The connector's role context and query results remain correct after default-role changes. This evidence tests a DIFFERENT situation: A partner uses an ODBC reporting connector with a role that changes silently after an administrator modifies user defaults. The correction required in this case is: Upgrade to a supported Snowflake connector or driver version and configure its approved authentication method.
Multiple appropriately sized staged files increase effective parallel processing under the chosen warehouse. This evidence tests a DIFFERENT situation: An ingest job loads multi-gigabyte compressed files serially and expects maximum parallelism from the warehouse alone. The correction required in this case is: Upgrade to a supported Snowflake connector or driver version and configure its approved authentication method.