Question 44:
FlexiToner uses AWS to query 10 years’ worth of historical data and get results in moments, with the flexibility to explore data for deeper insights. Movable Ink provides real-time personalization of marketing emails based on a wide range of user, device, and contextual data, driving higher response rates and better customer experiences. Also FlexiToner hosts log files captured from web servers running out of different EC2 machines FlexiToner has lot of data assets available in structured, semi-structured and unstructured data forms containing emails, logs, structured data from databases in csv files with formats in CSV, LOG, JSON and binary formats like Parquet and ORC. FlexiToner is interested to build a data lake out of all the files stored on S3 and provide Data Lake as a service to users from different departments based on pay per queries run. FlexiToner understands that Athena provides this facility OOTB.FlexiToner has a group of big data professionals specialized in Hadoop and want to understand the underlying hadoop components under the hood so that the team can easily understand the platform and use it for further analytics. Please advise. Select 2 options.
Answer options:
A.Athena uses Hive to execute DML statements B.Athena uses Hive to execute the DDL statements that create and modify schema C.Athena uses Presto to execute the DDL statements that create and modify schema D.Athena uses Presto to execute DML statements