GES-C01問題集、Snowflake実際の試験問題

質問 1

A global enterprise has Snowflake accounts in various regions, including a US East (Ohio) account where a critical application is deployed. They need to use AI_COMPLETE with the claude-3-5-sonnet model for real-time customer support, but this model is not natively available in US East (Ohio) for direct AI_COMPLETE usage. The Snowflake administrator considers enabling cross-region inference. Which statements accurately reflect the considerations and characteristics of cross-region inference in Snowflake Cortex?

A. Setting the CORTEX_ENABLED_CROSS_REGION account parameter to 'ANY_REGION' in the US East (Ohio) account would enable inference requests for claude-3-5- sonnet to be processed in any region where it is natively available.

B. Cross-region inference automatically caches user inputs and generated outputs to reduce latency for subsequent requests to the same model.

C. Cross-region inference is not supported in U.S. SnowGov regions for either inbound or outbound inference requests.

D. The CORTEX_ENABLED_CROSS_REGION parameter can be configured at the session level to temporarily enable cross-region inference for specific workloads.

E. Latency between regions for cross-region inference is negligible and consistently low, irrespective of cloud provider infrastructure.

正解: A,C

解説: (PassTest メンバーにのみ表示されます)

質問 2

A data application developer is building a Streamlit chat application that interacts with structured data using Cortex Analyst, a feature of Snowflake Cortex that is often integrated into Cortex Agents. The developer wants to ensure efficient multi-turn conversations and leverage verified queries. Which of the following statements represent best practices and functional aspects for this scenario within Snowflake's Gen AI ecosystem?

A. Option A

B. Option C

C. Option E

D. Option B

E. Option D

正解: D,E

解説: (PassTest メンバーにのみ表示されます)

質問 3

A Data Application Developer is building a Streamlit chat application powered by Snowflake Cortex Analyst. Users frequently ask questions involving specific product names, such as "What was the total sales of 'Luxury Coffee Beans' last quarter?". The semantic model has a product_name dimension with high cardinality. The developer wants to ensure Cortex Analyst accurately identifies these specific product literals in user queries. Given this scenario, which of the following approaches should the developer consider to optimize literal search capabilities and enhance Cortex Analyst responses?

A. Option A

B. Option C

C. Option E

D. Option B

E. Option D

正解: D

解説: (PassTest メンバーにのみ表示されます)

質問 4

A development team is evaluating Snowpark Container Services (SPCS) for deploying various AI/ML workloads, including custom LLMs and GPU-accelerated model training. They need to understand its core benefits and operational characteristics compared to traditional container orchestration platforms. Which of the following statements accurately describe the benefits and/or operational characteristics of Snowpark Container Services for deploying third-party models and AI applications?

A. SPCS primarily supports applications written in Python and Java, with limited experimental support for other programming languages.

B. Compute clusters within SPCS are designed to auto-scale dynamically based on workload demand, automatically adjusting the number of instances.

C. SPCS supports both long-running services (e.g., web applications) and finite-lifespan job services (e.g., GPU-accelerated machine learning model training).

D. Snowpark Container Services ensures that data remains within Snowflake's security and governance boundaries, eliminating the need to move data out of the environment for processing.

E. SPCS provides a fully managed OCI runtime execution environment, allowing users to run containerized workloads directly within Snowflake without managing underlying Docker or Kubernetes infrastructure.

正解: C,D,E

解説: (PassTest メンバーにのみ表示されます)

質問 5

A Gen AI Specialist is setting up their Snowflake environment to deploy a high-performance open-source LLM for real-time inference using Snowpark Container Services (SPCS). They need to create a compute pool that can leverage NVIDIAAIOG GPUs to optimize model performance. Which of the following SQL statements correctly creates a compute pool capable of supporting an intensive GPU usage scenario, such as serving LLMs, while adhering to common configuration best practices for a new, small-scale deployment in Snowpark Container Services?

A.

B.

C.

D.

E.

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 6

