Question 170
An analyst maps an external office name into the sys_id of a reference field and creates invalid references. Which TWO complementary steps supply the appropriate administrative response and the evidence needed to verify it? Select TWO.
Explanation
Correct Answers
Load external data into an import set staging table and use a reviewed transform map for mapping to a target table, checking row errors rather than inserting directly into arbitrary production tables. Import set staging and transformation separate source ingestion from target writes; a successful file upload alone is not a completed import. Verify prerequisites with: Inspect data source, import staging columns, transform target, field maps, required values, import log and test records. Scenario: An analyst maps an external office name into the sys_id of a reference field and creates invalid references.
Inspect data source, import staging columns, transform target, field maps, required values, import log and test records. Import set staging and transformation separate source ingestion from target writes; a successful file upload alone is not a completed import. The appropriate response is: Load external data into an import set staging table and use a reviewed transform map for mapping to a target table, checking row errors rather than inserting directly into arbitrary production tables. Scenario: An analyst maps an external office name into the sys_id of a reference field and creates invalid references.
Incorrect Answers
Run scheduled data imports with explicit source authorization, ingestion monitoring and staging cleanup; prevent large overlapping imports or reprocessing the same unverified feed. This step may apply to Scheduled data imports and operational cleanup but is not one of the complementary requirements in this case. The intended pair is: Load external data into an import set staging table and use a reviewed transform map for mapping to a target table, checking row errors rather than inserting directly into arbitrary production tables. Together with: Inspect data source, import staging columns, transform target, field maps, required values, import log and test records. Scenario: An analyst maps an external office name into the sys_id of a reference field and creates invalid references.
Inspect elevated privilege state, role grants, security ACL changes, approval record, active session and change audit logs. This step may apply to Elevated security administration and role boundaries but is not one of the complementary requirements in this case. The intended pair is: Load external data into an import set staging table and use a reviewed transform map for mapping to a target table, checking row errors rather than inserting directly into arbitrary production tables. Together with: Inspect data source, import staging columns, transform target, field maps, required values, import log and test records. Scenario: An analyst maps an external office name into the sys_id of a reference field and creates invalid references.
A user with appropriate access sees metrics reflecting the intended filtered records and cannot use the chart to reveal restricted data. This step may apply to Platform analytics as a reporting capability but is not one of the complementary requirements in this case. The intended pair is: Load external data into an import set staging table and use a reviewed transform map for mapping to a target table, checking row errors rather than inserting directly into arbitrary production tables. Together with: Inspect data source, import staging columns, transform target, field maps, required values, import log and test records. Scenario: An analyst maps an external office name into the sys_id of a reference field and creates invalid references.


