Nuevas preguntas del examen Snowflake COF-C01 para la preparación de su certificación SnowPro Core

Posted by: Martina Comments: 0 Post Date: junio 14, 2022

Martina2022-06-14T07:35:09+00:00

Al referir el examen COF-C01, es posible que los candidatos no estén familiarizados con él. Sin embargo, cuando se habla del examen SnowPro Core, deben saber que el examen de certificación SnowPro Core es un examen popular para demostrar su conocimiento para aplicar la experiencia básica en la implementación y migración a Snowflake. El hecho es que COF-C01 es el nuevo código de examen para el examen de certificación SnowPro Core desde que Snowflake agregó su servicio en Pearson VUE. Para ayudarlo a prepararse bien para el examen SnowPro Core Certification COF-C01, las nuevas preguntas del examen Snowflake COF-C01 están disponibles en línea. Puedes elegir que sean tus materiales de preparación. Para obtener más información, las preguntas de demostración gratuitas del examen COF-C01 también están disponibles a continuación.

Page 1 of 6

1. True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

True

False

2. True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

True

False

3. Select the three types of tables that exist within Snowflake.

Choose 3 answers

Temporary

Transient

Provisioned

Permanent

4. Which of the following accurately represents how a table fits into Snowflake’s logical container hierarchy?

Account -> Schema -> Database -> Table

Account -> Database -> Schema -> Table

Database -> Schema -> Table -> Account

Database -> Table -> Schema -> Account

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

True

False

6. Which of the following statements is true of Snowflake?

It was built specifically for the cloud

It was built as an on-premises solution and then ported to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

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

True

False

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

True

False

9. Select the different types of Internal Stages: (Choose three.)

Named Stage

User Stage

Table Stage

Schema Stage

10. True or False: You can resize a Virtual Warehouse while queries are running.

True

False

Page 2 of 6

11. Which statement best describes '' clustering''?

Clustering represents the way data is grouped together and stored within snowflake's micro-partitions

The database administrator must define the clustering methodology for each Snowflake table.

The clustering key must be included on the COPV command when loading data into Snowflake.

Clustering can be disabled within a Snowflake account.

12. Snowflake is designed for which type of workloads? (Choose two.)

OLAP (Analytics) workloads

OLTP (Transactional) workloads

Concurrent workloads

On-premise workloads

13. How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

14. What is the maximum compressed row size in Snowflake?

8KB

16MB

50MB

4000GB

15. True or False: Snowpipe via RFST API can only reference External Stages as source.

True

False

16. Which of the following are options when creating a virtual Warehouse? Choose 2 answers

Auto-drop

Auto resize

Auto-resume

Auto-suspend

17. True or False: Users are able to see the result sets of queries executed by other users that share their same role.

True

False

18. True or False: The COPY command must specify a File Format in order to execute.

True

False

19. How many shares can be consumed by single Data Consumer?

100, but can be increased by contacting support

Unlimited

20. When can a Virtual Warehouse start running queries?

12am-5am

Only during administrator defined time slots

When its provisioning is complete

After replication

Page 3 of 6

21. Which statement best describes Snowflake tables?

Snowflake tables are logical representations of underlying physical data

Snowflake tables ate the physical instantiation of data loaded Into Snowflake

Snowflake tables require that clustering keys be defined to perform optimally

Snowflake tables are owned by a user

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

Custom

Economy

Optimized

Standard

23. Which of the following commands are not blocking operations?

Choose 2 answers

UPDATE

INSERT

MERGE

COPY

24. The fail-safe retention period is how many days?

1 day

7 days

45 days

90 days

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

True

False

26. For a multi-cluster Warehouse, the number of credits billed is calculated on: Select one.

The number of queries that ran using the Warehouse.

The size of the Warehouse and the number of clusters that ran within a given time period.

The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

The number of users who accessed the Warehouse.

27. Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

28. Query results are stored in the Result Cache for how long after they are last accessed, assuming no data changes have occurred?

1 Hour

3 Hours

12 hours

24 hours

29. Which of the following statements is true of Snowflake micro-partitioning?

Micro-partitioning has been known to introduce data skew

