Snowflake's default Multi-Factor Authentication (MFA) service is powered by Duo Security. Users are required to install the Duo Mobile application on their devices to use MFA for increased login security when connecting to Snowflake.This service is managed entirely by Snowflake, and users do not need to sign up separately with Duo1.

The clearly correct answer from the listed options is A. ARRAY_AGG .
Important correction:
The provided answer A, D is not fully correct if the question is asking about aggregate functions .
ARRAY_CONSTRUCT creates an array from explicitly supplied values, but it does not aggregate values across multiple rows.
Why A is correct:
ARRAY_AGG is an aggregate function. It aggregates input values from multiple rows into a single array.
Example:
SELECT ARRAY_AGG(product_id)
FROM orders;
This returns an array containing product_id values from multiple rows.
Why D is not an aggregate function:
ARRAY_CONSTRUCT creates an array from the values passed into the function.
Example:
SELECT ARRAY_CONSTRUCT( ' A ' , ' B ' , ' C ' );
This creates an array from listed expressions, but it does not aggregate values across rows.
Why the other options are incorrect:
B). ARRAY_SLICE returns a subset of an existing array.
C). ARRAY_APPEND appends a value to an existing array.
E). ARRAY_TO_STRING converts an array to a string.
Official Snowflake documentation reference:
Snowflake documentation describes ARRAY_AGG as an aggregate function that returns the input values, pivoted into an array. ARRAY_CONSTRUCT is documented as a scalar function that constructs an array from input expressions.
Reference: Snowflake Documentation - ARRAY_AGG; Snowflake Documentation - ARRAY_CONSTRUCT; SnowPro Core Study Guide - Working with Semi-Structured Data.
==

By default, the ACCOUNTADMIN role in Snowflake has access to the
SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function. This function is used to set global account parameters, impacting the entire Snowflake account ' s configuration and behavior. The ACCOUNTADMIN role is the highest-level administrative role in Snowflake, granting the necessary privileges to manage account settings and security features, including the use of global account parameters.
References:
Snowflake Documentation: SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER

When initiating a session in Snowflake, the system determines the current role based on the user's connection details and role assignments. If a user specifies a role during the connection, and that role is already granted to them, Snowflake sets it as the current role for the session. Alternatively, if no role is specified during the connection, but the user has a default role assigned, Snowflake will use this default role as the current session role. These mechanisms ensure that users operate within their permissions, enhancing security and governance within Snowflake environments.
References:
Snowflake Documentation: Understanding Roles

To use Partner Connect, the ACCOUNTADMIN role is required. Partner Connect allows account administrators to easily create trial accounts with selected Snowflake business partners and integrate these accounts with Snowflake