nerdexam
SailPoint

SAILPOINT-CERTIFIED-IDENTITYNOW-ENGINEER · Question #60

Is this an item that an IdentityNow engineer should configure when implementing a source that uses a JDBC connector? Solution: Use a query select statement with a clause to match the incoming…

The correct answer is A. Yes. Yes, using a query select statement with a clause to match the incoming account to an existing account is a key configuration for the Single Account SQL Query in a JDBC connector. This query is used to fetch specific account details from the database and must be written in such…

Source and Connector Configuration

Question

Is this an item that an IdentityNow engineer should configure when implementing a source that uses a JDBC connector? Solution: Use a query select statement with a clause to match the incoming account to an existing account for the Single Account SQL Query configuration item

Options

  • AYes
  • BNo

How the community answered

(44 responses)
  • A
    80% (35)
  • B
    20% (9)

Explanation

Yes, using a query select statement with a clause to match the incoming account to an existing account is a key configuration for the Single Account SQL Query in a JDBC connector. This query is used to fetch specific account details from the database and must be written in such a way that it uniquely identifies each account, ensuring accurate correlation between the data in the source and the identities in IdentityNow. Properly configuring this SQL query ensures the right accounts are matched and managed.

Topics

#JDBC connector#SQL query#account correlation#source configuration

Community Discussion

No community discussion yet for this question.

Full SAILPOINT-CERTIFIED-IDENTITYNOW-ENGINEER Practice