準備できるSnowPro-Core問題解答は無料更新されて100%試験合格保証 [2024]
問題集リアルなSnowflake SnowPro-Core試験問題 [更新されたのは2024年]
Snowpro-Core認証試験は、スノーフレークの専門知識を実証したい専門家にとって必須の必要なものです。データエンジニア、データアーキテクト、データアナリスト、およびスノーフレークで働く他の専門家に最適です。この認定は、候補者の知識とスキルを検証するだけでなく、信頼性とキャリアの見通しも強化します。 Snowpro-Core認定を達成することにより、専門家はスノーフレークの習熟度を紹介し、競争力のある雇用市場で際立っています。
Snowflakeはクラウドベースのデータプラットフォームであり、組織が大量のデータを格納、処理、分析することができます。このプラットフォームは、スケーラブルで柔軟なデータストレージソリューションを必要とする企業に人気があります。SnowPro-Core認定試験は、候補者のSnowflakeのアーキテクチャに対する理解と、プラットフォームを使用してデータを効果的に管理する方法を検証するために設計されています。試験に合格することで、候補者はSnowflake技術に熟練しており、プラットフォームの機能を活用する能力を証明します。
質問 # 19
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?
- A. To accommodate more queries
- B. To accommodate a more complex workload
- C. To accommodate more users
- D. To accommodate fluctuations in workload
正解：A
質問 # 20
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
- A. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
- B. Compress the file and load the compressed file.
- C. Use a larger-sized warehouse.
- D. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
正解：B
質問 # 21
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
- A. select src:dealership from car_sales;
- B. select src:Dealership from car_sales;
- C. select dealership from car_sales;
- D. select src.dealership from car_sales;
正解：A
質問 # 22
If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
正解：B
質問 # 23
Which of the following objects are contained within a schema? (Choose two.)
- A. Stream
- B. Role
- C. Share
- D. User
- E. Warehouse
- F. External table
正解：E、F
質問 # 24
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
- A. BYTE_SIZE
- B. PATH
- C. CONTENT
- D. INDEX
- E. DATATYPE
正解：A、B
質問 # 25
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. True
- B. False
正解：B
解説：
Explanation
"The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."
質問 # 26
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
- A. True
- B. False
正解：B
解説：
Explanation
A reader account can only consume data from the provider account that created it.
質問 # 27
What is the MOST performant file format for loading data in Snowflake?
- A. ORC
- B. CSV (Gzipped)
- C. Parquet
- D. CSV (Unzipped)
正解：D
質問 # 28
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When managing a steady workload
- B. When the compute must be available with no delay or lag time
- C. When users will be using compute at different times throughout a 24/7 period
- D. When you don't want to have to manually turn on the Warehouse each time a user needs it
正解：A、B
解説：
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html
質問 # 29
What are common issues found by using the Query Profile? (Choose two.)
- A. Data spilling to a local or remote disk
- B. Locating queries that consume a high amount of credits
- C. Identifying inefficient micro-partition pruning
- D. Identifying logical issues with the queries
- E. Identifying queries that will likely run very slowly before executing them
正解：C、E
質問 # 30
What is the purpose of an External Function?
- A. To run a function in another Snowflake database
- B. To share data in Snowflake with external parties
- C. To call code that executes outside of Snowflake
- D. To ingest data from on-premises data sources
正解：C
解説：
Explanation
https://docs.snowflake.com/en/sql-reference/external-functions.html
質問 # 31
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true? (Choose two.)
- A. The "24 hour" timer on the precomputed results gets renewed every time the exact query is executed
- B. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous 24 hour period
- C. The exact query will ALWAYS return the precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within previous 24 hour period
正解：B、C
質問 # 32
What is the purpose of multi-cluster virtual warehouses?
- A. To allow the warehouse to resize automatically
- B. To eliminate or reduce Queuing of concurrent queries
- C. To create separate data warehouses to increase query optimization
- D. To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
正解：B
解説：
https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.
質問 # 33
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
- A. A Google Cloud storage bucket
- B. An FTP server with TLS encryption
- C. A Windows server file share on Azure
- D. An HTTPS server with WebDAV
正解：A
質問 # 34
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A. Cloud infrastructure layer
- B. Storage layer
- C. Cloud services layer
- D. Compute layer
正解：D
解説：
Explanation
For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer
https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query%20Proces
質問 # 35
......
Snowflake Snowpro-Core認証試験は、スノーフレークの個人の習熟度をテストするように設計されています。認定試験は、スノーフレークソリューションの設計、構築、管理、および保護に必要な知識とスキルを検証します。 Snowpro-Core認証試験は、Snowflakeが提供する最高レベルの認定であるSnowpro認証を達成するための最初のステップです。
SnowPro-Core試験問題集、SnowPro-Core練習テスト問題：https://jp.fast2test.com/SnowPro-Core-premium-file.html