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

Welcome To DumpsPedia

COF-R02 Sample Questions Answers

Questions 4

When should a multi-cluster warehouse be used in auto-scaling mode?

Options:

A.

When it is unknown how much compute power is needed

B.

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.

If the runtime of the executed query is very slow

D.

When a large number of concurrent queries are run on the same warehouse

Buy Now
Questions 5

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Options:

A.

Query against the result set cache

B.

Query against a virtual warehouse cache

C.

Query against the most-recently created micro-partition

D.

Query against the metadata excite

Buy Now
Questions 6

What can be used to view warehouse usage over time? (Select Two).

Options:

A.

The load HISTORY view

B.

The Query history view

C.

The show warehouses command

D.

The WAREHOUSE_METERING__HISTORY View

E.

The billing and usage tab in the Snowflake web Ul

Buy Now
Questions 7

What are the default Time Travel and Fail-safe retention periods for transient tables?

Options:

A.

Time Travel - 1 day. Fail-safe - 1 day

B.

Time Travel - 0 days. Fail-safe - 1 day

C.

Time Travel - 1 day. Fail-safe - 0 days

D.

Transient tables are retained in neither Fail-safe nor Time Travel

Buy Now
Questions 8

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

Options:

A.

External Tokenization

B.

External Tables

C.

Materialized Views

D.

User-Defined Table Functions (UDTF)

Buy Now
Questions 9

Which TABLE function helps to convert semi-structured data to a relational representation?

Options:

A.

CHECK_JSON

B.

TO_JSON

C.

FLATTEN

D.

PARSE_JSON

Buy Now
Questions 10

A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.

Which Snowflake feature will support this?

Options:

A.

Row access policies

B.

Data masking policies

C.

Data encryption

D.

Role based access control

Buy Now
Questions 11

What features does Snowflake Time Travel enable?

Options:

A.

Querying data-related objects that were created within the past 365 days

B.

Restoring data-related objects that have been deleted within the past 90 days

C.

Conducting point-in-time analysis for Bl reporting

D.

Analyzing data usage/manipulation over all periods of time

Buy Now
Questions 12

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Options:

A.

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.

An error will occur, as views with qualified references cannot be cloned.

C.

An error will occur, as stored objects cannot be cloned.

D.

The stored procedures and views will refer to tables in the source database.

Buy Now
Questions 13

Which statement describes how Snowflake supports reader accounts?

Options:

A.

A reader account can consume data from the provider account that created it and combine it with its own data.

B.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Buy Now
Questions 14

Which of the following describes the Snowflake Cloud Services layer?

Options:

A.

Coordinates activities in the Snowflake account

B.

Executes queries submitted by the Snowflake account users

C.

Manages quotas on the Snowflake account storage

D.

Manages the virtual warehouse cache to speed up queries

Buy Now
Questions 15

Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)

Options:

A.

Schemas

B.

Roles

C.

Secure Views

D.

Stored Procedures

E.

Tables

F.

Secure User-Defined Functions (UDFs)

Buy Now
Questions 16

How many resource monitors can be assigned at the account level?

Options:

A.

1

B.

2

C.

3

D.

4

Buy Now
Questions 17

Which file formats are supported for unloading data from Snowflake? (Choose two.)

Options:

A.

Avro

B.

JSON

C.

ORC

D.

XML

E.

Delimited (CSV, TSV, etc.)

Buy Now
Questions 18

Which command sets the Virtual Warehouse for a session?

Options:

A.

COPY WAREHOUSE FROM <>;

B.

SET WAREHOUSE = <>;

C.

USE WAREHOUSE <>;

D.

USE VIRTUAL_WAREHOUSE <>;

Buy Now
Questions 19

Which tasks are performed in the Snowflake Cloud Services layer? (Choose two.)

Options:

A.

Management of metadata

B.

Computing the data

C.

Maintaining Availability Zones

D.

Infrastructure security

E.

Parsing and optimizing queries

Buy Now
Questions 20

Users are responsible for data storage costs until what occurs?

Options:

A.

Data expires from Time Travel

B.

Data expires from Fail-safe

C.

Data is deleted from a table

D.

Data is truncated from a table

Buy Now
Questions 21

Network policies can be set at which Snowflake levels? (Choose two.)

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Buy Now
Questions 22

Which of the following are characteristics of security in Snowflake?

Options:

A.

Account and user authentication is only available with the Snowflake Business Critical edition.

