COF-C02 practice questions 371–380

1. Question 371 · 1323 in bank

   Select 2

   Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

   • ACustom
   • BEconomy
   • COptimized
   • DStandard

   Show answer

   Answer: BD

   Explanation

   Answer is B/D. objectProperties ::= WAREHOUSE_SIZE = XSMALL | SMALL | MEDIUM | LARGE | XLARGE | XXLARGE | XXXLARGE | X4LARGE | X5LARGE | X6LARGE MAX_CLUSTER_COUNT = MIN_CLUSTER_COUNT = SCALING_POLICY = STANDARD | ECONOMY AUTO_SUSPEND = | NULL AUTO_RESUME = TRUE | FALSE INITIALLY_SUSPENDED = TRUE | FALSE RESOURCE_MONITOR = COMMENT = ' '

   Source: Adapted from community discussion — Sundarr

   References

   • Snowflake documentation

   Next question

2. Question 372 · 1323 in bank

   True or False: Snowflake charges a premium for storing semi-structured data.

   • ATrue
   • BFalse

   Show answer

   Answer: B

   Next question

3. Question 373 · 1323 in bank

   How many days is load history for Snowpipe retained?

   • A1 day
   • B7 days
   • C14 days
   • D64 days

   Show answer

   Answer: C

   Explanation

   Bulk data load Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output. Snowpipe Stored in the metadata of the pipe for 14 days. Must be requested from Snowflake via a REST endpoint, SQL table function, or ACCOUNT_USAGE view. source : https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro

   Source: Adapted from community discussion — shyemko

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

4. Question 374 · 1323 in bank

   Select 2

   What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Choose two.)

   • AThe ability to scale up warehouses
   • BThe use of warehouse auto scaling
   • CThe ability to resize warehouses
   • DUse of multi-clustered warehouses
   • EThe use of warehouse indexing

   Show answer

   Answer: BD

   References

   • Snowflake documentation

   Next question

5. Question 375 · 1323 in bank

   Which COPY INTO command outputs the data into one file?

   • ASINGLE=TRUE
   • BMAX_FILE_NUMBER=1
   • CFILE_NUMBER=1
   • DMULTIPLE=FALSE

   Show answer

   Answer: A

   References

   • Snowflake documentation

   Next question

6. Question 376 · 1323 in bank

   Select 2

   In which scenarios would a user have to pay Cloud Services costs? (Choose two.)

   • ACompute Credits = 50 Credits Cloud Services = 10
   • BCompute Credits = 80 Credits Cloud Services = 5
   • CCompute Credits = 100 Credits Cloud Services = 9
   • DCompute Credits = 120 Credits Cloud Services = 10
   • ECompute Credits = 200 Credits Cloud Services = 26

   Show answer

   Answer: AE

   Explanation

   https://docs.snowflake.com/en/user-guide/cost-understanding-compute.html#cloud-service-credit-usage **Usage for cloud services is charged only if the daily consumption of cloud services exceeds 10% of the daily usage of virtual warehouses

   Source: Adapted from community discussion — miadiesel

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

7. Question 377 · 1323 in bank

   A user created a new worksheet within the Snowsight UI and wants to share this with teammates. How can this worksheet be shared?

   • ACreate a zero-copy clone of the worksheet and grant permissions to teammates.
   • BCreate a private Data Exchange so that any teammate can use the worksheet.
   • CShare the worksheet with teammates within Snowsight.
   • DCreate a database and grant all permissions to teammates.

   Show answer

   Answer: C

   Explanation

   Within Snowsight, a user can share a worksheet with teammates by clicking on the "Share" button in the toolbar and then entering the email addresses of the teammates to share the worksheet with. This will grant the specified users view access to the worksheet. A is incorrect as zero-copy clones are used for making a copy of the data that the worksheet is working on, not for sharing the worksheet itself. B is incorrect as private Data Exchange is used for sharing data sets, not worksheets. D is incorrect as creating a database and granting all permissions is not necessary for sharing a worksheet, and granting all permissions is not recommended for security reasons.

   Source: Adapted from community discussion — bibisa

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

8. Question 378 · 1323 in bank

   Select 2

   How can a row access policy be applied to a table or a view? (Choose two.)

   • AWithin the policy DDL
   • BWithin the create table or create view DDL
   • CBy future APPLY for all objects in a schema
   • DWithin a control table
   • EUsing the command ALTER [object] ADD ROW ACCESS POLICY [policy];

   Show answer

   Answer: BE

   Explanation

   B,E Correct. A is not correct as it is only defining not applying to table or view, Question is about applying to table/View https://docs.snowflake.com/en/user-guide/security-row-intro

   Source: Adapted from community discussion — Harpreetwal

   References

   • Snowflake documentation
   • Snowflake documentation

   Next question

9. Question 379 · 1323 in bank

   Which command can be used to load data files into a Snowflake stage?

   • AJOIN
   • BCOPY INTO
   • CPUT
   • DGET

   Show answer

   Answer: C

   References

   • Snowflake documentation
   • Snowflake documentation
   • Snowflake documentation

   Next question

10. Question 380 · 1323 in bank

    Select 2

    What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

    • AReader
    • BConsumer
    • CVendor
    • DStandard
    • EPersonalized

    Show answer

    Answer: DE

    Explanation

    The Snowflake Data Marketplace offers two types of data listings, Standard Data (Free) Listings and Personalized (Private)Data Listings. The key difference between standard and personalized listings is the ability to access the data share. Personalized listings allow you to control which consumers can access the data. A standard listing provides instant access to a published data set. To access the data consumers need to click Get Data button which allows you to create a Database with this dataset and will be added to Databases available. This can be done only by the Account Admin role. A personalized listing allows customers to request specific data sets. To access data from a personalized listing, consumers must submit a request by clicking the Request button, and provide their contact information. Once a request is submitted, the data provider is notified. The provider then contacts the consumer after which a personalized data set is created and shared with the consumer.

    Source: Adapted from community discussion — Rajivnb

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

COF-C02 practice, question 371. 1323 questions available.