CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps (page: 24)

Page 23 of 83
PDF with 330 Questions

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

  1. The table contains a column that has very low cardinality
  2. DML statements that are being issued against the table are blocked
  3. The table has a small number of micro-partitions
  4. Queries on the table are running slower than expected
  5. The clustering depth for the table is large

Answer(s): A,E



Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

  1. Pipe
  2. External stage
  3. Task
  4. Stream

Answer(s): A

Explanation:

Snowpipe enables loading data from files as soon as they’re available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.


Reference:

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



A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?


  1. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

  2. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDMYSCHEMA TO USER USER1;

  3. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

  4. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer(s): B



What is the default character set used when loading CSV files into Snowflake?

  1. UTF-8
  2. UTF-16
  3. ISO S859-1
  4. ANSI_X3.A

Answer(s): A

Explanation:

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).


Reference:

https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for%20loading.






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts