DP-900- Microsoft Azure Fundamentals (Questions & Answers) Rated 100% Correct!!

____________leverages a massively parallel processing (MPP) architecture. - Azure Synapse Analytics _________organizes your files into directories and subdirectories for improved file organization. Blob storage can only mimic a directory structure. - Data Lake Storage . What are ACID principles? - Atomicity guarantees that each transaction is treated as a single unit, which either succeeds completely, or fails completely. If any of the statements constituting a transaction fails to complete, the entire transaction fails and the database is left unchanged. An atomic system must guarantee atomicity in each and every situation, including power failures, errors, and crashes. Consistency ensures that a transaction can only take the data in the database from one valid state to another. A consistent database should never lose or create data in a manner that can't be accounted for. In the bank transfer example described earlier, if you add funds to an account, there must be a corresponding deduction of funds somewhere, or a record that describes where the funds have come from if they have been received externally. You can't suddenly create (or lose) money. Isolation ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially. A concurrent process can't see the data in an inconsistent state (for example, the funds have been deducted from one account, but not yet credited to another.)Durability guarantees that once a transaction has been committed, it will remain committed even if there's a system failure such as a power outage or crash. Durabilityguarantees that once a transaction has been committed, it will remain committed even if there's a system failure such as a power outage or crash. A collection of ready-made visuals, pre-arranged in dashboards and reports is called what in Power BI? - An app. A container provides a convenient way of grouping related blobs together, and you can organize blobs in a hierarchy of folders inside a container, similar to files in a file system on the disk. Is this true? - True A pipeline can run continuously, as data is received from the various data sources. You can create pipelines using the graphical user interface provided by Microsoft, or by writing your own code. Which service is this? - Azure Data Factory A real-estate website that tracks a subset of data from consumers' mobile devices, and makes real-time property recommendations of properties to visit based on their geo-location. How do you process this data? - streaming A transactional database must adhere to the ACID properties to ensure that the database remains consistent while processing transactions. Is this true? - True An _____ is a collection of preset, ready-made visuals and reports that are shared with an entire organization. - App Azure Data Lake Storage is essentially an extension of Azure Blob storage, organized as a near-infinite file system. Is this true? - True Azure provides different types of storage services based on the type of data. Is this true? - True -Depending on the type of data such as structured, semi-structured, or unstructured, data will be stored differently. Structured data is typically stored in a relational database such as SQL Server or Azure SQL Database.If you want to store unstructured data such as video or audio files, you can use Azure Blob storage If you want to store semi-structured data such as documents, you can use a service such as Azure Cosmos DB. Azure Synapse Analytics includes a control node and a pool of compute nodes. Explain the architecture? - The Control node is the brain of the architecture. It's the front end that interacts with all applications. The MPP engine runs on the Control node to optimize and coordinate parallel queries. When you submit a processing request, the Control node transforms it into smaller requests that run against distinct subsets of the data in parallel. The Compute nodes provide the computational power. The data to be processed is distributed evenly across the nodes. Users and applications send processing requests to the control node. The control node sends the queries to compute nodes, which run the queries over the portion of the data that they each hold. When each node has finished its processing, the results are sent back to the control node where they're combined into an overall result. Azure Synapse Analytics supports two computational models. We are using the SQL pool in the following design. What is missing in the following design? - Azure Synapse Analytics Azure Storage Azure Synapse Analytics supports two computational models. What are those? - SQL pools Spark pools. Azure Table Storage is intended to support very large volumes of data, up to several hundred TBs in size. Is this correct? - True Azure Table Storage tables have no concept of relationships, stored procedures, secondary indexes, or foreign keys. Is this true? - TrueBy default, the SELECT, UPDATE and DELETE statements are applied to every row in a table. Is this true? - True Can these partitions grow or shrink as required? - Yes