Snowflake data movement | account and security | semi-structured Flashcards
which type of the object key is only used for decryption?
a) none of these
b) active key
c) destroyed key
d) retired key
d) retired key
what is the best option to automatically delete the files from stage after it got loaded using COPY INTO command?
a) setting PURGE =TRUE in COPY INTO command
b) cloud provider deletes the file automatically
c) delete manually using cloud provide UI delete option as soon as file is loaded
d) setting DELETE = TRUE in COPY INTO command
a) setting PURGE =TRUE in COPY INTO command
which security feature is supported in snowflake
a) multi-factor authentication
b) role based access control
c) all of these
d) tri-secret secure encryption
c) all of these
which ate the CORRECT statements about STREAMS?
a) STREAMS is used to scheduled SQL execution
b) Streams is used to identify and act on changed table records
c) it can not be used with TASKS
d) it is used for change data capture
b) Streams is used to identify and act on changed table records
d) it is used for change data capture
which role is not a snowflake system-defined role assigned to a new account?
a) CUSTOM
b) PUBLIC
c) SYSADMIN
d) ACCOUNTADMIN
e) SECURITYADMIN
a) CUSTOM
two of the key attributes that distinguish semi-structure data from structured data are:
a) lack of fixed schema
b) nested data structure
c) fixed schema
a) lack of fixed schema
b) nested data structure
which parameter does help in loading files whose metadata has expired?
a) Set LAST_MODIFIED_DATE to more than 64 days
b) set LOAD_UNCERTAIN_FILES to TRUE
c) set LOAD_EXPIRED_FILES to TRUE
d) set LAST_MODIFIED_DATE to with in 64 days
b) set LOAD_UNCERTAIN_FILES to TRUE
dynamic data masking is supported by:
a) VPS
b) business critical
c) enterprise edition
d) standard editions
a) VPS
b) business critical
c) enterprise edition
external stages require customers to have an account with a cloud storage service provider. which of the following are available currently or have been announced by snowflake as under development?
a) GCP buckets
b) MS Azure Blob
c) BOX
d) DROPBOX
e) AWS S3
a) GCP buckets
b) MS Azure Blob
e) AWS S3
if a DBA_ROLE creates a database. later the DBA_ROLE was dropped. who will own the database now which was created by DBA_ROLE?
a) DBA_ROLE can’t be dropped as it is the owner of the database
b) database will be dropped
c) role who dropped the DBA_ROLE
d) no one can access
c) role who dropped the DBA_ROLE
what is the default size of unload file?
a) 100 MB
b) 32 MB
c) 10 MB
d) 16 MB
d) 16 MB
how can you create a “super-user” or “super-role” in snowflake who can bypass all the authorization checks?
a) ACCOUNTADMIN role is same as super role
b) contact snowflake personnel to create a super role or super user for your account
c) CREATE ROLE SUPER_ROLE;
d) there is no concept of SUPER_ROLE or SUPER_USER in snowflake
d) there is no concept of SUPER_ROLE or SUPER_USER in snowflake
what data structure types can be ingested into a VARIANT column in a snowflake table?
a) JSON
b) ORC
c) PARQUET
d) AVRO
e) XML
a) JSON
b) ORC
c) PARQUET
d) AVRO
e) XML
how many files can each server in a cluster can process in parallel?
a) 4 files
b) depends on how large is the file. if the file is 32 MB in size, the server can process 4 such files in parallel
c) 16 files
d) 1 file
e) 8 files
e) 8 files
what is the best practice after creating a custom role in a snowflake account?
a) Grant ownership to the SYSADMIN role or a child role under SYSADMIN
b) Grant PUBLIC to the role so all database objects owned by PUBLIC will be available to the new role
c) Grant ownership of the role to itself so a member of the role can control access to the role
d) Grant the role to the USERADMIN role so users can be added to the role
a) Grant ownership to the SYSADMIN role or a child role under SYSADMIN
what are the features of column-level security?
a) internal tokenization
b) external tokenization
c) dynamic data masking
d) column masking
b) external tokenization
c) dynamic data masking
select the best option:
a) internal table stage is referenced as @%
b) internal user stage is referenced using @~
c) internal named stage is referenced as @
d) all of these
e) none of these are correct
d) all of these
what actions can be performed when an error is encountered while loading data from a file?
a) skip file
b) continue loading the file
c) abort the load operation
d) skip file when the number of errors in the file is equal to 10
a) skip file
b) continue loading the file
c) abort the load operation
d) skip file when the number of errors in the file is equal to 10
what all file formats are supported by snowflake for unloading data from snowflake?
a) AVRO
b) CSV, TSV
c) JSON
d) XML
e) PARQUET
b) CSV, TSV
c) JSON
e) PARQUET
named stages come in two variables, what are they?
a) internal
b) secure
c) external
d) materialized
e) permanent
a) internal
c) external
snowflake maintains detailed metadata for each table into which data is loaded. for how long snowflake keeps the metadata active?
a) 24 hours
b) 31 days
c) 32 days
d) 64 days
e) 16 days
d) 64 days
what is the best recommended size of file for bulk loading?
a) 50 MB - 500 MB compressed
b) 16 MB compressed
c) 10 MB - 100MB uncompressed
d) 10 MB - 100MB compressed
d) 10 MB - 100MB compressed
when unloading data into multiple files, use the MAX_FILE_SIZE copy options to specify the maximum size of each file created
TRUE or FALSE
TRUE
what are the three snowflake stages types?
a) named
b) materialized
c) secure
d) user
e) table
f) permanent
a) named
d) user
e) table
snowflake supports transforming data while loading it into a table using copy command. what all options you have?
a) casts
b) column reordering
c) column omission
d) string truncation
e) join
a) casts
b) column reordering
c) column omission
d) string truncation
John has setup process to load specific set of files using both Bulk and Snowpipe. this best practice to avoid any missed loading either by bulk loading or snowpipe
TRUE or FALSE
FALSE
which role at least should have MFA configured?
a) SYSADMIN
b) PUBLIC
c) ACCOUNTADMIN
d) SECURITYADMIN
c) ACCOUNTADMIN
which are the correct statements about TASKS?
a) can not be trigged manually
b) it can be used with STREAMS
c) TASKS is used to scheduled SQL execution
d) TASKA is used to identify and act on changed table records
e) it is used for change data capture
a) can not be trigged manually
b) it can be used with STREAMS
c) TASKS is used to scheduled SQL execution
AWS private link is an AWS service for creating private VPC endpoints that allow direct, secure connectivity between AWS VPCs without traversing the public internet
TRUE or FALSE
TRUE
a user’s default role is
a) the role a user is set to each time the user logs in to the system
b) the user’s default role is always PUBLIC
c) the user’s default role changes each time the user logs in to the system
d) the name used to log in to the webUI
a) the role a user is set to each time the user logs in to the system
what all commands will you use to unload data from your snowflake table to your local file system?
a) only GET command
b) COPY INTO followed by PUT command
c) Only COPY INTO command
d) COPY INTO command followed by GET command
d) COPY INTO command followed by GET command
which key concepts should be considered when loading data into snowflake?
a) all of these
b) stage object
c) transformation and error validation
d) file format
a) all of these
which are the different ways a user can get permissions to a database object?
a) grant the user permissions to the object
b) the user granted a role that inherits another role with permissions to the object
c) grant the role with permissions on the database objects to the user
d) the user creates the objects and the current role becomes the owner of the object
b) the user granted a role that inherits another role with permissions to the object
c) grant the role with permissions on the database objects to the user
d) the user creates the objects and the current role becomes the owner of the object
the FLATTEN command will parse nested entities into separate rows. one version of the FLATTEN command uses a join and the other uses an object keyword. select two words that represent the options used with the FLATTEN command
a) SIDEWAYS
b) CONVERT
c) TABLE
d) LATERAL
c) TABLE
d) LATERAL
which command will help you get the lists of pipes for which you have access privileges?
a) LIST PIPE
b) SHOW PIPE
c) SELECT PIPE()
d) LIST PIPES
e) SHOW PIPES()
e) SHOW PIPES()
the compute resource used by snowflake for data loading jobs can be provided by:
a) user managed virtual warehouse
b) hardware provisioned by user directly from cloud providers
c) snowflake managed service
d) all of these
a) user managed virtual warehouse
c) snowflake managed service