B.

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C.

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D.

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Buy Now
Questions 23

The is the minimum Fail-safe retention time period for transient tables?

Options:

A.

1 day

B.

7 days

C.

12 hours

D.

0 days

Buy Now
Questions 24

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Options:

A.

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C.

Enclose fields that contain delimiter characters in single or double quotes.

D.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Buy Now
Questions 25

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

Options:

A.

The columns that are queried in the select clause.

B.

The columns with very high cardinality.

C.

The columns with many different values.

D.

The columns most actively used in the select filters.

Buy Now
Questions 26

What is a responsibility of Snowflake’s virtual warehouses?

Options:

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Permanent storage of micro-partitions

Buy Now
Questions 27

Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

Options:

A.

The number of queries executed

B.

The number of active users assigned to the warehouse

C.

The size of the virtual warehouse

D.

The length of time the warehouse is running

E.

The duration of the queries that are executed

Buy Now
Questions 28

Which Snowflake architectural layer is responsible for a query execution plan?

Options:

A.

Compute

B.

Data storage

C.

Cloud services

D.

Cloud provider

Buy Now
Questions 29

What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

Options:

A.

The warehouse size does not change until all queries currently running in the warehouse have completed.

B.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

C.

The warehouse size does not change until the warehouse is suspended and restarted.

D.

It does not return from the command until the warehouse has finished changing its size.

Buy Now
Questions 30

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Options:

A.

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B.

Scaling out adds clusters of varying sizes to a virtual warehouse.

C.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Buy Now
Questions 31

How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Options:

A.

Configure the warehouse to a size larger than generally required

B.

Set the minimum and maximum clusters to autoscale

C.

Use the standard warehouse scaling policy

D.

Use the economy warehouse scaling policy

Buy Now
Questions 32

How are serverless features billed?

Options:

A.

Per second multiplied by an automatic sizing for the job

B.

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

C.

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D.

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Buy Now
Questions 33

What is true about sharing data in Snowflake? (Choose two.)

Options:

A.

The Data Consumer pays for data storage as well as for data computing.

B.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C.

A Snowflake account can both provide and consume shared data.

D.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E.

The Data Consumer pays only for compute resources to query the shared data.

Buy Now
Questions 34

What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

Options:

A.

Standard

B.

Enterprise

C.

Business Critical

D.

Virtual Private Snowflake

Buy Now
Questions 35

Which Snowflake tool would be BEST to troubleshoot network connectivity?

Options:

A.

SnowCLI

B.

SnowUI

C.

SnowSQL

D.

SnowCD

Questions 36

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options:

A.

INSERT

B.

PUT

C.

GET

D.

COPY

Buy Now
Questions 37

Which Snowflake layer is always leveraged when accessing a query from the result cache?

Options:

A.

Metadata

B.

Data Storage

C.

Compute

D.

Cloud Services

Buy Now
Questions 38

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?

(Choose all that apply.)

Options:

A.

JDBC

B.

SnowSQL

C.

Snowflake Web Interface (UI)

D.

ODBC

E.

Python

D18912E1457D5D1DDCBD40AB3BF70D5D

Buy Now
Questions 39

True or False: Data Providers can share data with only the Data Consumer.

Options:

A.

True

B.

False

Buy Now
Questions 40

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

Options:

A.

True

B.

False

Buy Now
Questions 41

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

Options:

A.

The complexity of each query

B.

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

C.

The size of the data required for each query

D.

The tool that s executing the query

Buy Now
Questions 42

True or False: It is possible to load data into Snowflake without creating a named File Format object.

Options:

A.

True

B.

False

Buy Now
Questions 43

True or False: A single database can exist in more than one Snowflake account.

Options:

A.

True

B.

False

Buy Now
Questions 44

What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

Options:

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Buy Now
Questions 45

What are the three layers that make up Snowflake’s architecture?

Choose 3 answer

Options:

A.

Compute

B.

Tri-Secret Secure

C.

Storage

D.

Cloud Services

Buy Now
Questions 46

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 47

Which of the following statements are true about Schemas in Snowflake? (Choose two.)

Options:

A.

A Schema may contain one or more Databases

B.

A Database may contain one or more Schemas

C.

A Schema is a logical grouping of Database Objects

D.

Each Schema is contained within a Warehouse

Buy Now
Questions 48

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 49

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

Options:

A.

Standard

B.

Premier

C.

Enterprise

D.

Business Critical Edition

