DP-201 무료 덤프문제 온라인 액세스

You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?

• A.Business critical Azure SQL Database single database
• B.Business critical Azure SQL Database Managed Instance
• C.General purpose Azure SQL Database Managed Instance
• D.General purpose Azure SQL Database single database

A company stores large datasets in Azure, including sales transactions and customer account information.
You must design a solution to analyze the dat
a. You plan to create the following HDInsight clusters:

You need to ensure that the clusters support the query requirements.
Which cluster types should you recommend? To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.

정답:

References:
https://docs.microsoft.com/bs-latn-ba/azure/hdinsight/hdinsight-hadoop-optimize-hive-query?toc=%2Fko-kr%2Fazure%2Fhdinsight%2Finteractive-query%2FTOC.json&bc=%2Fbs-latn-ba%2Fazure%2Fbread%2Ftoc.json

You are designing an Azure SQL Data Warehouse. You plan to load millions of rows of data into the data warehouse each day.
You must ensure that staging tables are optimized for data loading.
You need to design the staging tables.
What type of tables should you recommend?

• A.External table
• B.Replicated table
• C.Hash-distributed table
• D.Round-robin distributed table

You are designing a Spark job that performs batch processing of daily web log traffic.
When you deploy the job in the production environment, it must meet the following requirements:
Run once a day.
Display status information on the company intranet as the job runs.
You need to recommend technologies for triggering and monitoring jobs.
Which technologies should you recommend? To answer, drag the appropriate technologies to the correct locations. Each technology may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

정답:

References:
https://docs.microsoft.com/en-us/azure/hdinsight/spark/apache-spark-livy-rest-interface
https://docs.microsoft.com/en-us/azure/hdinsight/hadoop/apache-hadoop-use-hive-beeline

You are designing a log storage solution that will use Azure Blob storage containers.
CSV log files will be generated by a multi-tenant application. The log files will be generated for each customer at five-minute intervals. There will be more than 5,000 customers. Typically, the customers will query data generated on the day the data was created.
You need to recommend a naming convention for the virtual directories and files. The solution must minimize the time it takes for the customers to query the log files.
What naming convention should you recommend?

• A.{CustomerID}/{year}/{month}/{day}/{hour}/{minute}.csv
• B.{year}/{month}/{day}/{hour}/{minute}/{CustomerID}.csv
• C.{minute}/{hour}/{day}/{month}/{year}/{CustomeriD}.csv
• D.{year}/{month}/{day}/{CustomerID}/{hour}/{minute}.csv