Integrating Third-Party AI Securely | Dataford Interview Questions

What strategies do you use to ensure data integrity and security when integrating third-party AI platforms?

Write a query that audits approved platforms by evaluating request integrity and security checks. Treat missing or unsuccessful controls as failures.

Output

One row per approved platform with at least one request failure
Columns: platform_id, platform_name, total_requests, failed_requests, and latest_failed_at
Order by failed_requests descending, then platform_id ascending

ai_platforms

Column	Type	Description
platform_idPK	INT	Unique platform identifier
platform_name	VARCHAR(100)	Third-party AI platform name
is_approved	BOOLEAN	Whether the platform is approved for integration

integration_requests

Column	Type	Description
request_idPK	INT	Unique integration request identifier
platform_id	INT	Referenced AI platform
payload_hash	VARCHAR(128)	Hash generated before transmission
received_hash	VARCHAR(128)	Hash recorded after platform receipt
received_at	TIMESTAMPTZ	Time the request was received

security_checks

Column	Type	Description
check_idPK	INT	Unique security-check identifier
request_id	INT	Referenced integration request
encryption_verified	BOOLEAN	Whether encryption was verified
pii_redacted	BOOLEAN	Whether personally identifiable information was redacted

Your question is Integrating Third-Party AI Securely. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.