Buy Now
Questions 50

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Options:

A.

To accommodate more queries

B.

To accommodate more users

C.

To accommodate fluctuations in workload

D.

To accommodate a more complex workload

Buy Now
Questions 51

True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

Options:

A.

True

B.

False

Buy Now
Questions 52

True or False: The COPY command must specify a File Format in order to execute.

Options:

A.

True

B.

False

Questions 53

True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Options:

A.

True

B.

False

Buy Now
Questions 54

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

Options:

A.

More micro-partitions

B.

Better query scheduling

C.

Double the numbers of servers In the compute duster

D.

Higher storage costs

Buy Now
Questions 55

True or False: Snowflake supports federated authentication in all editions.

Options:

A.

True

B.

False

Buy Now
Questions 56

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

Options:

A.

On-premise availability

B.

Simplicity

C.

Open source based

D.

Concurrency

E.

Performance

Buy Now
Questions 57

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

Options:

A.

True

B.

False

Buy Now
Questions 58

Which of the following statements would be used to export/unload data from Snowflake?

Options:

A.

COPY INTO @stage

B.

EXPORT TO @stage

C.

INSERT INTO @stage

D.

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Buy Now
Questions 59

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

Options:

A.

Custom

B.

Economy

C.

Optimized

D.

Standard

Buy Now
Questions 60

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.

Options:

A.

True

B.

False

Buy Now
Questions 61

True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

Options:

A.

True

B.

False

Buy Now
Questions 62

True or False: During data unloading, only JSON and CSV files can be compressed.

Options:

A.

True

B.

False

Buy Now
Questions 63

Which of the following are options when creating a Virtual Warehouse?

Options:

A.

Auto-suspend

B.

Auto-resume

C.

Local SSD size

D.

User count

Buy Now
Questions 64

The PUT command: (Choose two.)

Options:

A.

Automatically creates a File Format object

B.

Automatically uses the last Stage created

C.

Automatically compresses files using Gzip

D.

Automatically encrypts files

Buy Now
Questions 65

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?

(Choose all that apply.)

Options:

A.

Growth of storage and compute are tightly coupled together

B.

Storage expands without the requirement to add more compute

C.

Compute can be scaled up or down without the requirement to add more storage

D.

Multiple compute clusters can access stored data without contention

Buy Now
Questions 66

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Options:

A.

Number of users

B.

Warehouse size

C.

Amount of data processed

D.

# of clusters for the Warehouse

Buy Now
Questions 67

Which of the following roles is recommended to be used to create and manage users and roles?

Options:

A.

SYSADMIN

B.

SECURITYADMIN

C.

PUBLIC

D.

ACCOUNTADMIN

Buy Now
Questions 68

When can a Virtual Warehouse start running queries?

Options:

A.

12am-5am

B.

Only during administrator defined time slots

C.

When its provisioning is complete

D.

After replication

Buy Now
Questions 69

Which of the following objects can be cloned? (Choose four.)

Options:

A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users

Buy Now
Questions 70

Which type of table corresponds to a single Snowflake session?

Options:

A.

Temporary

B.

Translent

C.

Provisional

D.

Permanent

Buy Now
Questions 71

What feature can be used to reorganize a very large table on one or more columns?

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Buy Now
Questions 72

In which use cases does Snowflake apply egress charges?

Options:

A.

Data sharing within a specific region

B.

Query result retrieval

C.

Database replication

D.

Loading data into Snowflake

Buy Now
Questions 73

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

Options:

A.

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

B.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

C.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

D.

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Buy Now
Questions 74

What are ways to create and manage data shares in Snowflake? (Select TWO)

Options:

A.

Through the Snowflake web interface (Ul)

B.

Through the DATA_SHARE=TRUE parameter

C.

Through SQL commands

D.

Through the enable__share=true parameter

E.

Using the CREATE SHARE AS SELECT * TABLE command

Buy Now
Questions 75

How long is Snowpipe data load history retained?

Options:

A.

As configured in the create pipe settings

B.

Until the pipe is dropped

C.

64 days

D.

14 days

Buy Now
Questions 76

Which Snowflake feature is used for both querying and restoring data?

Options:

A.

Cluster keys

B.

Time Travel

C.

Fail-safe

D.

Cloning

Questions 77

What SQL command would be used to view all roles that were granted to user.1?

Options:

A.

show grants to user USER1;

B.

show grants of user USER1;

C.

describe user USER1;

