COF-C01 Dumps
          COF-C01 Braindumps
          COF-C01 Real Questions
          COF-C01 Practice Test
          COF-C01 dumps free






















































            SnowFlake



            COF-C01







            SnowPro Core Certification










            http://killexams.com/pass4sure/exam-detail/COF-C01





    Question: 48


    True or False: A single database can exist in more than one Snowflake account.
    A. True
    B. False





    Answer: B

    Explanation:

    Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html


    Question: 49

    True or False: It is possible for a user to run a query against the query result cache without requiring an active
    Warehouse.
    A. True
    B. False





    Answer: B

    Question: 50

    For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.
    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: 51

    True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain
    ownership until it is transferred to another user.
    A. True
    B. False





    Answer: A

    Explanation:


    Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html


    Question: 52

    The Information Schema and Account Usage Share provide storage information for which of the following objects?
    (Choose three.)
    A. Users
    B. Tables
    C. Databases
    D. Internal Stages





    Answer: B,C,D

    Question: 53

    True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
    A. True
    B. False




    Answer: B

    Question: 54


    When loading data into Snowflake, the COPY command supports: Choose 2 answers
    A. Joins
    B. Fitters
    C. Data type conversions
    D. Column reordering
    E. Aggregates





    Answer: C,D

    Question: 55

    Which formats are supported for unloading data from Snowflake? Choose 2 answers
    A. Delimited (CSV, TSV, etc.)
    B. Avro
    C. JSON
    D. ORC





    Answer: A,C

    Explanation:

    Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html


    Question: 56


    To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
    A. Configure the Maximum Clusters setting to “Auto-Scale”
    B. Set the Warehouse type to “Auto”
    C. Set the Minimum Clusters and Maximum Clusters settings to the same value
    D. Set the Minimum Clusters and Maximum Clusters settings to the different values




    Answer: D


    Explanation:

    Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

    Question: 57


    How a Snowpipe charges calculated?
    A. Per-second/per Warehouse size
    B. Per-second/per-core granularity
    C. Number of Pipes in account
    D. Total storage bucket size





    Answer: B

    Explanation:


    Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

    Question: 58

    Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor
    Authentication (MFA):
    A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
    B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
    C. SECURITYADMIN, ACCOUNTADMIN
    D. ACCOUNTADMIN





    Answer: D

    Explanation:

    Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

    Question: 59


    True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.
    A. True
    B. False




    Answer: B

    Explanation:


    Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/
    Question: 60


    Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
    A. Custom
    B. Economy
    C. Optimized
    D. Standard





    Answer: B,D

    Explanation:

    Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance













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







































































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