Microsoft Microsoft Certifications DP-900 Questions & Answers

• Question 71:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes

  Like IaaS, PaaS includes infrastructure servers, storage, and networking but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete

  web application lifecycle: building, testing, deploying, managing, and updating.

  PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other

  resources

  Box 2: Yes

  You manage the applications and services you develop, and the cloud service provider typically manages everything else.

  

  Box 3: No

  There really is no way to pause / stop billing for your Azure SQL Database.

  Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."

  Reference:

  https://azure.microsoft.com/en-us/overview/what-is-paas

  https://feedback.azure.com/forums/217321-sql-database/suggestions/6931152-please-add-ability-to-temporarily-turn-off-on-sql

• Question 72:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: Yes

  Compute is separate from storage, which enables you to scale compute independently of the data in your system.

  Box 2: Yes

  You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.

  Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour.

  Box 3: No

  Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.

  Reference:

  https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/

• Question 73:

  To complement the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

• Question 74:

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

  Reference: https://teachcomputerscience.com/relational-databases/

• Question 75:

  HOTSPOT

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

  Generally speaking, data analytics comes in four types (Figure 1):

  1.

  Descriptive, to answer the question: What's happening?

  2.

  Diagnostic, to answer the question: Why's happening?

  3.

  Predictive, to answer the question: What will happen?

  4.

  Prescriptive, to answer the question: What actions should we take?

  Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

• Question 76:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  YES, YES, YES Batch processing can have output to SQL Database, Hive, HBase, Spark SQL. Look at the link and the diagram there https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

• Question 77:

  To complete the sentence, select the appropriate option in the answer area.

  Hot Area:

  

  Correct Answer:

  

• Question 78:

  HOTSPOT

  You have the following SQL query.

  

  What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

• Question 79:

  HOTSPOT

  For each of the following statements, select Yes if the statement is true. Otherwise, select No.

  NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer:

  

  Box 1: No

  A pipeline is a logical grouping of activities that together perform a task.

  Box 2: Yes

  You can construct pipeline hierarchies with data factory.

  Box 3: Yes

  A pipeline is a logical grouping of activities that together perform a task.

  Reference:

  https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/

• Question 80:

  For each of the following statements, select yes if he statement is true, Otherwise select No. NOTE: Each correct selection is worth one point.

  Hot Area:

  

  Correct Answer: