Guide (New 2022) Actual Snowflake SnowPro-Core Exam Questions
SnowPro-Core Exam Dumps Pass with Updated 2022 Certified Exam Questions
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Catalog & Objects
- Warehouse Caching
- Tables
- Sharing Configuration & Access Control options
- Data Types
- Views
- Micro partitions
- Data Sharing
- Warehouse Management
- Providers, Consumers & Reader Accounts
- Database & Schema
- Secure Data Sharing
- Warehouse Sizing & Scaling
- Compute
Understanding functional and technical aspects of SnowPro Core Certification
The following will be discussed in SNOWFLAKE SNOWPRO CORE dumps:
- Differences Between Account Usage and Information Schema
- Federated Authentication & SSO
- Warehouse & Storage credit usage
- Data Encryption
- DR & Replication
- Information Schema
- Multi-Factor Authentication (MFA)
NEW QUESTION 90
True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.
- A. True
- B. False
Answer: B
NEW QUESTION 91
Which formats are supported for unloading data from Snowflake?
Choose 2 answers
- A. Avro
- B. ISON
- C. Delimited (CSV, TSV, etc.)
- D. ORC
Answer: B,C
NEW QUESTION 92
What privileges are required to execute a task?
- A. Tasks run automatically and do run under any rote.
- B. A task is an account-level object and can only be executed by the Account Admin role.
- C. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.
- D. To execute a task, you need the EXECUTE TASK.
Answer: D
NEW QUESTION 93
If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:
- A. The last query using the warehouse completes.
- B. There are no users loaned into Snowflake.
- C. The Warehouse is inactive for a specified period of time.
- D. All Snowflake sessions using the warehouse are terminated.
Answer: C
NEW QUESTION 94
For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.
- A. The size of the Warehouse and the number of clusters that ran within a given time period.
- B. The number of queries that ran using the Warehouse.
- C. The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.
- D. The number of users who accessed the Warehouse.
Answer: A
NEW QUESTION 95
Which of the following statements would be used to export/unload data from Snowflake?
- A. COPY INTO @slage
- B. EXPORT TO @stage
- C. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
- D. INSERT INTO @stage
Answer: A
NEW QUESTION 96
Snowflake provides a mechanism for its customers to override its clustering algorithms. This method is:
- A. Clustering keys
- B. Clustered partitions
- C. Micro-partitions
- D. Key partitions
Answer: A
NEW QUESTION 97
Which object allows you to limit the number of credits consumed within a Snowflake account?
- A. Account Usage Tracking
- B. Resource Monitor
- C. Warehouse Limit Parameter
- D. Credit Consumption Tracker
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/resource-monitors.html
NEW QUESTION 98
The FLATEEN function is used to query which type of data in Snowflake?
- A. Semi-structured data
- B. Structured data
- C. None of the above
- D. Both of the above
Answer: A
NEW QUESTION 99
True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.
- A. True
- B. False
Answer: B
NEW QUESTION 100
Which interfaces can be used to create and/or manage Virtual Warehouses?
- A. Data integration tools
- B. All of the above
- C. The Snowflake Web Interface (UI)
- D. SQL commands
Answer: D
NEW QUESTION 101
Which statement best describes Snowflake tables?
- A. Snowflake tables are logical representations of underlying physical data
- B. Snowflake tables require that clustering keys be defined to perform optimally
- C. Snowflake tables are the physical instantiation of data loaded into Snowflake
- D. Snowflake tables are owned by a user
Answer: A
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/tables-micro-partitions.html
NEW QUESTION 102
True or False: Query ID's are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.
- A. True
- B. False
Answer: B
NEW QUESTION 103
In which layer of its architecture does Snowflake store its metadata statistics?
- A. Database Layer
- B. Storage Layer
- C. Compute Layer
- D. Cloud Services Layer
Answer: D
Explanation:
Explanation/Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/
NEW QUESTION 104
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A. Concurrency
- B. Performance
Answer: A
NEW QUESTION 105
True or False: A single database can exist in more than one Snowflake account.
- A. True
- B. False
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html
NEW QUESTION 106
True or false: it is best practice to define a clustering key on every table.
- A. True
- B. False
Answer: B
NEW QUESTION 107
Which of the following statements is true of Snowflake micro-partitioning?
- A. Micro-partitioning has been known to introduce data skew
- B. Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded
- C. Micro-partitioning can be disabled within a Snowflake account
- D. Micro-partitioning: requires a partitioning schema to be defined up front
Answer: B
NEW QUESTION 108
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
- A. True
- B. False
Answer: B
NEW QUESTION 109
......
Pass Guaranteed Quiz 2022 Realistic Verified Free Snowflake: https://exampasspdf.testkingit.com/Snowflake/latest-SnowPro-Core-exam-dumps.html