Practice Free COF-C03 Exam Online Questions
CHALLENGE 3 ― Cloud Planning Evidence Separation
The modernization lead wants to include the SAP HANA Cloud environment in the same readiness status as the first close systems because the cloud database is provisioned and has limited reporting data. The cloud evidence package does not include matching monitoring or recovery validation.
What is the best response?
- A . Include the cloud database in the same status because provisioning and limited data prove readiness.
- B . Keep cloud planning evidence separate until cloud-specific monitoring and recovery evidence are available.
- C . Use the upgraded on-premises system’s close evidence as the SAP HANA Cloud readiness record.
- D . Stop cloud transition planning until the current close system is fully retired.
A table is created with a column set to a data type of CHARACTER(25).
If the table is viewed in the database section of Snowsight, what data type will be shown for the column?
- A . STRING(25)
- B . TEXT(25)
- C . VARCHAR(25)
- D . CHARACTER(25)
What is SnowSQL used for?
- A . Developing dashboards
- B . Loading and unloading data
- C . Developing Snowflake Native Apps
- D . Monitoring data transformation activity
Which view shows the column lineage within an account?
- A . ACCESS_HISTORY
- B . ALERT_HISTORY
- C . DATA_QUALITY_MONITORING_USAGE_HISTORY
- D . EXTERNAL_ACCESS_HISTORY
A Developer has scheduled a dynamic table to refresh incrementally, but the process uses a full refresh instead .
When used, which query operator will cause a full refresh instead of the scheduled incremental refresh?
- A . DISTINCT
- B . GROUP BY
- C . LATERAL JOIN
- D . UNION ALL
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production.
How can data be easily transferred from the production account to the non-production account?
- A . Clone the data from the production account to the non-production account.
- B . Create a data share from the production account to the non-production account.
- C . Create a subscription in the production account and have it published to the non-production account.
- D . Create a reader account using the production account and link the reader account to the non-production account.
Which table type is supported by Open Catalog to provide centralized, read and write access to a table?
- A . Hybrid
- B . Iceberg
- C . Dynamic
- D . Event
What can a data consumer do with a Snowflake listing?
- A . Publish the listing.
- B . Create another listing from the shared listing.
- C . Establish security parameters for listing access.
- D . Request a copy of the data set used to create the listing.
What feature specifies which roles are allowed to see a particular record in a table?
- A . Dynamic Data Masking
- B . Secure Data Sharing
- C . Row access policy
- D . Object tagging
A team needs to monitor and receive alerts for Snowpipe credit usage.
Why should a custom budget be used instead of a resource monitor?
- A . The custom budget is the only tool that can automatically send alert emails to users outside the ACCOUNTADMIN role.
- B . Resource monitors can only track costs for one virtual warehouse, but custom budgets monitor the entire account.
- C . Custom budgets track historical spending, while a resource monitor provides a cost forecast.
- D . Custom budgets can track costs by object tags and include serverless features.