Skip to content
[email protected]
  • Register
  • Log In
Exam4Training Logo
  • Home
  • Exam List
    • Microsoft
  • Online Training
    • Microsoft Online Training
    • Network Appliance Online Training
    • IBM Online Training
    • VMware Online Training
  • All Exams
    • IBM
    • Network Appliance
    • Microsoft
  • Guarantee
  •  

SnowPro Core exam

Home » SnowPro Core exam

Which of the following is true of Snowpipe via REST API? Choose 2 answers

September 4, 2022September 4, 2022examsLeave a comment

Which of the following is true of Snowpipe via REST API? Choose 2 answersA . you can only use it on internal StagesB . All COPY INTO options are available fluting pipe creationC . Snowflake automatically manages the compute required to execute the Pipe’s copy into commandsD . Snowpipe keeps track of which files...

What command is used to load files into an Internal Stage within Snowflake?

September 4, 2022September 4, 2022examsLeave a comment

What command is used to load files into an Internal Stage within Snowflake?A . PUTB . COPY INTOC . TRANSFERD . INSERT View Answer Answer: A Explanation: You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO <table> command...

True or False: All Snowflake table types include fail-safe storage.

September 4, 2022September 4, 2022examsLeave a comment

True or False: All Snowflake table types include fail-safe storage.A . TrueB . False View Answer Answer: B...

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

September 3, 2022September 3, 2022examsLeave a comment

Which of the following describes how clustering keys work in Snowflake?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 operationsC . Clustering keys create a distributed, parallel data structure of pointers to a...

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

September 3, 2022September 3, 2022examsLeave a comment

What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel – 1 day. Fail-safe – 1 dayB . Time Travel – 0 days. Fail-safe – 1 dayC . Time Travel – 1 day. Fail-safe – 0 daysD . Transient tables are retained in neither Fail-safe nor Time Travel...

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

September 3, 2022September 3, 2022examsLeave a comment

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)A . Via the Snowflake Web Interface (Ul)B . Via the data_share=true parameterC . Via SQL commandsD . Via Virtual Warehouses View Answer Answer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html...

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

September 3, 2022September 3, 2022examsLeave a comment

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answersA . Their default role should be set to SYSTEMADMIN (the lower of the two)B . They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those enrolled in MFA are...

What privileges are required to create a task?

September 2, 2022September 2, 2022examsLeave a comment

What privileges are required to create a task?A . The global privilege create task is required to create a new task.B . Tasks are created at the Application level and can only be created by the Account Admin role.C . Many Snowflake DDLs are metadata operations only, and create task DDL can be executed...

which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

September 2, 2022September 2, 2022examsLeave a comment

which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.A . Bulk copy from an External StageB . Continuous load using Snowpipe REST APIC . The Snowflake Web Interface (UT) data loading wizardD . Bulk copy from an Internal Stage View Answer Answer: A,B,C...

True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

September 2, 2022September 2, 2022examsLeave a comment

True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.A . TrueB . False View Answer Answer: B...

Posts navigation

1 2 … 28 Next

Recent Posts

  • Which two networking planes are converged in a VMware NSX-T Data Center? (Choose two.)
  • Which of the following best describes the primary objective of cybersecurity?
  • What could be a solution is the data checker reports that too few records have been selected?
  • What information is needed to create the NAS server?
  • Based on the raw log, which two statements are correct?

Recent Comments

  • Aram on What must be added to the box where the code is missing to prevent a SQL injection attack?
  • Test on How can a developer implement this feature?
  • Jon Fuglsang on Salesforce PDI Dump
  • Sebastian Celeste on DELL EMC DEA-1TT5 Dump
  • Ezra Bisso on Huawei H12-831_V1.0 Dump




© 2023 Exam4Training
  • About Us
  • Privacy Policy
  • Guarantee
  • Facebook