Steps Necessary To Pass The SnowPro-Core Exam from Training Expert VCE4Dumps
Valid Way To Pass SnowPro Core's SnowPro-Core Exam
NEW QUESTION 70
Which of the following commands sets the Virtual Warehouse for a session?
- A. SET warehouse = <<warehouse name>>;
- B. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
- C. USE WAREHOUSE <<warehouse name>>;
- D. COPT WAREHOUSE FROM <<Config file> ;
Answer: C
NEW QUESTION 71
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
- A. Set the Minimum Clusters and Maximum Clusters settings to the different values
- B. Configure the Maximum Clusters setting to "Auto-Scale"
- C. Set the Warehouse type to "Auto"
- D. Set the Minimum Clusters and Maximum Clusters settings to the same value
Answer: A
NEW QUESTION 72
True or False: A single database can exist in more than one Snowflake account.
- A. False
- B. True
Answer: A
NEW QUESTION 73
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A. False
- B. True
Answer: A
NEW QUESTION 74
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 Stage
- B. Continuous load using Snowpipe REST API
- C. Bulk copy from an Internal Stage
- D. The Snowflake Web Interface (UT) data loading wizard
Answer: A,B,D
NEW QUESTION 75
Which of the following statements is true of zero-copy cloning?
- A. Zero-copy clones increase storage costs as cloning the table requires storing its data twice
- B. At the instance/instant a clone is created, all micro-partitions in the original table and the clone are fully shared
- C. Zero-copy cloning is licensed as an additional Snowflake feature
- D. All zero-copy clone objects inherit the privileges of their original objects
Answer: B
Explanation:
Explanation/Reference: https://community.snowflake.com/s/question/0D50Z00009D8VOd/zero-copy-cloning-base-data
NEW QUESTION 76
True or False: A third-party tool that supports standard JDBC or ODBC but has no Snowflake-specific driver will be unable to connect to Snowflake.
- A. True
- B. False
Answer: A
NEW QUESTION 77
Which of the following commands sets the Virtual Warehouse for a session?
- A. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
- B. USE WAREHOUSE <<warehouse name>>;
- C. COPY WAREHOUSE FROM <<config file>>;
- D. SET WAREHOUSE = <<warehouse name>>;
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
NEW QUESTION 78
Which type of table corresponds to a single Snowflake session?
- A. Provisional
- B. Temporary
- C. Transient
- D. Permanent
Answer: B
NEW QUESTION 79
True or False: Snowflake charges additional fees to Data providers for each share they create.
- A. False
- B. True
Answer: A
NEW QUESTION 80
Which of the following DML commands isn't supported by Snowflake?
- A. TRUNCATE TABLE
- B. UPSERT
- C. UPDATE
- D. MERGE
Answer: B
NEW QUESTION 81
Which of the following DML commands isn't supported by Snowflake?
- A. TRUNCATE TABLE
- B. UPSERT
- C. UPDATE
- D. MERGE
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html
NEW QUESTION 82
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:
- A. SECURITYADMIN, ACCOUNTADMIN
- B. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
- C. ACCOUNTADMIN
- D. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
Answer: C
NEW QUESTION 83
On which of the following cloud platform can a Snowflake account be hosted?
Choose 2 answers
- A. Private Virtual Cloud
- B. Oracle Cloud
- C. Microsoft Azure Cloud
- D. Amazon Web Services
Answer: C,D
NEW QUESTION 84
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Custom
- B. Optimized
- C. Standard
- D. Economy
Answer: C,D
NEW QUESTION 85
Which of the following statements are true about Schemas in Snowflake? (Choose two.)
- A. Each Schema is contained within a Warehouse
- B. A Schema may contain one or more Databases
- C. A Schema is a logical grouping of Database Objects
- D. A Database may contain one or more Schemas
Answer: C,D
NEW QUESTION 86
True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.
- A. False
- B. True
Answer: A
NEW QUESTION 87
The Query History in the Snowflake Web Interface (UI) is kept for approximately:
- A. 60 minutes
- B. 14 days
- C. 24 hours
- D. 1 year
- E. 30 days
Answer: D
NEW QUESTION 88
Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers
- A. Temporary Tables
- B. Translent Tables
- C. Provisional Tables
- D. Permanent Tables
Answer: A,B
NEW QUESTION 89
Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.
- A. Account -> Schema -> Database -> Table
- B. Database -> Table -> Schema -> Account
- C. Account -> Database -> Schema -> Table
- D. Database -> Schema -> Table -> Account
Answer: C
NEW QUESTION 90
Which of the following is true of Snowpipe via REST API?
Choose 2 answers
- A. Snowpipe keeps track of which files it has loaded
- B. Snowflake automatically manages the compute required to execute the Pipe's copy into commands
- C. All COPY INTO options are available fluting pipe creation
- D. you can only use it on internal Stages
Answer: A,C
NEW QUESTION 91
Which of the following statements are true of Snowflake releases: (Choose two.)
- A. They happen approximately weekly
- B. During a release, new customer requests/queries/connections transparently move over to the newer version
- C. They roll up and release approximately monthly, but customers can request early release application
- D. A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded
Answer: B,D
NEW QUESTION 92
True or False: It is possible to load data into Snowflake without creating a named File Format object.
- A. True
- B. False
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html
NEW QUESTION 93
......
All SnowPro-Core Dumps and SnowPro Core Certification Exam Training Courses: https://www.vce4dumps.com/SnowPro-Core-valid-torrent.html
Free Test Engine For SnowPro Core Certification Exam Certification Exams: https://drive.google.com/open?id=1_zL4SXliFb8jtXYJ5OLfDJgVp_P340cf