Microsoft dp 900 Study guides, Class notes & Summaries

... natively support the analysis of relationships between entities. Column family databases Document databases Graph databases Key-value stores - Answer-Column family databases ... physically sorts the data in a table based on the values in a specific column A view A clustered index A stored procedure A nonclustered index - Answer-A clustered index ... presents content defined by a query. A heap A stored procedure A view An index - Answer-A view ...is an object associated with a ...

DP-900: MICROSOFT AZURE FUNDAMENTALS|UPDATED&VERIFIED|100% SOLVED|GUARANTEED SUCCESS

01. A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SCX database from the computers. The developers require code assistance features such as intellSense. What should the developers use? a) Azure Data Explorer b) sq1cmd c) Azure Data Studio d) Microsoft SQL Server Management Studio (SSMS) - Answer: b) sq1cmd 02. You have a quality assurance application that reads data from a data warehouse. Which type of pro...

____________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 complet...

How can you enable globally distributed users to work with their own local replica of a Cosmos DB database? -Create an Azure Cosmos DB account in each region where you have users. -Use the API for Table to copy data to Azure Table Storage in each region where you have users. -Enable multi-region writes and add the regions where you have users. - Enable multi-region writes and add the regions where you have users. -You can enable multi-region writes in the regions where you want users to w...

Which service is built on Apache Spark and is compatible with other cloud providers? Select only one answer. Azure Databricks Azure Data Factory Azure Synapse Analytics Azure HDInsight - Answer- Azure Databricks - Databricks is used for processing large amounts of data, which is supported by multiple cloud providers. Data Factory is used to run ETL pipelines. Azure Synapse Analytics is an Azure native service built on Apache Spark. HDInsight is used to process large amounts of data by usi...

Az SQL managed instance benefit - native support for cross-db queries and transactions Azure Cosmos DB API: Graph Data - Gremlin API Azure Cosmos DB API: JSON Documents - MongoDB API Azure Cosmos DB API: Key/Value data - Table API Azure Data Factory control flow - control flow orchestrate pipeline activities that depend on the output of other pipeline activities Azure Data Lake Storage support RBAC - RBAC at file and folder level Batch workloads collect data and process data when conditio...

1 - A report with details of what happened in the last quarter is an example of: a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics resp a) Descriptive Analysis Descriptive analytics, which answers the question "What is happening in my business?". The data to answer this question is typically answered through the creation of a data warehouse in which historical data is persisted in relational tables for multidimensional modeling and repor...

Descriptive analytics What occurred in the past Normalizing Reduce data redundancy & Improves data integrity Does NOT eliminate relationship In batch processing, it takes longer time to process in bulk Latency is expected Diagnostic analytics Why events happened Prescriptive analytics Which actions should be taken Cognitive analytics Draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add the...