SnowPro-Core Dumps
          SnowPro-Core Braindumps
          SnowPro-Core Real Questions
          SnowPro-Core Practice Test
          SnowPro-Core dumps free






















































            Snowflake



            SnowPro-Core







            SnowPro Core Certification










            http://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





    Answer: C

    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





    Answer: B

    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





    Answer: A,D

    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.





    Answer: B


    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





    Answer: D

    Question: 192

    Fail-safe is unavailable on which table types?
    A . Temporary
    B . Translent
    C . Provisional
    D . Permanent





    Answer: A,B

    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





    Answer: C

    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





    Answer: A,C,D

    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





    Answer: D

    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





    Answer: A,D

    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





    Answer: B

    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





    Answer: B

    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





    Answer: D


    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





    Answer: B,C













                            For More exams visit https://killexams.com/vendors-exam-list







































































                               Kill your exam at First Attempt....Guaranteed!