Micro-partitioning: requires a partitioning schema to be defined up front

Micro-partitioning is transparently completed using the ordering that occurs when the data is inserted/loaded

Micro-partitioning can be disabled within a Snowflake account

30. True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

True

False

Page 4 of 6

31. Which of the following statements is true of data loading?

Resizing the virtual warehouse from x-Small to Small will process a single file twice as fast

The "deal file size for loading is 16MB to match micro-partition size

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

32. What is the lowest Snowflake edition that offers Time Travel up to 90 days.

standard Edition

Premier Edition

Enterprise Edition

Business Critical Edition

33. Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

34. Account-level storage usage can be monitored via:

The snowflake wet Interface (UI) in the Databases section.

The Snowflake web interface (UI) in the Account -> Billing a usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account usage Schema - > ACCOUNT_USAGE_METRICS View

35. Which of the following statements about data sharing are true? choose 2 answers

New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts

All database objects can be included In a shared database

Reader Accounts are created and funded by Data Prowlers

Shared databases are read-only

36. Which formats are supported for unloading data from Snowflake? Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

37. 1.When a pipe is recreated using the CREATE on REPLAC PIPE command: Select one.

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

38. Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):

SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN

SECURITYADMIN ACCOUNTADMIN, SYSADMIN

SECURITYADMIN, ACCOUNTADMIN

ACCOUNTADMIN

39. The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Users

Tables

Databases

Internal Stages

40. True or False: Each worksheet in the Snowflake Web Interface (UI) can be associated with different roles, databases, schemas, and Virtual Warehouses.

True

False

Page 5 of 6

41. To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Configure the Maximum Clusters setting to “Auto-Scale”

Set the Warehouse type to “Auto”

Set the Minimum Clusters and Maximum Clusters settings to the same value

Set the Minimum Clusters and Maximum Clusters settings to the different values

42. True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

True

False

43. Which of the following statements are true of Snowflake releases: (Choose two.)

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer version

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

44. What is the recommended method for loading data into Snowflake?

Load row by row

Load data in batch

Load data by writing it In the Snowflake Web Interface (UI)

Load data via frequent, angle row DML's

45. True or False: AWS Private Link provides a secure connection from the Customer’s on-premise data center to the Snowflake.

True

False

46. Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

47. What is the most granular object that the Time Travel retention period can be defined on?

Account

Database

Schema

Table

48. Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

MIN(< < column value>>)

COPY

SUM(<< column value >>)

UPDATE

49. True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

True

False

50. True or False: During data unloading, only JSON and CSV files can be compressed.

True

False

Page 6 of 6

51. Which type of table corresponds to a single Snowflake session?

Temporary

Translent

Provisional

Permanent

52. What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

INITTIALLY_SUSPENDED = TRUE/FALSE

START_AFTCR_CREATE = TRUE/FALSE

START_TTIME = 60 // (seconds from now)

STAR

TIME = CURREN

DATE()

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

True

False

54. When loading data into Snowflake, the COPY command supports: Choose 2 answers

Joins

Fitters

Data type conversions

Column reordering

Aggregates

55. What happens when a Data Provider revokes privileges to a Share on an object in their source database?

The object immediately becomes unavailable for all Data Consumers

Any additional data arriving after this point in time will not be visible to Data Consumers

The Data Consumers stop seeing data updates and become responsible for storage charges for the object

A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

56. If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

All Snowflake sessions using the warehouse are terminated.

The last query using the warehouse completes.

There are no users loaned into Snowflake.

The Warehouse is inactive for a specified period of time.

57. Which of the following commands sets the Virtual Warehouse for a session?

COPT WAREHOUSE FROM <<Config file> ;

SET warehouse = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

58. What is the minimum duration charged when starting a virtual warehouse?

1 second

1 minute

1 hour

1 day

59. Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answers

SHOW TABLES;

SHOW STORAGE BY TABLE;

Information Schema -> TABLE_STORAGE_METRICS

Information Schema -> TASLE_HISTORY

60. True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

True

False

Nuevas preguntas del examen Snowflake COF-C01 para la preparación de su certificación SnowPro Core

Author

Deja una respuesta Cancelar la respuesta