Sep-2022 FREE Snowflake SnowPro-Core PRACTICE QUESTIONS AND ANSWERS UPDATES
DEMO FREE BEFORE YOU BUY SnowPro-Core DUMPS
NEW QUESTION 81
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.
- A. True
- B. False
Answer: B
NEW QUESTION 82
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
- A. The ability to resize warehouses
- B. The use of warehouse auto scaling
- C. The ability to scale up warehouses
- D. Use of multi-clustered warehouses
- E. The use of warehouse indexing
Answer: B,D
NEW QUESTION 83
Which of the following are options when creating a virtual Warehouse?
Choose 2 answers
- A. Auto-suspend
- B. Auto resize
- C. Auto-drop
- D. Auto-resume
Answer: A,D
NEW QUESTION 84
True or False: You can define multiple columns within a clustering key on a table.
- A. False
- B. True
Answer: B
NEW QUESTION 85
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- B. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- C. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
- D. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
Answer: A,B
Explanation:
The results cache will only be used if it's the same query AND the same role executing the query
NEW QUESTION 86
The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)
- A. Tables
- B. Internal Stages
- C. Users
- D. Databases
Answer: A,C,D
NEW QUESTION 87
True or False: Snowflake supports federated authentication in all editions.
- A. False
- B. True
Answer: B
NEW QUESTION 88
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
- A. Economy
- B. Standard
- C. Optimized
- D. Custom
Answer: A,B
NEW QUESTION 89
Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)
- A. SnowSQL
- B. ODBC
- C. JDBC
- D. Python
D18912E1457D5D1DDCBD40AB3BF70D5D - E. Snowflake Web Interface (UI)
Answer: A,B,C,D,E
NEW QUESTION 90
What is the default character set used when loading CSV files into Snowflake?
- A. UTF-8
- B. ISO S859-1
- C. ANSI_X3.A
- D. UTF-16
Answer: A
Explanation:
https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading.
For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the encoding to use for loading. For the list of supported character sets, see Supported Character Sets for Delimited Files (in this topic).
NEW QUESTION 91
Which of the following roles is recommended to be used to create and manage users and roles?
- A. SECURITYADMIN
- B. PUBLIC
- C. SYSADMIN
- D. ACCOUNTADMIN
Answer: D
NEW QUESTION 92
A deterministic query is run at 8am, takes 5 minutes, and the results are cached. Which of the following statements are true?
Choose 2 answers
- A. The same exact query will return the precomputed results if the underlying data hasn't changed and the results were last accessed within the previous 24 hour period
- B. The ''24 hour'' on the percomputed results gets renewed every time the exact query is executed
- C. The same exact query will return the precomputed results even if the underlying data has changed as long as the results were last accessed within the previous
- D. The exact query win ALWAYS return me precomputed result set for the RESULT_CACHE_ACTIVE = time period
Answer: C,D
NEW QUESTION 93
Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)
- A. Compute can be scaled up or down without the requirement to add more storage
- B. Storage expands without the requirement to add more compute
- C. Growth of storage and compute are tightly coupled together
- D. Multiple compute clusters can access stored data without contention
Answer: C
Explanation:
Reference:
separate-storage-and-compute-65d2dffd450f
NEW QUESTION 94
Which of the following statements would be used to export/unload data from Snowflake?
- A. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);
- B. COPY INTO @stage
- C. EXPORT TO @stage
- D. INSERT INTO @stage
Answer: B
NEW QUESTION 95
Which of the following terms best describes Snowflake's database architecture?
- A. Columnar shared nothing
- B. Cloud-native shared memory
- C. Multi-cluster, shared data
- D. Shared disk
Answer: C
Explanation:
Explanation
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake's unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today's organizations require.
NEW QUESTION 96
True or False: Data Providers can share data with only the Data Consumer.
- A. False
- B. True
Answer: B
NEW QUESTION 97
Select the three types of tables that exist within Snowflake.
Choose 3 answers
- A. Permanent
- B. Transient
- C. Provisioned
- D. Temporary
Answer: A,B,D
NEW QUESTION 98
When should you consider disabling auto-suspend for a Virtual Warehouse?
Choose 2 answers
- A. When you don't want to have to manually turn on the Warehouse each time a user needs it
- B. When managing a steady workload
- C. When the compute must be available with no delay or lag time
- D. When users will be using compute at different times throughout a 24/7 period
Answer: A,B
NEW QUESTION 99
True or False: The COPY command must specify a File Format in order to execute.
- A. True
- B. False
Answer: B
Explanation:
Explanation
Create Stage:
https://docs.snowflake.com/en/sql-reference/sql/create-stage.html
Create Table (STAGE_FILE_FORMAT option):
https://docs.snowflake.com/en/sql-reference/sql/create-table.html
Copy Into:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
NEW QUESTION 100
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.
- A. True
- B. False
Answer: B
NEW QUESTION 101
Which Snowflake technique can be used to improve the performance of a query?
- A. Indexing
- B. Using INDEX__HINTS
- C. Clustering
- D. Fragmenting
Answer: C
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
NEW QUESTION 102
True or False: The user has to specify which cluster a query will run on in a multi-cluster Warehouse.
- A. False
- B. True
Answer: B
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
NEW QUESTION 103
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- A. Number of partitions scanned
- B. External bytes scanned
- C. Bytes scanned
- D. Bytes sent over the network
- E. Percentage scanned from cache
Answer: A,C
NEW QUESTION 104
Which of the following objects can be shared through secure data sharing?
- A. Task
- B. External table
- C. Stored procedure
- D. Masking policy
Answer: B
Explanation:
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
Snowflake enables the sharing of databases through shares, which are created by data providers and "imported" by data consumers.
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables
NEW QUESTION 105
Which of the following are main sections of the top navigation of the Snowflake Web Interface (UI)? (Choose three.)
- A. Tables
- B. Warehouses
- C. Databases
- D. Worksheets
Answer: B,C,D
Explanation:
Explanation/Reference: https://docs.snowflake.com/en/user-guide/snowflake-manager.html
NEW QUESTION 106
......
Latest Snowflake SnowPro-Core Dumps with Test Engine and PDF: https://www.easy4engine.com/SnowPro-Core-test-engine.html
Snowflake SnowPro-Core Exam Dumps Are Essential To Get Good Marks: https://drive.google.com/open?id=1T-nbUvs87nJ_Iftv9vZa8K-_QBgLZ65S