An administrator has configured the 'CORTEX MODELS ALLOWLIST parameter to only permit the 'mistral-large? model at the account level. A user with the role, which has been granted 'SNOWFLAKE.CORTEX USER and 'SNOWFLAKE."CORTEX- MODEL-ROLE-LLAMA3.1-70B"', attempts to execute several queries. Which of the following queries will successfully execute?

A.

B.

C.

D.

E.

正解: C,D

解説: (PassTest メンバーにのみ表示されます)

質問 7

A Snowflake developer, named ANALYST USER, is tasked with creating a Streamlit in Snowflake (SiS) application that will utilize both SNOWFLAKE. CORTEX. COMPLETE for generating responses and SNOWFLAKE. CORTEX.CLASSIFY_TEXT for categorizing user input. To ensure the role used by ANALYST USER has the necessary permissions for executing these Cortex LLM functions and operating within a specified database and schema, which of the following database roles or privileges must be granted? (Select all that apply.)

A. The USAGE privilege on the database and schema where the Streamlit application runs and potentially stores related data.

B.

C.

D.

E.

正解: A,C

解説: (PassTest メンバーにのみ表示されます)

質問 8

A Snowflake administrator is tasked with monitoring the efficiency and cost-effectiveness of their Cortex Analyst deployments. They need to identify if certain semantic models are generating a high volume of failed or expensive queries. Which of the following approaches or statements are crucial for effectively monitoring and identifying issues with Cortex Analyst usage and associated costs?

A. Option A

B. Option C

C. Option E

D. Option B

E. Option D

正解: A,B,C

解説: (PassTest メンバーにのみ表示されます)

質問 9

A Snowflake developer is tasked with enhancing a daily data pipeline. The pipeline processes raw text descriptions of system events and needs to extract structured information, specifically the (string) and its (string, restricted to 'low', 'medium', 'high', 'critical'). The output must be a strictly formatted JSON object, ensuring data quality for downstream analytics.
Consider the following SQL snippet intended for this transformation:

Which of the following statements are correct regarding this implementation and best practices for using with structured outputs in a data pipeline?

A. Setting 'temperature 'to '0.7 ' is optimal for ensuring the most consistent and deterministic JSON outputs, especially for complex extraction tasks.

B. Using 'TRY COMPLETE instead of would allow the pipeline to gracefully handle cases where the model fails to generate a valid JSON response by returning 'NULL' instead of an error.

C. The complexity of the JSON schema, particularly deep nesting, does not impact the number of tokens processed and billed for 'AI_COMPLETE Structured Outputs.

D. For all models supported by 'AI_COMPLETE' Structured Outputs, the 'additionalPropertieS field must be set to 'false' in every node of the schema, and the 'required' field must contain all property names.

E. The 'response_format' correctly defines the expected JSON structure, using 'enum' for 'severity_lever and 'required' to ensure 'event_name' and severity_lever are always present if extracted.

正解: B,E

解説: (PassTest メンバーにのみ表示されます)

質問 10

A development team is preparing to deploy a new Retrieval-Augmented Generation (RAG) application written in Python. They intend to use Snowflake AI Observability to capture detailed logs and traces for debugging and performance analysis. Which of the following configurations are essential prerequisites for enabling this logging capability effectively?

A. Option A

B. Option C

C. Option E

D. Option B

E. Option D

正解: A,B,C,D

解説: (PassTest メンバーにのみ表示されます)

質問 11

A. Option A

B. Option C

C. Option E

D. Option B

E. Option D

正解: A,B

解説: (PassTest メンバーにのみ表示されます)

質問 12

database role. Which of the following 'privileges directly related to the virtual warehouse or task execution' are required for the process invoices_task' to successfully execute the Document AI '!PREDICT' method? (Select ALL that apply.)

A.

B.

C.

D.

E.

正解: C,D,E

解説: (PassTest メンバーにのみ表示されます)

Snowflake SnowPro® Specialty: Gen AI Certification - GES-C01 模擬練習