SnowPro-Core Dumps SnowPro-Core Braindumps SnowPro-Core Real Questions SnowPro-Core Practice Test SnowPro-Core dumps free
SnowPro Core Certification
https://killexams.com/pass4sure/exam-detail/SnowPro-Core
Question: 187
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? A . More micro-partitions
B . Better query scheduling
C . Double the numbers of servers In the compute duster D . Higher storage costs
Question: 188
True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).
A . True B . False
Question: 189
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: 190
For a multi-cluster Warehouse, the number of credits billed is calculated on: A . The number of queries that ran using the Warehouse.
B . The size of the Warehouse and the number of clusters that ran within a given time period.
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.
Question: 191
Increasing the size of a Virtual Warehouse from an X-Small to an X-Large is an example of: A . Scaling rhythmically
B . Scaling max C . Scaling out D . Scaling up
Question: 192
Fail-safe is unavailable on which table types? A . Temporary
B . Translent C . Provisional D . Permanent
Question: 193
Which of the following statements is true of data loading?
A . Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast B . The "deal file size for loading is 16MB to match micro-partition size
C . Marry files in the 10-lOOMB range tend to land In the ‘sweet spot" for load parallelism Once loaded, there is no option to force a reload of an already loaded file
Question: 194
Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)? A . Database
B . Tables
C . Warehouses D . Worksheets
Question: 195
As a best practice, clustering keys should only be defined on tables of which minimum size? A . Multi-Kilobyte (KB) Range
B . Multi-Megabyte (MB) Range C . Multi-Gigabyte (GB) Range
D . Multi-Terabyte (TB) Range
Question: 196
Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers
A . SHOW TABLES;
B . SHOW STORAGE BY TABLE;
C . Information Schema -> TABLE_STORAGE_METRICS D . Information Schema -> TASLE_HISTORY
Question: 197
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse. A . True
B . False
Question: 198
What is the recommended method for loading data into Snowflake? A . Load row by row
B . Load data in batch
C . Load data by writing it In the Snowflake Web Interface (UI) D . Load data via frequent, angle row DML’s
Question: 199
In which layer of its architecture does Snowflake store its metadata statistics? A . Storage Layer
B . Compute Layer C . Database Layer
D . Cloud Service Layer
Question: 200
When creating a user it is advisable sable to: Choose 2 answers A . Set the user to be initially disabled
B . Force an immediate password change C . Set a default role for the user
D . Set the number of minutes to unlock to 15 minutes
E . Set the users access to expire within a specified timeframe