nerdexam
Microsoft

70-475 · Question #88

A company named Fabricam, Inc, has a web app hosted in Microsoft Azure. Millions of users visit the app daily. All of the user visits are logged in Azure Blob storage. Data analysts at Fabrikam…

The correct answer is B. Load the text files to sequence files, and then run dashboard queries on the sequence files. File format versatility and Intelligent caching: Fast analytics on Hadoop have always come with one big catch: they require up-front conversion to a columnar format like ORCFile, Parquet or Avro, which is time-consuming, complex and limits your agility. With Interactive Query…

Implement Big Data batch processing solutions

Question

A company named Fabricam, Inc, has a web app hosted in Microsoft Azure. Millions of users visit the app daily. All of the user visits are logged in Azure Blob storage. Data analysts at Fabrikam built a dashboard that processes the user visit logs. Fabrikam plans to use an Apache Hadoop cluster on Azure HDInsight to process queries. The queries will access the data only once. You need to recommend a query execution strategy. What is the best to recommend using to achieve the goal? More than one answer choice may achieve the goal. Select the BEST answer.

Options

  • ALoad the text files to ORC files, and then run dashboard queries on the ORC files.
  • BLoad the text files to sequence files, and then run dashboard queries on the sequence files.
  • CRun the queries on the text files directly.
  • DLoad the text files to parquet files, and then run dashboard queries on the parquet files.

How the community answered

(32 responses)
  • A
    6% (2)
  • B
    72% (23)
  • C
    3% (1)
  • D
    19% (6)

Explanation

File format versatility and Intelligent caching: Fast analytics on Hadoop have always come with one big catch: they require up-front conversion to a columnar format like ORCFile, Parquet or Avro, which is time-consuming, complex and limits your agility. With Interactive Query Dynamic Text Cache, which converts CSV or JSON data into optimized in- memory format on-the-fly, caching is dynamic, so the queries determine what data is cached. After text data is cached, analytics run just as fast as if you had converted it to specific file big-data-analytics-architecture-and-operations/

Topics

#HDInsight Hadoop#sequence files#query optimization#blob storage

Community Discussion

No community discussion yet for this question.

Full 70-475 Practice