SnowPro Certification || All Answered Correctly.

what does the INFORMATION_SCHEMA hold correct answers a collection of views -holds metadata and other statistics about the database, schema, table, views, etc. T/F the INFORMATION_SCHEMA cannot be deleted, renamed or moved correct answers True T/F the PUBLIC schema is created empty correct answers True T/F you cannot drop, remove or remove the PUBLIC schema correct answers False what things do you need defined for a COPY INTO command correct answers 1. a table 2. a stage 3. a file format how do you know what the most recent line of code you ran was correct answers it will have a blue bar to the left of it context settings correct answers the 4 settings that are saved with every worksheet which context settings are required and which ones aren't correct answers ROLE and WAREHOUSE are require DATABASE and SCHEMA are optional but are suggested how to format the different delimiters correct answers comma = ',' vertical bar = '|' tab = 't' none = 'NONE' how many clusters do warehouses have correct answers 1 what is a warehouse size dependent on correct answers the number of servers in the cluster scaling up/down correct answers adding or removing the number of servers in the warehouse -small -- medium -xl -- large scaling in/out correct answers adding or removing clusters when a warehouse is scaled out and returned to it's original size what is that called correct answers snapping back T/F warehouses hold data correct answers False object correct answers a generic term for databases, tables, schemas, views, etc.