PROC FEDSQL is used to query across a CAS in-memory table and an external RDBMS table simultaneously. Which characteristic distinguishes PROC FEDSQL from PROC SQL in this federated scenario?
Select an answer to reveal the explanation.
Short Explanation
Here's the deal — the ANSI SQL-92 predicate-pushdown answer is right because PROC FEDSQL can query CAS and remote tables together while pushing WHERE conditions and aggregations to the remote source. PROC SQL pulls the data into SAS memory first, so it doesn't optimize the same way.
Full Explanation
The ANSI SQL-92 predicate-pushdown answer is correct because PROC FEDSQL is SAS Viya's ANSI SQL-92 federated query engine, so it can query CAS and external sources while pushing WHERE conditions and aggregations to the remote source to minimize data movement. PROC SQL pulls data into SAS memory first. The two-source limit answer is wrong because PROC FEDSQL is not limited to two sources. The SAS/ACCESS licensing answer is wrong because SAS/ACCESS licenses may be required for both in different scenarios. The 10x speed answer is wrong because no blanket 10x speed claim is correct.