CERTIFIED-DATA-ANALYST-ASSOCIATE · Question #27
CERTIFIED-DATA-ANALYST-ASSOCIATE Question #27: Real Exam Question with Answer & Explanation
The correct answer is B: Use Partner Connect to ingest the data from the social media platform and then connect it to. Option B is correct because Partner Connect is Databricks' built-in integration hub that connects external partner tools - including data ingestion services - directly to the Databricks workspace. The correct workflow is to use Partner Connect to pull data from the social media p
Question
A data analyst of a large online retailer wants to integrate Databricks SQL with Partner Connect to obtain real-time data on customer behavior from a social media platform. Which of the following steps would the data analyst take to achieve the desired outcome?
Options
- AUse Databricks SQL to ingest the data from the social media platform and then connect it to
- BUse Partner Connect to ingest the data from the social media platform and then connect it to
- CUse an ETL tool to ingest the data from the social media platform and then connect it to both
- DUse an API to ingest the data from the social media platform and then connect it to both Partner
Explanation
Option B is correct because Partner Connect is Databricks' built-in integration hub that connects external partner tools - including data ingestion services - directly to the Databricks workspace. The correct workflow is to use Partner Connect to pull data from the social media platform (via ingestion partners like Fivetran or Airbyte available through Partner Connect), and then use Databricks SQL to query and analyze that ingested data.
Option A is wrong because Databricks SQL is a query and analytics engine, not an ingestion tool - it cannot pull data from external social media APIs on its own.
Option C is wrong because while ETL tools can ingest data, this approach bypasses Partner Connect entirely, which contradicts the question's requirement to integrate through Partner Connect.
Option D is wrong because calling an API directly also bypasses Partner Connect, and the question explicitly asks how to achieve the outcome using Partner Connect.
Memory tip: Think of the workflow as a two-lane road - Partner Connect is the ON-ramp (brings data in from the outside world), and Databricks SQL is the destination (where you analyze it). Data always flows through Partner Connect into SQL, never the other way around.
Community Discussion
No community discussion yet for this question.