D.

show grants on user USER1;

Buy Now
Questions 78

What is the default File Format used in the COPY command if one is not specified?

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Buy Now
Questions 79

Which of the following commands cannot be used within a reader account?

Options:

A.

CREATE SHARE

B.

ALTER WAREHOUSE

C.

DROP ROLE

D.

SHOW SCHEMAS

E.

DESCRBE TABLE

Buy Now
Questions 80

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

Options:

A.

True

B.

False

Buy Now
Questions 81

Which command is used to unload data from a Snowflake table into a file in a stage?

Options:

A.

COPY INTO

B.

GET

C.

WRITE

D.

EXTRACT INTO

Questions 82

Which services does the Snowflake Cloud Services layer manage? (Select TWO).

Options:

A.

Compute resources

B.

Query execution

C.

Authentication

D.

Data storage

E.

Metadata

Buy Now
Questions 83

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?

Options:

A.

Okta Verify

B.

Duo Mobile

C.

Microsoft Authenticator

D.

Google Authenticator

Buy Now
Questions 84

What is the recommended file sizing for data loading using Snowpipe?

Options:

A.

A compressed file size greater than 100 MB, and up to 250 MB

B.

A compressed file size greater than 100 GB, and up to 250 GB

C.

A compressed file size greater than 10 MB, and up to 100 MB

D.

A compressed file size greater than 1 GB, and up to 2 GB

Questions 85

Which data type can be used to store geospatial data in Snowflake?

Options:

A.

Variant

B.

Object

C.

Geometry

D.

Geography

Questions 86

Which command can be used to load data into an internal stage?

Options:

A.

LOAD

B.

copy

C.

GET

D.

PUT

Questions 87

What is a key feature of Snowflake architecture?

Options:

A.

Zero-copy cloning creates a mirror copy of a database that updates with the original

B.

Software updates are automatically applied on a quarterly basis

C.

Snowflake eliminates resource contention with its virtual warehouse implementation

D.

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

E.

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Buy Now
Questions 88

What tasks can be completed using the copy command? (Select TWO)

Options:

A.

Columns can be aggregated

B.

Columns can be joined with an existing table

C.

Columns can be reordered

D.

Columns can be omitted

E.

Data can be loaded without the need to spin up a virtual warehouse

Buy Now
Questions 89

How would you determine the size of the virtual warehouse used for a task?

Options:

A.

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B.

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C.

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D.

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Buy Now
Questions 90

Which of the following describes how clustering keys work in Snowflake?

Options:

A.

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

B.

Clustering keys sort the designated columns over time, without blocking DML operations

C.

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

D.

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Buy Now
Questions 91

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

Options:

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Buy Now
Questions 92

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Options:

A.

Via the Snowflake Web Interface (Ul)

B.

Via the data_share=true parameter

C.

Via SQL commands

D.

Via Virtual Warehouses

Buy Now
Questions 93

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Buy Now
Questions 94

Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

Options:

A.

ROLES

B.

POLICY_REFERENCES

C.

QUERY_HISTORY

D.

RESOURCE_MONIT ORS

E.

ACCESS_HISTORY

Questions 95

User-level network policies can be created by which of the following roles? (Select TWO).

Options:

A.

ROLEADMIN

B.

ACCOUNTADMIN

C.

SYSADMIN

D.

SECURITYADMIN

E.

USERADMIN

Buy Now
Questions 96

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Options:

A.

The ability to scale up warehouses

B.

The use of warehouse auto scaling

C.

The ability to resize warehouses

D.

Use of multi-clustered warehouses

E.

The use of warehouse indexing

Buy Now
Questions 97

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

Options:

A.

An FTP server with TLS encryption

B.

An HTTPS server with WebDAV

C.

A Google Cloud storage bucket

D.

A Windows server file share on Azure

Buy Now
Questions 98

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:

COPY INTO my__table FROM @my__stage;

The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.

If the user runs the same copy into command what will happen?

Options:

A.

All data from all of the files on the stage will be appended to the table

B.

Only data about new customers from the new files will be appended to the table

C.

The operation will fail with the error uncertain files in stage.

D.

All data from only the newly-added files will be appended to the table.

Buy Now
Questions 99

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Exam Code: COF-R02
Exam Name: SnowPro Core Recertification Exam
Last Update: May 19, 2024
Questions: 330
$64  $159.99
$48  $119.99
$40  $99.99
buy now COF-R02