2024年最新のCOF-C02試験解答最新版JPNTest COF-C02のPDF問題集をダウンロードせよ(503問題と解答)
無料2024年最新のSnowPro Core COF-C02問題集を提供しております!JPNTest
質問 # 86
Which Snowflake partner specializes in data catalog solutions?
- A. Alation
- B. Tableau
- C. dbt
- D. DataRobot
正解:A
解説:
Explanation
Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html
質問 # 87
What action can a user take to address query concurrency issues?
- A. Enable the query acceleration service.
- B. Resize the virtual warehouse to a larger instance size.
- C. Add additional clusters to the virtual warehouse
- D. Enable the search optimization service.
正解:C
質問 # 88
What happens when a cloned table is replicated to a secondary database? (Select TWO)
- A. The replication will not be successful.
- B. The physical data is replicated
- C. Additional costs for storage are charged to a secondary account
- D. Metadata pointers to cloned tables are replicated
- E. A read-only copy of the cloned tables is stored.
正解:B、C
解説:
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.
質問 # 89
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
- A. Information Schema -> TABLE_STORAGE_METRICS
- B. Information Schema -> TABLE_FUNCTION
- C. SHOW STORAGE BY TABLE;
- D. SHOW TABLES;
- E. Information Schema -> TABLE_HISTORY
正解:A、C
質問 # 90
Which file function gives a user or application access to download unstructured data from a Snowflake stage?
- A. BUILD_SCOPED_FILE_URL
- B. GET_PRESIGNED_URL
- C. BUILD_STAGE_FILE_URL
- D. GET STAGE LOCATION
正解:B
質問 # 91
How are network policies defined in Snowflake?
- A. They are a set of rules that dictate how Snowflake accounts can be used between multiple users.
- B. They are a set of rules that define the network routes within Snowflake.
- C. They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.
- D. They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connect
正解:D
解説:
to Snowflake.
質問 # 92
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
- A. STRIP_NULL_VALUES
- B. VALIDATION_MODE
- C. REPLACE_INVALID_CHARACTERS
- D. SKIP_BYTE_ORDER_MARK
正解:B
解説:
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURN_n_ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead of loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:
質問 # 93
True or False: When a new Snowflake object is created, it is automatically owned by the user who created it.
- A. False
- B. True
正解:B
質問 # 94
Which of the following are benefits of micro-partitioning? (Select TWO)
- A. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
- B. Micro-partitions are immutable objects that support the use of Time Travel.
- C. Rows are automatically stored in sorted order within micro-partitions
- D. Micro-partitions cannot overlap in their range of values
- E. Micro-partitions can be defined on a schema-by-schema basis
正解:C、D
解説:
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
質問 # 95
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
- A. Grant the additional privileges to the ORGADMIN role.
- B. Grant the additional privileges to the SYSADMIN role.
- C. Grant the additional privileges to a custom role.
- D. Grant the additional privileges to the ACCOUNTADMIN role.
正解:C
質問 # 96
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
- A. ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- B. GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;
- C. GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;
- D. GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;
正解:B
質問 # 97
What is a limitation of a Materialized View?
- A. A Materialized View cannot be joined with other tables
- B. A Materialized View cannot be defined with a JOIN
- C. A Materialized View cannot support any aggregate functions
- D. A Materialized View can only reference up to two tables
正解:B
解説:
There are several limitations to using materialized views:
A materialized view can query only a single table.
Joins, including self-joins, are not supported.
質問 # 98
Which Snowflake URL type is used by directory tables?
- A. File
- B. Virtual-hosted style
- C. Scoped
- D. Pre-signed
正解:A
質問 # 99
How does a scoped URL expire?
- A. The encoded URL access is permanent.
- B. When the persisted query result period ends.
- C. The length of time is specified in the expiration_time argument.
- D. When the data cache clears.
正解:B
質問 # 100
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
- A. OPERATE
- B. MODIFY
- C. MONITOR
- D. USAGE
正解:A
解説:
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg
質問 # 101
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
- A. list @file__stage
- B. verify @file__stage
- C. show @file__stage
- D. view @file__stage
正解:A
質問 # 102
What technique does Snowflake use to limit the number of micro-partitions scanned by each query?
- A. Map reduce
- B. Pruning
- C. B-tree
- D. Indexing
正解:A
質問 # 103
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 different values
- D. Set the Minimum Clusters and Maximum Clusters settings to the same value
正解:C
質問 # 104
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
- A. True
- B. False
正解:B
質問 # 105
Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?
- A. Information_schema.warehouse_load_history
- B. Account_usage. query_history
- C. Resource monitor
- D. Information schema.warehouse metering history
正解:B
質問 # 106
The Snowflake Search Optimization Services supports improved performance of which kind of query?
- A. Selective point lookup queries
- B. Queries against tables larger than 1 TB
- C. Queries against a subset of columns in a table
- D. Queries against large tables where frequent DML occurs
正解:A
解説:
Reference:
%20point,OBJECT%2C%20and%20ARRAY%20columns)
質問 # 107
What type of function returns one value for each Invocation?
- A. Table
- B. Window
- C. Scalar
- D. Aggregate
正解:C
質問 # 108
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A. POLICY_REFERENCES
- B. ACCESS_HISTORY
- C. QUERY_HISTORY
- D. ROLES
- E. RESOURCE_MONIT ORS
正解:A、C
解説:
https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%20POLICY-,Auditing%20Dynamic%20Data%20Masking,a%20masking%20policy%20is%20set.
質問 # 109
What can a user win a reader account do in Snowflake?
- A. Update existing data
- B. Create a new snare
- C. Query shared data
- D. Load now data
正解:C
質問 # 110
......
COF-C02試験解答問題集:https://www.jpntest.com/shiken/COF-C02-mondaishu(503問題と解答)