Try and practice the latest Microsoft : 070-775 real questions & answers

Note: This question is part of a series of questions that present the same Scenario.
Each question I the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution while others might not have correct solution.
You are implementing a batch processing solution by using Azure HDInsight.
You plan to import 300 TB of data.
You plan to use one job that has many concurrent tasks to import the data in memory.
You need to maximize the amount of concurrent tanks for the job.
What should you do?

• A. Use an action in an Apache Oozie workflow that stores the data in a text format.
• B. Use a broadcast join in an Apache Hive query that stores the data in an ORC format.
• C. Increase the number of spark.executor.cores in an Apache Spark job that stores the data in a text format.
• D. Increase the number of spark.executor.instances in an Apache Spark job that stores the data in a text format.
• E. Use an Azure Data Factory linked service that stores the data In an Azure DocumentDB database.
• F. Use a shuffle join in an Apache Hive query that stores the data in a JSON format.
• G. Use an Azure Data Factory linked service that stores the data in Azure Data lake.
• H. Decrease the level of parallelism in an Apache Spark job that Mores the data in a text format.

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Apache Pig table named Sales in Apache HCatalog.
You need to make the data in the table accessible from Apache Pig.
Solution: You use the following script.

Does this meet the goal?

• A. Yes
• B. No

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

DRAG DROP
You have a text file named Data/examples/product.txt that contains product information.
You need to create a new Apache Hive table, import the product information to the table, and then read the top 100 rows of the table.
Which four code segments should you use in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc)
sqlContext.sql("CREATE TABLE IF NOT EXISTS productid INT, productname STRING)" sqlContext.sql("LOAD DATA LOCAL INPATH 'Data/examples/product.txt' INTO TABLE product") sqlContext.sql("SELECT productid, productname FROM product LIMIT 100").collect().foreach (println) References: https://www.tutorialspoint.com/spark_sql/spark_sql_hive_tables.htm

You have an Azure HDInsight cluster.
You need a build a solution to ingest real-time streaming data into a nonrelational distributed database.
What should you use to build the solution?

• A. Apache Storm and Apache HBase
• B. Spark and Phoenix
• C. Apache Pig and Apache HCatalog
• D. Apache Hive and Apache Kafka

Explanation: Only visible for Actual4Cert members. You can sign-up / login (it's free).

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a security tracking solution in Apache Kafka to parse security logs. The security logs record an entry each time a user attempts to access an application. Each log entry contains the IP address used to make the attempt and the country from which the attempt originated.
You need to receive notifications when an IP address from outside of the United States is used to access the application.
Solution: Create two new brokers. Create a file import process to send messages. Run the producer.
Does this meet the goal?

• A. Yes
• B. No