The endpoint insertFiles of SnowPipe rest API is used to inform Snowflake about the files to be ingested into a table. Select the two statements for this end point.

• A.The post can contain unlimited number of files.
• B.The post can contain at most 5000 files.
• C.Each file path given must be <= 1024 bytes long when serialized as UTF-8

Comment: *

Name: *

Email: *

Verification: *

Materialized views based on external tables can improve query performance

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *

You got a response code of 429 from the insertFiles API.
What does that mean?

• A.Failure. Invalid request due to an invalid format, or limit exceeded
• B.Failure. pipeName not recognized
• C.Failure. Internal error occurred
• D.Failure. Request rate limit exceeded

Comment: *

Name: *

Email: *

Verification: *

You have written a procedure and a function in snowflake.
How do you find your procedures and functions in snowflake?

• A.SHOW PROCEDURES;
• B.SHOW PROCEDURES, FUNCTIONS
• C.SHOW ALL PROCEDURES AND FUNCTIONS
• D.SHOW FUNCTIONS;

Comment: *

Name: *

Email: *

Verification: *

Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

• A.After the ETL run, execute the identical queries so that they remain in the result cache
• B.After the ETL run, resize the warehouse to a larger warehouse
• C.After the ETL run, copy the tables to another schema for the business users to query

Comment: *

Name: *

Email: *

Verification: *