SnowPro Advanced: Architect Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A1

  If TIME_RANGE_END is not specified, the function returns the most recent login events. If the time range does not fall within the last 7 days, an error is returned. select * from table(information_schema.login_history_by_user()) order by event_timestamp; select * from table(information_schema.login_history(TIME_RANGE_START => dateadd('hours',-1,current_timestamp()),current_timestamp())) order by event_timestamp;

• Chose A0

  If TIME_RANGE_END is not specified, the function returns the most recent login events. If the time range does not fall within the last 7 days, an error is returned. select * from table(information_schema.login_history_by_user()) order by event_timestamp; select * from table(information_schema.login_history(TIME_RANGE_START => dateadd('hours',-1,current_timestamp()),current_timestamp())) order by event_timestamp;

• Chose B1

  https://docs.snowflake.com/en/user-guide/data-load-snowpipe-auto-s3#step-3-configure-security

• 1

  Should be A