最新SnowPro-Core合格保証試験問題集には正確で最新な問題があります
SnowPro-Core試験ブレーン問題集で学習注釈と理論
Snowflake SnowPro-Core 認定試験は、候補者のSnowflake技術における熟練度を示す業界で認められた認定です。この認定は、Amazon Web Services、Microsoft Azure、Google Cloud Platformを含む世界的なトップ企業によって認められています。SnowPro Core 認定を取得することで、候補者がSnowflakeと共に働くために必要なスキルと知識を持っていることが示され、求職者市場で競争力を持つことができます。
Snowflake Snowpro-Core（Snowpro Core認証）試験は、Snowflakeのクラウドデータプラットフォームの詳細な知識と専門知識を持っている個人を認識するために設計された認定プログラムです。これは、スノーフレークソリューションの設計、構築、管理、およびトラブルシューティングに必要な知識とスキルを検証するグローバルに認められた認定プログラムです。この認定プログラムは、さまざまな業界のスノーフレークデータの専門家に対する需要の高まりを念頭に置いて設計されています。
質問 # 129
True or False: Snowflake bills for a minimum of five minutes each time a Virtual Warehouse is started.
- A. True
- B. False
正解：B
解説：
Reference: https://docs.snowflake.com/en/user-guide/credits.html
質問 # 130
Which feature is only available in the Enterprise or higher editions of Snowflake?
- A. SOC 2 type II certification
- B. Object-level access control
- C. Column-level security
- D. Multi-factor Authentication (MFA)
正解：C
解説：
https://docs.snowflake.com/en/user-guide/intro-editions.html
質問 # 131
When creating a user it is advisable sable to:
Choose 2 answers
- A. Set the users access to expire within a specified timeframe
- B. Set the number of minutes to unlock to 15 minutes
- C. Set a default role for the user
- D. Force an immediate password change
- E. Set the user to be initially disabled
正解：C、D
質問 # 132
A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
- A. Microsoft Authenticator
- B. Okta Verify
- C. Duo Mobile
- D. Google Authenticator
正解：C
解説：
Explanation
https://docs.snowflake.com/en/user-guide/security-mfa.html
質問 # 133
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Compute can be scaled up or down without the requirement to add more storage
- B. Multiple compute clusters can access stored data without contention
- C. Growth of storage and compute are tightly coupled together
- D. Storage expands without the requirement to add more compute
正解：C
解説：
Explanation/Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehouse- doesnt-separate-storage-and-compute-65d2dffd450f
質問 # 134
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- A. The warehouse size does not change until the warehouse is suspended and restarted.
- B. The warehouse size does not change until all queries currently running in the warehouse have completed.
- C. The warehouse size does not change until all queries currently in the warehouse queue have completed.
- D. It does not return from the command until the warehouse has finished changing its size.
正解：D
質問 # 135
Select the three types of tables that exist within Snowflake.
Choose 3 answers
- A. Temporary
- B. Permanent
- C. Transient
- D. Provisioned
正解：A、B、C
解説：
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
質問 # 136
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
- A. When the system has enough load for 2 minutes
- B. When the system has enough load for 10 minutes
- C. When the system has enough load for 6 minutes
- D. When the system has enough load for 8 minutes
正解：B
質問 # 137
True or False: Snowpipe via REST API can only reference External Stages as source.
- A. True
- B. False
正解：B
解説：
Explanation/Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
質問 # 138
Using variables in Snowflake is denoted by using which SQL character?
- A. &
- B. @
- C. $
- D. #
正解：C
質問 # 139
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
- A. SHARE on databases and schemas
- B. SELECT on tables used by the secure view
- C. CREATE_SHARE on the account
- D. REFERENCE_USAGE on databases
正解：B
質問 # 140
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. True
- B. False
正解：B
質問 # 141
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
- A. The use of warehouse indexing
- B. The ability to resize warehouses
- C. The ability to scale up warehouses
- D. Use of multi-clustered warehouses
- E. The use of warehouse auto scaling
正解：D、E
質問 # 142
What are the three layers that make up Snowflake's architecture?
Choose 3 answer
- A. Tri-Secret Secure
- B. Cloud Services
- C. Storage
- D. Compute
正解：B、C、D
解説：
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
質問 # 143
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
- A. All data in Snowflake is encrypted.
- B. All data in Snowflake is compressed.
- C. Snowflake leverages a Role-Based Access Control (RBAC) model.
- D. Snowflake can run within a user's own Virtual Private Cloud (VPC).
- E. Snowflake requires a user to configure an IAM user to connect to the database.
正解：C、D
質問 # 144
True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
- A. True
- B. False
正解：B
質問 # 145
If a multi-cluster warehouse is using an economy scaling policy, how long will queries wait in the queue before another cluster is started?
- A. 8 minutes
- B. 2 minutes
- C. 1 minute
- D. 6 minutes
正解：D
質問 # 146
True or False: Snowflake charges a premium for storing semi-structured data.
- A. True
- B. False
正解：B
解説：
Reference:
premium-for-storing-semi-structured-data
質問 # 147
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A)
B)
C)
D)
- A. Option C
- B. Option B
- C. Option A
- D. Option D
正解：C
質問 # 148
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
- A. Vendor
- B. Consumer
- C. Reader
- D. Standard
- E. Personalized
正解：D、E
質問 # 149
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. True
- B. False
正解：A
質問 # 150
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
- A. When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- B. When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
- C. When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
- D. When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
正解：D
質問 # 151
What happens when a database is cloned?
- A. It replicates all granted privileges on the corresponding source objects.
- B. It replicates all granted privileges on the corresponding child schema objects.
- C. It does not retain any privileges granted on the source object.
- D. It replicates all granted privileges on the corresponding child objects.
正解：D
質問 # 152
......
合格させるSnowflake SnowPro-Coreテスト練習問題 試験問題集：https://jp.fast2test.com/SnowPro-Core-premium-file.html