D - Correct
https://docs.snowflake.com/en/sql-reference/account-usage/login_history
B - Incorrect as login_history_by_user function returns login activity within the last 7 days only.
https://docs.snowflake.com/en/sql-reference/functions/login_history
B. SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user())
The statement in option B will return the required information of the Snowflake logins (date and user) within the last 90 days.
The information_schema.login_history_by_user function returns information about logins to the account by individual users. The returned columns include EVENT_TIMESTAMP and USER_NAME, which can be used to generate the report listing all Snowflake logins within the last 90 days by filtering the results to only show logins within the specified timeframe.
The function return login activity only within the last 7 days. So, for 8 to 365 days you'll need to reach the account usage login history view
https://docs.snowflake.com/en/sql-reference/functions/login_history
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Kate0204
Highly Voted 1 year, 11 months ago_yyukta
Most Recent 8 months, 4 weeks agoMultiCloudIronMan
1 year, 7 months agoShagunMittal
1 year, 8 months agoOTE
1 year, 8 months agomarkpumc
1 year, 9 months agoganeshra
11 months, 2 weeks agoAndroJS
1 year, 10 months agonzpentest
1 year, 10 months agoSV1122
1 year, 11 months ago