[2025年09月23日] 最新更新されたのはSnowPro-Core試験問題2025年更新
無料更新されたSnowflake SnowPro-Coreテストエンジン問題には630問題と解答
Snowflake Snowpro-Core認証試験は、Pearson Vueが管理するコンピューターベースの試験です。この試験は90の複数選択の質問で構成されており、120分間の期間があります。この試験は、英語、日本語、スペイン語で入手できます。試験を受けることを希望する候補者は、スノーフレークのウェブサイトに登録して試験料を支払うことができます。
Snowflake Snowpro-Core認定は、専門家がSnowflakeプラットフォームの使用におけるスキルと知識を検証するのに役立つ貴重な認定です。この認定は世界中で認識されており、専門家がデータウェアハウジングおよびクラウドコンピューティング業界でのキャリアを促進するのに役立ちます。認定試験は厳密であり、幅広いトピックをカバーしているため、専門家がスノーフレークプラットフォームを使用する専門知識を実証する優れた方法です。
質問 # 368
Account-level storage usage can be monitored via:
- A. The Information Schema -> ACCOUNT_USAGE_HISTORY View
- B. The Snowflake web interface (UI) in the Account -> Billing a usage section
- C. The Account usage Schema - > ACCOUNT_USAGE_METRICS View
- D. The snowflake wet Interface (UI) in the Databases section.
正解：B
解説：
Reference: https://docs.snowflake.com/en/user-guide/admin-usage-billing.html
質問 # 369
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
- A. Data is live, ready-to-query, and can be personalized.
- B. Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
- C. Data is available without copying or moving.
- D. Data needs to be loaded into a cloud provider as a consumer account.
- E. Data is not available for copying or moving to an individual Snowflake account.
正解：A、C
解説：
When leveraging third-party data from the Snowflake Data Marketplace, the data is live, ready-to-query, and can be personalized. Additionally, the data is available without the need for copying or moving it to an individual Snowflake account, allowing for seamless integration with existing data
質問 # 370
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
- A. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
- B. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
- C. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
- D. A user cannot specify a default warehouse when using the ODBC driver.
- E. The default virtual warehouse size can be changed at any time.
正解：C
質問 # 371
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?
- A. Query Processing
- B. Metadata Management
- C. Cloud Services
- D. Database Storage
正解：D
解説：
Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer. This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance
質問 # 372
When is the result set cache no longer available? (Select TWO)
- A. When the warehouse used to execute the query is suspended
- B. When another user executes the query
- C. When it has been 24 hours since the last query
- D. When another warehouse is used to execute the query
- E. When the underlying data has changed
正解：C、E
質問 # 373
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Avoid using embedded characters such as commas for numeric data types
- B. Remove semi-structured data types
- C. Remove all dates and timestamps.
- D. Load files that are approximately 100-250 MB (or larger)
- E. Load files that are approximately 25 MB or smaller.
正解：A、D
解説：
Explanation
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
質問 # 374
Which type of table corresponds to a single Snowflake session?
- A. Permanent
- B. Transient
- C. Temporary
- D. Provisional
正解：C
質問 # 375
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
- A. Each Snowflake account can be hosted in a different cloud vendor and region.
- B. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
- C. All Snowflake accounts must be hosted in the same cloud vendor and region
- D. Each Snowflake account must be hosted in a different cloud vendor and region
正解：D
解説：
Explanation
https://docs.snowflake.com/en/user-guide/intro-regions.html
質問 # 376
True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.
- A. True
- B. False
正解：B
解説：
Explanation/Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/
質問 # 377
What is the name of the SnowSQLfile that can store connection information?
- A. snowsql.pubkey
- B. snowsqLcnf
- C. history
- D. config
正解：D
質問 # 378
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
- A. True
- B. False
正解：A
解説：
You can experiment the same with snowflake UI.
質問 # 379
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
正解：B
質問 # 380
How long can a data consumer who has a pre-signed URL access data files using Snowflake?
- A. Indefinitely
- B. Until the expiration time is exceeded
- C. Until the retention_time is met
- D. Until the result_cache expires
正解：B
解説：
A data consumer who has a pre-signed URL can access data files using Snowflake until the expiration time is exceeded. The expiration time is set when the pre-signed URL is generated and determines how long the URL remains valid3.
質問 # 381
Which type of table corresponds to a single Snowflake session?
- A. Permanent
- B. Temporary
- C. Translent
- D. Provisional
正解：B
解説：
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temp-transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.
質問 # 382
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
- A. Bytes spilled to remote metastore.
- B. Bytes spilled to local cache.
- C. Bytes spilled to local storage.
- D. Bytes spilled to remote cache.
- E. Bytes spilled to remote storage.
正解：C、E
質問 # 383
What is a characteristic of the Snowflake Query Profile?
- A. It provides detailed statistics about which queries are using the greatest number of compute resources.
- B. It can provide statistics on a maximum number of 100 queries per week.
- C. It can be used by third-party software using the Query Profile API.
- D. It provides a graphic representation of the main components of the query processing.
正解：D
解説：
The Snowflake Query Profile provides a graphic representation of the main components of the query processing. This visual aid helps users understand the execution details and performance characteristics of their queries4.
質問 # 384
Which REST API can be used with unstructured data?
- A. insertReport
- B. GET /api/tiles/
- C. loadHistoryScan
- D. inscrtFilcs
正解：B
解説：
The REST API used with unstructured data in Snowflake is GET /api/files/, which retrieves (downloads) a data file from an internal or external stage4.
質問 # 385
Data storage for individual tables can be monitored using which commands and/or object(s)?
Choose 2 answers
- A. Information Schema -> TABLE_STORAGE_METRICS
- B. SHOW TABLES;
- C. SHOW STORAGE BY TABLE;
- D. Information Schema -> TASLE_HISTORY
正解：B、D
質問 # 386
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?
- A. USERADMIN
- B. ORGADMIN
- C. PUBLIC
- D. SYSADMIN
正解：A
解説：
The first user assigned to a new Snowflake account, typically with the ACCOUNTADMIN role, should create at least one additional user with the USERADMIN administrative privilege. This role is responsible for creating and managing users and roles within the Snowflake account. References: Access control considerations | Snowflake Documentation
質問 # 387
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?
- A. TEXT
- B. OBJECT
- C. ARRAY
- D. VARIANT
正解：D
解説：
When dealing with semi-structured data in Snowflake, and the specific types of operations to be performed on the data are not yet determined, Snowflake recommends using the VARIANT data type. The VARIANT type is highly flexible and capable of storing data in multiple formats, including JSON, AVRO, BSON, and more, within a single column. This flexibility allows users to perform various operations on the data, including querying and manipulation of nested data structures without predefined schemas.
References:
* Snowflake Documentation: Semi-structured Data Types
質問 # 388
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more queries
- B. To accommodate more users
- C. To accommodate fluctuations in workload
- D. To accommodate a more complex workload
正解：A
解説：
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
質問 # 389
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?
Select one.
- A. START_AFTCR_CREATE = TRUE/FALSE
- B. START_TTIME = 60 // (seconds from now)
- C. INITTIALLY_SUSPENDED = TRUE/FALSE
- D. START.TIME = CURRENT.DATE()
正解：C
質問 # 390
......
100%の合格率を試そう！更新されたのはSnowPro-Core試験問題 [2025年更新]：https://jp.fast2test.com/SnowPro-Core-premium-file.html