COF-C03 Exam Questions Tutorials

The correct answer is C. Duo Security .

Snowflake provides integrated Multi-Factor Authentication through Duo Security . MFA adds an additional verification step beyond username and password authentication, improving account security.

Why C is correct:

Snowflake’s native MFA integration uses Duo Security. Users can enroll in MFA and authenticate using Duo-supported methods.

Why the other options are incorrect:

A. Microsoft Entra ID can be used as an identity provider for federated authentication, but it is not the MFA service provided natively by Snowflake.

B. Google Authenticator is a common authenticator app, but it is not Snowflake’s native MFA service.

D. Microsoft Authenticator is also a common MFA app, but Snowflake’s built-in MFA service is Duo Security.

Official Snowflake documentation reference:

Snowflake documentation describes Snowflake MFA as being powered by Duo Security.

The correct answer is A. Use the OBJECT_CONSTRUCT function with the COPY INTO < location > command .

When unloading relational data to JSON, each relational row must be transformed into a single semi-structured object. OBJECT_CONSTRUCT creates a JSON-style object from the row’s columns, and COPY INTO < location > unloads the result to a stage.

Why A is correct:

Snowflake requires unloaded JSON data to be represented as a single VARIANT, OBJECT, or ARRAY value per row. OBJECT_CONSTRUCT converts relational columns into an object suitable for JSON unload.

Example:

COPY INTO @my_stage/output/

FROM (

SELECT OBJECT_CONSTRUCT(*)

FROM customers

)

FILE_FORMAT = (TYPE = JSON);

Why the other options are incorrect:

B. Setting the file format to JSON alone is not sufficient for relational rows with multiple columns. The rows must be converted into a single semi-structured column.

C. PUT uploads local files to an internal stage. It does not unload table data.

D. GET downloads files from an internal stage to a local machine. It does not unload table data from Snowflake.

Official Snowflake documentation reference:

Snowflake documentation explains that to unload relational data to JSON, the query should return a single column containing semi-structured data, commonly produced with OBJECT_CONSTRUCT.

When SINGLE = FALSE is set during COPY INTO, Snowflake writes multiple output files , enabling parallelism . Setting SINGLE = TRUE forces one output file, reducing parallel processing.

TheMIN_DATA_RETENTION_TIME_IN_DAYSparameter is set at theAccountlevel in Snowflake. This parameter specifies the minimum number of days Snowflake retains the historical data for time travel, which allows users to access and query data as it existed at previous points in time.

Here ' s how to understand and adjust this parameter:

Purpose of MIN_DATA_RETENTION_TIME_IN_DAYS:This parameter is crucial for managing data lifecycle and compliance requirements within Snowflake. It determines the minimum time frame for which you can perform operations like restoring deleted objects or accessing historical versions of data.

Setting the Parameter:Only account administrators can set or modify this parameter. It is done at the account level, impacting all databases and schemas within the account. The setting can be adjusted based on the organization ' s data retention policy.

Adjusting the Parameter:

To view the current setting, use:

SHOWPARAMETERSLIKE ' MIN_DATA_RETENTION_TIME_IN_DAYS ' ;

To change the setting, an account administrator can execute:

ALTERACCOUNTSETMIN_DATA_RETENTION_TIME_IN_DAYS = < number_of_days > ;