Snowflake SnowPro Specialty Gen AI GES-C01 Practice Test 10
Question 90
At a charitable grant foundation, a Snowflake engineering team is undertaking a grant document review workflow. A business user says 'bookings' but the warehouse has both gross and net booking measures. Budget and operational risk are both material; the archive includes superseded contract amendments; compliance staff need audit evidence. Which decision MOST appropriately balances the requested outcome with production constraints?
- Maintain a governed glossary and test common synonym collisions.
- Disambiguate the business term through the semantic model or request before running a high-stakes metric query.
- Isolate session memory by principal and business object.
- Monitor freshness lag and alert when the service falls behind.
- Keep source authorization and citation validation between retrieval and generation.
Explanation
Correct Answers
A:This establishes the ongoing safety boundary after the immediate correction. It provides protection while the team checks that the response applies the intended definition and discloses its scope. These author-intended interpretations require independent technical review before operational use.
B:This implements the response to the stated failure: An ambiguous metric name can silently select the wrong aggregate. It must be validated using compare accepted synonyms to verified definitions These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
C:This guardrail primarily addresses multi-turn context control and is not the companion intervention the case most urgently requires. The stated issue is a business user says 'bookings' but the warehouse has both gross and net booking measures. These author-intended interpretations require independent technical review before operational use.
D:This guardrail primarily addresses cortex search index refresh and is not the companion intervention the case most urgently requires. The stated issue is a business user says 'bookings' but the warehouse has both gross and net booking measures. These author-intended interpretations require independent technical review before operational use.
E:This guardrail primarily addresses service selection for policy manuals and is not the companion intervention the case most urgently requires. The stated issue is a business user says 'bookings' but the warehouse has both gross and net booking measures. These author-intended interpretations require independent technical review before operational use.
Question 91
At a packaging manufacturer, a Snowflake engineering team is undertaking a product support search interface. Two teams share one document index, but legal documents must remain visible only to authorized employees. Before implementation, knowledge articles update every workday; operators need reliable revision dates. Which first architectural or operating step MOST directly addresses this case?
- Use Cortex Analyst with an approved semantic definition for the relevant finance measures.
- Verify current feature availability, region limits, and preview conditions before designing the rollout.
- Apply access predicates at retrieval time and test search responses under distinct authorized identities.
- Route policy prose to Cortex Search retrieval and governed numeric analysis to Cortex Analyst.
Explanation
Correct Answer
C:The decision addresses the central constraint: two teams share one document index, but legal documents must remain visible only to authorized employees. The most direct next step is to apply access predicates at retrieval time and test search responses under distinct authorized identities. Before changing production, review both: verify row-level document permissions and test cross-team queries under distinct authorized roles.. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:This can be appropriate when a controller asks for regional net revenue while teams keep the definition in governed warehouse tables. It addresses structured revenue question routing, whereas the present limitation is better explained by a shared vector index without proper access filtering can reveal protected text. The target outcome here is that unauthorized identities cannot retrieve or cite restricted documents. These author-intended interpretations require independent technical review before operational use.
B:This can be appropriate when marketing promises that a preview ai feature can be treated as guaranteed in every geographic region. It addresses documented capability boundary, whereas the present limitation is better explained by a shared vector index without proper access filtering can reveal protected text. The target outcome here is that unauthorized identities cannot retrieve or cite restricted documents. These author-intended interpretations require independent technical review before operational use.
D:This can be appropriate when a chat assistant must answer both narrative handbook questions and numeric sales questions from relational tables. It addresses search versus analyst decision, whereas the present limitation is better explained by a shared vector index without proper access filtering can reveal protected text. The target outcome here is that unauthorized identities cannot retrieve or cite restricted documents. These author-intended interpretations require independent technical review before operational use.
Question 92
At a semiconductor equipment maker, a Snowflake engineering team is undertaking a component troubleshooting assistant. Two teams share one document index, but legal documents must remain visible only to authorized employees. The proposed fix is still hypothetical; document titles are duplicated across product revisions, and engineers need verified part-specific guidance. Which TWO checks provide the most decisive evidence before approving a change?
- Compare source update timestamp with indexed retrieval
- Check model signature and environment dependencies
- Inspect search results for the requested policy revision
- Test cross-team queries under distinct authorized roles.
- Verify row-level document permissions
Explanation
Correct Answers
D:This complementary observation tests a different part of the same hypothesis and should be read together with the first check before authorizing change. Expected success would be: unauthorized identities cannot retrieve or cite restricted documents. These author-intended interpretations require independent technical review before operational use.
E:This observation directly tests the case mechanism: A shared vector index without proper access filtering can reveal protected text. In the described setting, it helps determine whether apply access predicates at retrieval time and test search responses under distinct authorized identities. is justified. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:Checking this might help diagnose cortex search index refresh, where a policy portal changes articles hourly while search answers remain a day behind. It is not one of the two most direct checks for the present case because the leading mechanism is a shared vector index without proper access filtering can reveal protected text. These author-intended interpretations require independent technical review before operational use.
B:Checking this might help diagnose model registry decision, where a data-science team has a validated open-source model artifact and wants managed version tracking inside snowflake. It is not one of the two most direct checks for the present case because the leading mechanism is a shared vector index without proper access filtering can reveal protected text. These author-intended interpretations require independent technical review before operational use.
C:Checking this might help diagnose service selection for policy manuals, where a support team needs answers grounded in rapidly changing internal policy passages rather than open-ended model memory. It is not one of the two most direct checks for the present case because the leading mechanism is a shared vector index without proper access filtering can reveal protected text. These author-intended interpretations require independent technical review before operational use.
Question 93
At a health-benefits administrator, a Snowflake engineering team is undertaking a contact-center quality pilot. Two teams share one document index, but legal documents must remain visible only to authorized employees. Diagnosis is disputed because the helpdesk processes sensitive documents; responses must avoid unsupported policy assertions. Which underlying failure mechanism BEST explains the observed limitation?
- Choosing only by parameter count or popularity ignores task fit and runtime constraints.
- An unregistered binary lacks a dependable promotion and rollback trail.
- A shared vector index without proper access filtering can reveal protected text.
- Treating arbitrary container dependencies as an out-of-the-box Cortex SQL model call is an architecture mismatch.
Explanation
Correct Answer
C:This is the causal hypothesis consistent with the observed limitation: two teams share one document index, but legal documents must remain visible only to authorized employees. Confirm it through both verify row-level document permissions and test cross-team queries under distinct authorized roles. before changing the service. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:That mechanism could explain a different case about model endpoint selection, but does not most directly account for this specific symptom: two teams share one document index, but legal documents must remain visible only to authorized employees. Here, the evidence to collect is verify row-level document permissions These author-intended interpretations require independent technical review before operational use.
B:That mechanism could explain a different case about model registry decision, but does not most directly account for this specific symptom: two teams share one document index, but legal documents must remain visible only to authorized employees. Here, the evidence to collect is verify row-level document permissions These author-intended interpretations require independent technical review before operational use.
D:That mechanism could explain a different case about snowpark container services fit, but does not most directly account for this specific symptom: two teams share one document index, but legal documents must remain visible only to authorized employees. Here, the evidence to collect is verify row-level document permissions These author-intended interpretations require independent technical review before operational use.
Question 94
At a hospital-equipment supplier, a Snowflake engineering team is undertaking a document processing migration. Two teams share one document index, but legal documents must remain visible only to authorized employees. The change was trialed on a small dataset; an incorrect number could delay critical replenishment, while thousands of older scanned PDFs have variable layouts. Which acceptance condition BEST demonstrates that the intervention worked?
- Unauthorized identities cannot retrieve or cite restricted documents.
- The answer matches governed finance totals and names the selected measure definition.
- Both pathways return authorized results with consistent model behavior.
- The chosen design is supported in each intended environment or explicitly blocked.
Explanation
Correct Answer
A:This is the observable acceptance condition that would show the intended fix addressed a shared vector index without proper access filtering can reveal protected text. It is stronger than activity counts because it tests the user-facing effect. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
B:This could demonstrate success for structured revenue question routing, but it would not establish resolution of the current issue: two teams share one document index, but legal documents must remain visible only to authorized employees. Validate unauthorized identities cannot retrieve or cite restricted documents. instead. These author-intended interpretations require independent technical review before operational use.
C:This could demonstrate success for sql versus rest invocation, but it would not establish resolution of the current issue: two teams share one document index, but legal documents must remain visible only to authorized employees. Validate unauthorized identities cannot retrieve or cite restricted documents. instead. These author-intended interpretations require independent technical review before operational use.
D:This could demonstrate success for documented capability boundary, but it would not establish resolution of the current issue: two teams share one document index, but legal documents must remain visible only to authorized employees. Validate unauthorized identities cannot retrieve or cite restricted documents. instead. These author-intended interpretations require independent technical review before operational use.
Question 95
At a regional airline services firm, a Snowflake engineering team is undertaking an incident summary assistant. Two teams share one document index, but legal documents must remain visible only to authorized employees. An auditor will inspect the control design; network outages create intermittent retries, and audit leads demand source-grounded conclusions. Which ongoing control MOST directly reduces the original risk?
- Implement least-privilege retrieval and negative access tests.
- Add quotas, circuit breakers, and operational dashboards.
- Monitor freshness lag and alert when the service falls behind.
- Treat index schema changes as versioned application contracts.
Explanation
Correct Answer
A:This retains a specific safeguard against recurrence of a shared vector index without proper access filtering can reveal protected text. It complements the immediate intervention, apply access predicates at retrieval time and test search responses under distinct authorized identities., and allows the team to verify the intended result. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
B:This is a sensible safeguard for inference concurrency planning, but it does not target the concrete exposure in this scenario. The current failure is a shared vector index without proper access filtering can reveal protected text. These author-intended interpretations require independent technical review before operational use.
C:This is a sensible safeguard for cortex search index refresh, but it does not target the concrete exposure in this scenario. The current failure is a shared vector index without proper access filtering can reveal protected text. These author-intended interpretations require independent technical review before operational use.
D:This is a sensible safeguard for cortex search service schema, but it does not target the concrete exposure in this scenario. The current failure is a shared vector index without proper access filtering can reveal protected text. These author-intended interpretations require independent technical review before operational use.
Question 96
At a public transit agency, a Snowflake engineering team is undertaking a fleet operations question-answering tool. Two teams share one document index, but legal documents must remain visible only to authorized employees. Budget and operational risk are both material; the data includes safety incident narratives; changes require accountable signoff. Which decision MOST appropriately balances the requested outcome with production constraints?
- Verify current feature availability, region limits, and preview conditions before designing the rollout. Postpone the critical evidence checks until after a broad release.
- Route policy prose to Cortex Search retrieval and governed numeric analysis to Cortex Analyst. Postpone the critical evidence checks until after a broad release.
- Apply access predicates at retrieval time and test search responses under distinct authorized identities. Then implement least-privilege retrieval and negative access tests.
- Use Cortex Analyst with an approved semantic definition for the relevant finance measures. Postpone the critical evidence checks until after a broad release.
Explanation
Correct Answer
C:This combines a corrective action with a bounded production safeguard, addressing two teams share one document index, but legal documents must remain visible only to authorized employees. Prove the result by checking that unauthorized identities cannot retrieve or cite restricted documents. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:This proposal begins with an intervention for documented capability boundary and postpones evidence that is essential for the current case. Before rollout, the team should apply access predicates at retrieval time and test search responses under distinct authorized identities. These author-intended interpretations require independent technical review before operational use.
B:This proposal begins with an intervention for search versus analyst decision and postpones evidence that is essential for the current case. Before rollout, the team should apply access predicates at retrieval time and test search responses under distinct authorized identities. These author-intended interpretations require independent technical review before operational use.
D:This proposal begins with an intervention for structured revenue question routing and postpones evidence that is essential for the current case. Before rollout, the team should apply access predicates at retrieval time and test search responses under distinct authorized identities. These author-intended interpretations require independent technical review before operational use.
Question 97
At a university research office, a Snowflake engineering team is undertaking a restricted data discovery project. A semantic definition joins order lines to a dimension with duplicate surrogate keys. Before implementation, staff rotate between roles during the academic year; research access differs by grant. Which first architectural or operating step MOST directly addresses this case?
- Correct join cardinality and test representative metrics before exposing text-to-SQL answers.
- Use a supported structured-response contract and validate outputs against an explicit schema.
- Separate deterministic classification invocation from application validation and persistence logic.
- Attach revision identifiers and effective dates to searchable chunks and filter retrieval accordingly.
Explanation
Correct Answer
A:The decision addresses the central constraint: a semantic definition joins order lines to a dimension with duplicate surrogate keys. The most direct next step is to correct join cardinality and test representative metrics before exposing text-to-sql answers. Before changing production, review both: compare row counts before and after joins and reconcile weighted totals against trusted queries.. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
B:This can be appropriate when an integration needs a json object with required fields rather than arbitrary conversational paragraphs. It addresses response structured contract, whereas the present limitation is better explained by fan-out joins silently inflate aggregates even when generated sql is syntactically valid. The target outcome here is that generated queries preserve expected cardinality and reconcile to certified totals. These author-intended interpretations require independent technical review before operational use.
C:This can be appropriate when product owners want to label customer feedback and then store explanations for analysts. It addresses service call versus application logic, whereas the present limitation is better explained by fan-out joins silently inflate aggregates even when generated sql is syntactically valid. The target outcome here is that generated queries preserve expected cardinality and reconcile to certified totals. These author-intended interpretations require independent technical review before operational use.
D:This can be appropriate when a knowledge assistant cites a manual but reports the wrong revision after several versions are indexed. It addresses rag chunk provenance, whereas the present limitation is better explained by fan-out joins silently inflate aggregates even when generated sql is syntactically valid. The target outcome here is that generated queries preserve expected cardinality and reconcile to certified totals. These author-intended interpretations require independent technical review before operational use.
Question 98
At a community-bank technology team, a Snowflake engineering team is undertaking an internal policy assistant pilot. A semantic definition joins order lines to a dimension with duplicate surrogate keys. The proposed fix is still hypothetical; security rejects any unapproved cross-border data processing, and the pilot must serve two departments with different permissions. Which TWO checks provide the most decisive evidence before approving a change?
- Classify representative requests by data type
- Reconcile weighted totals against trusted queries.
- Review the generated SQL for measure definitions and joins
- Measure p95 response time and token cost
- Compare row counts before and after joins
Explanation
Correct Answers
B:This complementary observation tests a different part of the same hypothesis and should be read together with the first check before authorizing change. Expected success would be: generated queries preserve expected cardinality and reconcile to certified totals. These author-intended interpretations require independent technical review before operational use.
E:This observation directly tests the case mechanism: Fan-out joins silently inflate aggregates even when generated SQL is syntactically valid. In the described setting, it helps determine whether correct join cardinality and test representative metrics before exposing text-to-sql answers. is justified. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:Checking this might help diagnose search versus analyst decision, where a chat assistant must answer both narrative handbook questions and numeric sales questions from relational tables. It is not one of the two most direct checks for the present case because the leading mechanism is fan-out joins silently inflate aggregates even when generated sql is syntactically valid. These author-intended interpretations require independent technical review before operational use.
C:Checking this might help diagnose structured revenue question routing, where a controller asks for regional net revenue while teams keep the definition in governed warehouse tables. It is not one of the two most direct checks for the present case because the leading mechanism is fan-out joins silently inflate aggregates even when generated sql is syntactically valid. These author-intended interpretations require independent technical review before operational use.
D:Checking this might help diagnose model endpoint selection, where a developer has several hosted language models with different cost, latency, and instruction-following profiles. It is not one of the two most direct checks for the present case because the leading mechanism is fan-out joins silently inflate aggregates even when generated sql is syntactically valid. These author-intended interpretations require independent technical review before operational use.
Question 99
At an e-commerce marketplace, a Snowflake engineering team is undertaking a returns reason classification effort. A semantic definition joins order lines to a dimension with duplicate surrogate keys. Diagnosis is disputed because some tickets mention several products; billing and privacy queues need distinct ownership. Which underlying failure mechanism BEST explains the observed limitation?
- Similar text chunks without version metadata make stale passages indistinguishable.
- Choosing only by parameter count or popularity ignores task fit and runtime constraints.
- Fan-out joins silently inflate aggregates even when generated SQL is syntactically valid.
- An unregistered binary lacks a dependable promotion and rollback trail.
Explanation
Correct Answer
C:This is the causal hypothesis consistent with the observed limitation: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Confirm it through both compare row counts before and after joins and reconcile weighted totals against trusted queries. before changing the service. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:That mechanism could explain a different case about rag chunk provenance, but does not most directly account for this specific symptom: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Here, the evidence to collect is compare row counts before and after joins These author-intended interpretations require independent technical review before operational use.
B:That mechanism could explain a different case about model endpoint selection, but does not most directly account for this specific symptom: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Here, the evidence to collect is compare row counts before and after joins These author-intended interpretations require independent technical review before operational use.
D:That mechanism could explain a different case about model registry decision, but does not most directly account for this specific symptom: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Here, the evidence to collect is compare row counts before and after joins These author-intended interpretations require independent technical review before operational use.
Question 100
At an insurance claims processor, a Snowflake engineering team is undertaking a form intake modernization. A semantic definition joins order lines to a dimension with duplicate surrogate keys. The change was trialed on a small dataset; the new system cannot automatically deny claims, while manual reviewers handle ambiguous scanned content. Which acceptance condition BEST demonstrates that the intervention worked?
- Newly authorized documents become retrievable within the agreed refresh window.
- Generated queries preserve expected cardinality and reconcile to certified totals.
- Persisted records include confidence caveats, traceability, and reviewed label semantics.
- Relevant incidents rank above unrelated cases with predictable latency.
Explanation
Correct Answer
B:This is the observable acceptance condition that would show the intended fix addressed fan-out joins silently inflate aggregates even when generated sql is syntactically valid. It is stronger than activity counts because it tests the user-facing effect. These author-intended interpretations require independent technical review before operational use.
Incorrect Answers
A:This could demonstrate success for cortex search index refresh, but it would not establish resolution of the current issue: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Validate generated queries preserve expected cardinality and reconcile to certified totals. instead. These author-intended interpretations require independent technical review before operational use.
C:This could demonstrate success for service call versus application logic, but it would not establish resolution of the current issue: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Validate generated queries preserve expected cardinality and reconcile to certified totals. instead. These author-intended interpretations require independent technical review before operational use.
D:This could demonstrate success for embedding versus completion, but it would not establish resolution of the current issue: a semantic definition joins order lines to a dimension with duplicate surrogate keys. Validate generated queries preserve expected cardinality and reconcile to certified totals. instead. These author-intended interpretations require independent technical review before operational use.