Question 91 · 1323 in bank
True or False: Snowflake supports federated authentication in all editions.
Show answer
Answer: A
SnowPro Core Certification1,323 questions across 133 pages are complete and free, with no account or card.
1323 questions in this bank
Free access · progress saved on this device
True or False: Snowflake supports federated authentication in all editions.
Answer: A
What is an advantage of using database roles instead of granting privileges on objects directly to a share in Snowflake?
Answer: C
What is the order of precedence (highest to lowest) of network policies when applied at the account, user, and security integrations layers?
Answer: C
Which type of Snowflake virtual warehouse provides 16 times the memory for each node, and is recommended for larger workloads like Machine Learning (ML) training?
Answer: D
SnowPark-optimized virtual warehouse is designed for high memory requirements, such as ML workloads, ML training datasets, and other memory-intensive tasks. It provides 16 times more memory per node than a standard virtual warehouse, making it an excellent choice for handling such workloads on a single virtual warehouse.
Source: Adapted from community discussion — nexerSnow
Which common query issues can be identified by the Query Profile? (Choose two.)
Answer: BD
In Snowflake, what allows users to perform recursive queries?
Answer: D
A user wants to create objects within a schema but wants to restrict other users’ ability to grant privileges on these objects. What configuration should be used to create the schema?
Answer: B
What is the MOST cost-effective way to resolve memory spillage in a virtual warehouse?
Answer: D
B. Enable the query acceleration service. The query acceleration service dynamically adds additional compute resources (more CPU and memory) to a virtual warehouse when queries require more resources than initially allocated. This can be a cost-effective solution as it only scales up resources temporarily during peak demand, potentially reducing memory spillage without the need to permanently increase the warehouse size.
Source: Adapted from community discussion — cybe001
What objects in Snowflake are supported by Dynamic Data Masking? (Choose two.)
Answer: AC
A user has created a dashboard in Snowflake and wants to share it with colleagues. How can the dashboard be shared?
Answer: B
Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page
COF-C02 practice, question 91. 1323 questions available.
Version 1.0.0. How we source questions