Udemy Snowpro Core Certification - Practice Questions Test 5; Questions and Answers

Udemy Snowpro Core Certification - Practice Questions
Test 5; Questions and Answers

Which of the following semi-structured file formats are supported by Snowflake? Correct

Ans-- XML


- Parquret


- JSON




The load metadata for a table expires after how many days? Correct Ans-64




t/f Is snowpipe serverless? Correct Ans-True




Which of the following statements are true for Snowpipe? Correct Ans-- Snowpipe uses

servless compute resources managed by Snowflake


- The resource for snowpipe are automatically scaled up and down by snowflake




Which of the following can be used to download data from an external stage to an on-

premises system? Correct Ans-Cloud Provider Utilities

, Udemy Snowpro Core Certification - Practice Questions
Test 5; Questions and Answers

Snowflake provides which of the following methods of data loading? Correct Ans--

Continuous


- Bulk




True or False: The COPY command can load data using a SELECT query. Correct Ans-True




What is the maximum duration of Time Travel allowed in the Snowflake Standard edition?

Correct Ans-1 day




The cloud services layer in Snowflake provides which of the following? Select all that apply.

Correct Ans-- Query optimization


- Authentication


- Query planning


- Authorization




Which of the following is true regarding how table columns are stored in Snowflake?

Correct Ans-- Columns are stored in columnar format within each micropartition