フリー問題

SnowPro Advanced: Security Engineer のフリー問題 13 / 20 問目

問題文

During an investigation a security engineer must provide definitive proof of which underlying tables one specific execution of a multi-layered secure view actually read. Which approach meets that requirement?

選択肢

  1. Query the object dependencies view to walk the links from the view down to its tables, which resolves the full chain of references that the execution must have followed.
  2. Read the view definition and parse the statement text to list every table it references, because the definition is authoritative and does not depend on which rows a particular execution happened to reach.
  3. Read the query history for that identifier and inspect the statement text, since the text names every table the statement had to open.
  4. Query the access history view for that query identifier and read the base objects that the execution touched.

解答・解説を確認するには

正解と解説の確認、回答の記録には無料登録が必要です。登録すると演習モードでフリー問題に回答し、正誤と解説をその場で確認できます。