Which table stores the links from Policy to Control Objective?

Which table stores the links from Policy to Control Objective?

• A. [sn_compliance_m2m_policy_profile_type]
• B. [sn_compliance_m2m_policy_statement]
• C. [sn_compliance_m2m_policy_profile]
• D. [sn_compliance_m2m_statement_profile_type]

Answer: (B)

In IRM, relationships between policies and the controls or objectives they address are stored using a many-to-many join table. The naming pattern sn_compliance_m2m_* indicates a join between two entities, and the table that links a Policy to its control objectives is the one that connects Policy records to Policy Statement records. Policy Statement entries represent the objectives or controls a policy covers, so this join table provides the links between a policy and its associated control objectives. Other join tables in the list map different pairings (such as policy to a profile type or statement to a profile type) and do not represent the direct policy-to-control objective linkage.

In IRM, relationships between policies and the controls or objectives they address are stored using a many-to-many join table. The naming pattern sn_compliance_m2m_* indicates a join between two entities, and the table that links a Policy to its control objectives is the one that connects Policy records to Policy Statement records. Policy Statement entries represent the objectives or controls a policy covers, so this join table provides the links between a policy and its associated control objectives. Other join tables in the list map different pairings (such as policy to a profile type or statement to a profile type) and do not represent the direct policy-to-control objective linkage.