Download Data Analytics: Predictive and Prescriptive Analysis, Batch Processing, and Data Models and more Exams Programming Languages in PDF only on Docsity!
DP-900 MICROSOFT AZURE DATA
FUNDAMENTALS - TEXT
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 - correct answer 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 reporting. Diagnostic analytics, which deals with answering the question "Why is it happening?". This may involve exploring information that already exists in a data warehouse, but typically involves a wider search of your data estate to find more data to support this type of analysis. Predictive analytics, which enables you to answer the question "What is likely to happen in the future based on previous trends and patterns?" Prescriptive analytics, which enables autonomous decision making based on real-time or near real-time analysis of data, using predictive analytics. 2 - _______ provides what action we should take a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics - correct answer resp d) Prescriptive analytics
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 reporting. Diagnostic analytics, which deals with answering the question "Why is it happening?". This may involve exploring information that already exists in a data warehouse, but typically involves a wider search of your data estate to find more data to support this type of analysis. Predictive analytics, which enables you to answer the question "What is likely to happen in the future based on previous trends and patterns?" Prescriptive analytics, which enables autonomous decision making based on real-time or near real-time analysis of data, using predictive analytics. 3 - Converting speech to text is an example of ___________ a) Descriptive Analysis b) Diagnostic analytics c) Cognitive analytics d) Prescriptive analytics - correct answer resp c) Cognitive analytics 4 - Analyzing why car sales are down in the last quarter comes under
a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics - correct answer resp b) Diagnostic analytics 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 reporting.
b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics - correct answer resp c) Predictive analytics 7 - In ELT (Extract, Load and Transform): a) Data is first loaded into the target datastore with minimal processing b) Transformations are done in the target datastore c) We do NOT use separate service for transformation d) All of above - correct answer resp d) All of above 8 - TRUE OR FALSE: Batch Processing commences when a condition is met a) True b) False - correct answer resp a) True 9 - Which of the following is TRUE about Batch processing? a) Data is processed near realtime b) Can NOT process huge loads of data c) Parallel Processing is NOT possible d) Batch processing typically has high latency - correct answer resp d) Batch processing typically has high latency 10 - Temperature sensors sending readings every hour is example of _________ a) Batch Processing b) Stream processing - correct answer resp a) Batch Processing
11 - Payment transactions from a POS terminal sent to Event Hubs is an example of _______ a) Batch Processing b) Stream processing - correct answer resp b) Stream processing 12 - TRUE OR FALSE: When using Azure Data Factory for batch processing, processed data can be stored in relational databases, NoSql databases or in Azure Blob Storage a) True b) False - correct answer resp a) True 13 - Most frequently used data model schema for data analysis (in a data warehouse) is ________________ a) Star Schema b) Transactional Data Model c) Dimension d) None of the above - correct answer resp a) Star Schema 14 - TRUE OR FALSE : STAR schema is de-normalised and easier to query a) True b) False - correct answer resp a) True 15 - Azure Synapse Analytics supports parallel processing of data using: a) High Performance Single Node Machines b) Split Processing across multiple compute nodes
b) Power BI Report Builder c) Power BI as a Service d) Excel Sheet - correct answer resp b) Power BI Report Builder 21 - In Power BI - Dashboard can be created using ______________. a) Power BI Desktop b) Power BI Report Builder c) Power BI as a Service d) Excel Sheet - correct answer c) Power BI as a Service 22 - Azure SQL Database creation can be automated using ____________. a) ARM Template b) Azure CLI c) Azure PowerShell d) All of the above - correct answer resp d) All of the above 23 - SQL Server, Azure SQL Database, Azure SQL Managed Instance can all be accessed using: a) Azure Data Studio b) Microsoft SQL Server Management Studio c) Microsoft SQL Server Data d) All of the above - correct answer resp d) All of the above 24 - SQL Server, Azure SQL Database, Postgresql can all be accessed using:__________________ a) Azure Data Studio
b) Microsoft SQL Server Management Studio c) Microsoft SQL Server Data d) All of the above - correct answer resp a) Azure Data Studio 25 - Azure MySql Database and MariaDB can be accessed using: a) Azure Data Studio b) Microsoft SQL Server Management Studio c) Microsoft SQL Server Data d) MySQL WorkBench - correct answer d) MySQL WorkBench 26 - TRUE or FALSE: You can create multiple clustered indices for one table a) True b) False - correct answer resp b) False 27 - TRUE or FALSE: Data stored in Azure Storage Zone-redundant storage (ZRS) is replicated across multiple availability zones a) True b) False - correct answer resp a) True 28 - `TRUE or FALSE: Data stored in Azure Blob Storage using archive tier has low storage cost and high retrieval cost a) True b) False - correct answer resp a) True
33 - TRUE or FALSE: Azure Cosmos DB Table API supports both read replica's and multi region writes a) True b) False - correct answer resp a) True 34 - TRUE or FALSE: Azure Data Lake Storage enables folder level hierarchy a) True b) False - correct answer resp a) True 35 - TRUE or FALSE: Prefer relational databases when strong transactional consistency guarantees are needed a) True b) False - correct answer resp a) True 36 - You are setting up a new SQL Server database in Azure. You want to minimize operational overheads. Which of these Azure databases would you recommend? a) Azure Cosmos DB MongoDB API b) Azure Table Storage c) Sql Server on Windows Virtual Machine d) Azure SQL Database - correct answer resp d) Azure SQL Database 37 - You have a requirement to keep your files for period of 5 years. These files will be very rarely accessed. What storage tier would you recommend to keep your costs low? a) Hot b) Cold
c) Archive - correct answer resp c) Archive 38 - Your application needs to store unstructured data like images and videos. Which type of data store do you recommend? a) Key-Value b) Columnar c) Document d) Object Storage - correct answer resp d) Object Storage 39 - Which of these is a column family database? a) Azure Cosmos DB MongoDB b) Azure Cosmos DB Cassandra c) Azure Cosmos Gremlin d) Azure Table Storage - correct answer resp b) Azure Cosmos DB Cassandra 40 - TRUE or FALSE: Azure Cosmos DB Gremlin API Graph database can be queried using Gremlin Language a) True b) False - correct answer resp a) True 41 - TRUE or FALSE: Azure Storage Account supports role based access control at folder and file level only for Azure Data Lake Storage a) True b) False - correct answer resp a) True
46 - Which of these is a virtual table representing content based on the result set of query? (You can join multiple tables in the query and/or have calculated columns) a) Stored Procedure b) View c) Clustered Index d) SCHEMA - correct answer resp b) View 47 - Azure SQL Database and Postgresql supports Multi-factor authentication mechanism when using _________________ a) Local Admin Account b) Mutual SSL c) Azure Active Directory (AAD) d) Managed Identity - correct answer resp c) Azure Active Directory (AAD) 48 - Which of these features of Azure SQL Managed Instance is NOT provided by Azure SQL Database? a) Azure Active Directory (AAD) b) Transparent Data Encryption c) Automated Backups d) Native Support for Cross-database Queries within a single SQL Server Instance
- correct answer resp d) Native Support for Cross-database Queries within a single SQL Server Instance 49 - You can restrict access to Azure SQL Database (allow only a specific range of IP addresses/virtual network) using _____________ a) Azure Security Center b) Network Security Group
c) Application Security Group d) Server Level Firewall - correct answer resp d) Server Level Firewall 50 - For which of these usecases would you recommend using Azure SQL Database Read only database replica? a) Ensure High Availability b) Distributed Write Transaction c) Reporting application which only reads data - correct answer resp c) Reporting application which only reads data 51 - TRUE or FALSE: In Azure Data Factory, a pipeline CANNOT execute another pipeline a) True b) False - correct answer resp b) False 52 - TRUE or FALSE: In Azure Data Factory, Integration Runtime provides compute infrastructure to perform desired operations a) True b) False - correct answer resp a) True 53 - TRUE or FALSE: Treemaps are charts with colored rectangles nested within a rectangle. The size of a colored rectangle represents value. a) True b) False - correct answer resp a) True
59 - Which of these can you use to analyze if a retail company has sufficient stock of products to meet the demand on Black Friday? a) Descriptive Analysis b) Diagnostic analytics c) Predictive analytics d) Prescriptive analytics - correct answer resp c) Predictive analytics 60 - Temperature sensors sending readings every hour is example of _________ a) Batch processing b) Stream processing - correct answer resp a) Batch processing 61 - TRUE or FALSE: In a clustered index, data is stored in random order a) True b) False - correct answer resp b) False 62 - You have several virtual machines running on-premises and in the cloud. You want to map a network shared drive connected to all these machines. Which of these Azure services would you recommend? a) Virtual Machine Data Disk b) Azure Blob Containers c) Azure Files - correct answer resp c) Azure Files 63 - TRUE or FALSE: In PaaS, customer has access to VM instances a) True
b) False - correct answer resp b) False 64 - Which service supports Server Message Block (SMB) and Network File System (NFS) protocols? a) Azure Files b) Azure Blob Storage c) Azure Cosmos DB - correct answer resp a) Azure Files 65 - Categorize activity: Orchestrate pipeline activity based on output of another pipeline activity a) Data movement b) Data transformation c) Control Flow - correct answer resp c) Control Flow 66 - Which of these can be used to connect to an external source (store external connection details) from Data Factory? a) Linked Service b) Triggers c) Integration Runtime d) Pipeline - correct answer resp a) Linked Service 67 - Which of these represents 'One or more pages of visualizations in Power BI'? a) Report b) Dashboard c) Dataset - correct answer resp
