Special Summer Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: scxmas70

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 73

What is the benefit of using the STRIP_OUTER_ARRAY parameter with the COPY INTO

command when loading data from a JSON file into a table?

A.

It flattens multiple arrays into a single array.

B.

It removes the outer array structure and loads separate rows of data

C.

It transforms a pivoted table into an array.

D.

It tokenizes each data string using the defined delimiters.

Full Access
command is used when loading data from a JSON file into a table. This parameter removes the outer array structure from the JSON data and loads separate rows of data into the table.

    Understanding the STRIP_OUTER_ARRAY Parameter:

      JSON files often contain data in an array format where multiple records are nested within a single outer array.

      The STRIP_OUTER_ARRAY parameter helps in simplifying the loading process by removing this outer array, allowing each element within the array to be loaded as a separate row in the target table.

    How It Works:

      When the STRIP_OUTER_ARRAY parameter is set to TRUE, Snowflake treats each item within the outer array as an individual record.

      This eliminates the need for additional parsing or transformation steps that would otherwise be required to handle nested arrays.

    Example Usage:

FROM @my_stage/file.json

FILE_FORMAT = (TYPE = 'JSON' STRIP_OUTER_ARRAY = TRUE);

      In this example, the JSON file containing an array of objects is loaded into the table my_table.

      Each object within the array is loaded as a separate row, without the outer array structure.

    Benefits:

      Simplifies data loading: By removing the outer array, the data is directly loaded into the table without additional manipulation.

      Enhances performance: Streamlines the loading process, reducing the complexity and potential errors in handling nested JSON structures.

References:

    Snowflake Documentation: COPY INTO

Snowflake Documentation: JSON File Format Options

Question # 74

What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).

A.

INSERT

B.

UPDATE

C.

DELETE

D.

TRUNCATE

E.

UPSERT

Full Access
Question # 75

Which type of workload is recommended for Snowpark-optimized virtual warehouses?

A.

Workloads with ad hoc analytics

B.

Workloads that have large memory requirements

C.

Workloads with unpredictable data volumes for each query

D.

Workloads that are queried with small table scans and selective filters

Full Access
Question # 76

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

A.

USAGE on the specific tables in the database.

B.

USAGE on the specific tables in the database.

C.

MODIFY on 1Mb specific tables in the database.

D.

USAGE on the database and the schema containing the tables to share

E.

OPEBATE on the database and the schema containing the tables to share.

Full Access
Question # 77

Which statistics on a Query Profile reflect the efficiency of the query pruning? (Select TWO).

A.

Partitions scanned

B.

Partitions total

C.

Bytes spilled

D.

Bytes scanned

E.

Bytes written

Full Access
Question # 78

Which access control entity in Snowflake can be created as part of a hierarchy within an account?

A.

Securable object

B.

Role

C.

Privilege

D.

User

Full Access
Question # 79

What are the main differences between the account usage views and the information schema views? (Select TWO).

A.

No active warehouse to needed to query account usage views but one is needed to query information schema views.

B.

Account usage views do not contain data about tables but information schema views do.

C.

Account issue views contain dropped objects but information schema views do not.

D.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

E.

Information schema views are read-only but account usage views are not.

Full Access
Question # 80

Authorization to execute CREATE statements comes only from which role?

A.

Primary role

B.

Secondary role

C.

Application role

D.

Database role

Full Access
Go to page: