Snow-Pro-Core Certification Preparation Course Questions & Answers, Rated A+ Question: 1 latest 2024/25 exam prediction paper/ APPROVED.

Snow-Pro-Core Certification Preparation Course Questions & Answers, Rated A+ Question: 1 What command is used to load files into an Internal Stage within Snowflake? Select one. - -A. PUT B. COPY INTO C. TRANSFER D. INSERT Question: 2 When loading data into Snowflake, the COPY command supports: Choose 2 answers - -A. Joins B. Fitters C. Data type conversions D. Column reordering E. Aggregates Question: 3 True or False: Snowpipe via RFST API can only reference External Stages as source. - -A. True B. False Question: 4 On which of the following cloud platform can a Snowflake account be hosted? Choose 2 answers - -A. Amazon Web Services B. Private Virtual Cloud C. Oracle Cloud D. Microsoft Azure Cloud Question: 5 How would you execute a series of SQL statements using Task? - - Maximum number of tasks in a tree - -1000 SNOWSQL default directory - -~/.snowsql%USERPROFILE% .snowsql set configuration - --o or --option !set config Can you run snowDC for HTTP - -Yes Who can create database from share - -AccountAdmin or the one with Import Share permissions Data Sharing & Data Replication - does they support Future grants - -No What will happen to PIPE when you Clone Database of Schema - -it will clone PIPE How many days - Load History in metadata for Table Copy - -64 How many days - History in metadata for Snow PIPE - -14 What is data exchange in snowflake - -It is a market place that utilize secure data sharing What does newly created reader account contains - -Only one user - Administrator Can you share a Standard View - -No Can you share a Secure View - -Yes Can you share data from multiple database - -Yes, as long as they belong to same account by creating secure Views What access is needed to share secure View - -You should give REFERENCE_USAGE privilege on each database referenced by Secure View No Need to grant REFERENCE_USAGE on database where Secure View is created What does each Share consist of - -Privileges that grant access to the database and schema containing. Specific Objects Consumer Accounts Snowflake SCIM Can be used to - -Manage User Manage Roles Auditing SCIM Can import roles from - -Okta Azure AD Custom build applications Encrypted Key Hirearcy - -Root key Account Master Key Table Key File Key When databases is cloned,what will happen to Future Objects Privilege - -They copy the Privilege from source schema Does DataSharing and Data Replication support Future granting - -No Will Clone Objects will clone Privileges - -No Does OUATH support Key Pair Authentication - -Yes Who can Grant Privileges with Managed Access Schema - -Schema Owner Role with Mange Grants Privilege How does SNowflake Support OAUTH - -Through Integration Native IDP Provider - -Okta Microsft ADFS Network Policies support what Protocol(IPV4 or IPV6 or both) - -IPV4 Types of Parameters - -Account Session Object Access required to Modify Resource Monitor - -Modify Monitor Data Transfer Charges - -Same Cloud Platform - One Region to Other region. Out of Cloud Platform - Everythin