What happens when a cloned table is replicated to a secondary database? (Select TWO)

• A.A read-only copy of the cloned tables is stored.
• B.The replication will not be successful.
• C.The physical data is replicated
• D.Additional costs for storage are charged to a secondary account
• E.Metadata pointers to cloned tables are replicated

Comment: *

Name: *

Email: *

Verification: *

Which key access control concept does Snowflake descibe as a defined level of access to an object?

• A.Privilege
• B.Grant
• C.Session
• D.Role

Comment: *

Name: *

Email: *

Verification: *

What consideration should be made when loading data into Snowflake?

• A.The number of load operations That run in parallel can exceed the number of data files to be loaded.
• B.Create large data files to maximize the processing overhead for each file.
• C.The number of data files that are processed in parallel is determined by the virtual warehouse.
• D.Create small data files and stage them in cloud storage frequently.

Comment: *

Name: *

Email: *

Verification: *

A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?

• A.list @mytable;
• B.list @%raytable;
• C.list @ %m.ystage;
• D.list @mystage;

Comment: *

Name: *

Email: *

Verification: *

When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?

• A.There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.
• B.There are multiple SQL UDFs with the same names and the same number of argument types.
• C.There are multiple SQL UDFs with different names but the same number of arguments or argument types.
• D.There are multiple SOL UDFs with the same names and the same number of arguments.

Comment: *

Name: *

Email: *

Verification: *