HOTSPOT (Drag and Drop is not supported)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:
Answer(s): A
Box 1: No Database normalization is the process of restructuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.Full normalisation will generally not improve performance, in fact it can often make it worse but it will keep your data duplicate free.Box 2: No Analytics systems are deformalized to increase performance.Transactional database systems are normalized to increase data consistency.Box 3: Yes Transactional database systems are more normalized and requires more joins.
https://www.sqlshack.com/what-is-database-normalization-in-sql-server
HOTSPOT (Drag and Drop is not supported)Select the answer that correctly completes the sentence.Hot Area:
A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship.
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
A key/value store associates each data value with a unique key.Key/value stores are highly optimized for applications performing simple lookups, but are less suitable if you need to query data across different key/value stores.Key/value stores are also not optimized for querying by value.A single key/value store can be extremely scalable, as the data store can easily distribute data across multiple nodes on separate machines.
SQL Server on Azure VM SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine. With this additional control comes the added responsibility to manage the virtual machine.
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents.
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html
Share your comments for Microsoft DP-900 exam with other users:
Question 4:Question 4 is about when to use batch processing.
The DP-900 exam can be tricky if you aren't familiar with Microsoft’s specific cloud terminology. I used the practice questions from free-braindumps.com and found them incredibly helpful. The site breaks down core data concepts and Azure services in a way that actually mirrors the real test. As a resutl I passed my exam.