Microsoft
70-475 · Question #22
A company named Fabrikam, Inc. has a web app. Millions of users visit the app daily. Fabrikam performs a daily analysis of the previous day's logs by scheduling the following Hive query. CREATE…
The correct answer is B. Generate a directory that is named by using the syntax of "LogDate={date}" and generate a set of. By default, all the data files for a table are located in a single directory. Partitioning is a technique for physically dividing the data during loading, based on values from one or more columns, to speed up queries that test those columns…
Implement Big Data batch processing solutions
Question
A company named Fabrikam, Inc. has a web app. Millions of users visit the app daily. Fabrikam performs a daily analysis of the previous day's logs by scheduling the following Hive query. CREATE EXTERNAL TABLE IF NOT EXISTS UserActivity (...) Partitioned BY (LogDate string) Location MSCK REPAIR TABLE UserActivity; Select ... From UserActivity where LogDate = "{date}"; You need to recommend a solution to gather the log collections from the web app. What should you recommend?
Options
- AGenerate a single directory that contains multiple files for each day. Name the file by using the
- BGenerate a directory that is named by using the syntax of "LogDate={date}" and generate a set of
- CGenerate a directory each day that has a single file.
- DGenerate a single directory that has a single file for each day.
How the community answered
(23 responses)- A4% (1)
- B78% (18)
- C4% (1)
- D13% (3)
Explanation
By default, all the data files for a table are located in a single directory. Partitioning is a technique for physically dividing the data during loading, based on values from one or more columns, to speed up queries that test those columns. x/topics/impala_partitioning.html#partitioning
Topics
#Hive#external table#partitioning#log collection
Community Discussion
No community discussion yet for this question.