What happens when an external or an internal stage is dropped? (Select TWO).
A. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
B. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable
C. When dropping an external stage, the files are not removed and only the stage is dropped
D. When dropping an external stage, both the stage and the files within the stage are removed
E. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
正解:A,C
質問 2:
Which Snowflake tool would be BEST to troubleshoot network connectivity?
A. SnowSQL
B. SnowCLI
C. SnowCD
D. SnowUI
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 3:
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
A. Create a task that runs a copy into operation from an external stage every 5 minutes
B. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest
C. Create a task that puts the files in an internal stage and automate the data loading wizard
D. Create a task that runs a GET operation to intermittently check for new files
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 4:
To run a Multi-Cluster Warehouse in auto-scale mode, a user would:
A. Set the Warehouse type to "Auto"
B. Set the Minimum Clusters and Maximum Clusters settings to the different values
C. Set the Minimum Clusters and Maximum Clusters settings to the same value
D. Configure the Maximum Clusters setting to "Auto-Scale"
正解:B
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
A. Cloud infrastructure layer
B. Storage layer
C. Compute layer
D. Cloud services layer
正解:C
解説: (Pass4Test メンバーにのみ表示されます)
質問 6:
When cloning a database, what is cloned with the database? (Choose two.)
A. Only schemas and tables within the database
B. Privileges on the schemas within the database
C. Existing child objects within the database
D. Future child objects within the database
E. Privileges on the database
正解:A,C
加藤** -
ただ覚えるのではなく理解できるようになるCOF-R02試験対策問題で、助かりました。