Microsoft
70-475 · Question #22
70-475 Question #22: Real Exam Question with Answer & Explanation
Sign in or unlock 70-475 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
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.
Unlock 70-475 to see the answer
You've previewed enough free 70-475 questions. Unlock 70-475 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.