When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME() or CURRENT_TIMESTAMP() what will occur?

• A.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.
• B.All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.
• C.All rows loaded using a specific COPY statement will have the same timestamp value.
• D.Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

Comment: *

Name: *

Email: *

Verification: *

For which use cases, will you use cross-cloud and cross-region replication?

• A.Business continuity and disaster recovery
• B.All of these
• C.Data portability and account migrations
• D.Secure data sharing across regions/cloud

Comment: *

Name: *

Email: *

Verification: *

What Snowflake features should be leveraged when modeling using Data Vault?

• A.Snowflake's support of multi-table inserts into the data model's Data Vault tables
• B.Data needs to be pre-partitioned to obtain a superior data access performance
• C.Scaling up the virtual warehouses will support parallel processing of new source loads
• D.Snowflake's ability to hash keys so that hash key joins can run faster than integer joins

Comment: *

Name: *

Email: *

Verification: *

The Business Intelligence team reports that when some team members run queries for their dashboards in parallel with others, the query response time is getting significantly slower What can a Snowflake Architect do to identify what is occurring and troubleshoot this issue?

• A.A computer error message Description automatically generated
  
• B.A close up of text Description automatically generated
  
• C.A black text on a white background Description automatically generated
  
• D.A screen shot of a computer Description automatically generated
  

Comment: *

Name: *

Email: *

Verification: *

If a multi-cluster warehouse is resized, the new size applies to

• A.Clusters that are started after the warehouse is resized
• B.All of the above
• C.Clusters that are currently running

Comment: *

Name: *

Email: *

Verification: *