A SAS Viya analyst runs PROC FEDSQL to query a table stored in a Hadoop Hive database registered as a caslib. Which type of processing does PROC FEDSQL enable for this query?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Here's the deal — b is correct because PROC FEDSQL is SAS Viya's federated SQL engine that can push query processing to connected data sources (including Hadoop/Hive) for predicate pushdown, or bring data into CAS memory for in-memory distributed processing, minimizing data movement. A is wrong because federated processing avoids moving entire tables to the client.
Full explanation below image
Full Explanation
B is correct because PROC FEDSQL is SAS Viya's federated SQL engine that can push query processing to connected data sources (including Hadoop/Hive) for predicate pushdown, or bring data into CAS memory for in-memory distributed processing, minimizing data movement. A is wrong because federated processing avoids moving entire tables to the client. C is wrong because FEDSQL does not transpile to DATA step code. D is wrong because PROC FEDSQL can query Hive tables directly through the caslib connection.