DP900 Questions Dump Flashcards
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?
A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure virtual machines
Answer: B
You need to query a table named Products in an Azure SQL database.
Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. You must be assigned the Reader role for the resource group that contains the database.
B. You must have SELECT access to the Products table.
C. You must have a user in the database.
D. You must be assigned the Contributor role for the resource group that contains the database.
E. Your IP address must be allowed to connect to the database.
Answer: BCE
Which command-line tool can you use to query Azure SQL databases?
A. sqlcmd
B. bcp
C. azdata
D. Azure CLI
Answer: A
You have a transactional application that stores data in an Azure SQL managed instance. In which of the following circumstances would you need to implement a read-only database replica?
A. You need to generate reports without affecting the transactional workload.
B. You need to audit the transactional application.
C. You need to implement high availability in the event of a regional outage.
D. You need to improve the recovery point objective (RPO).
Answer: A
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use?
A. Service Principal Authentication
B. Azure Active Directory (Azure AD) Authentication
C. SQL Authentication
D. Certificate Authentication
Answer: B
What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
A. Built-in high availability
B. Native support for cross-database queries and transactions
C. System-initiated automatic backups
D. Support for encryption at rest
Answer: B
When you create an Azure SQL database, which account can always connect to the database?
A. The Azure Active Directory (Azure AD) account that created the database
B. The SA account
C. The server admin login account of the logical server
D. The Azure Active Directory (Azure AD) administrator account.
Answer: C
You have an Azure SQL database that you access directly from the Internet. You recently changed your external IP address. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. What is a possible cause of the issue?
A. Role-based access control (RBAC)
B. Dynamic Host Configuration Protocol (DHCP)
C. Domain Name Service (DNS)
D. A database-level firewall
Answer: D
Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?
A. Azure SQL Database Hyperscale
B. Azure SQL managed instance
C. Azure SQL Database serverless
D. Azure SQL Database elastic pod
Answer: C
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
By default, each Azure SQL database is protected by:
A. A network security group (NSG)
B. A server-level firewall
C. Azure Firewall
D. Azure Front Door
Answer: B
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A relational database must be used when:
A. A dynamic schema is required.
B. Data will be stored as key/value pairs.
C. Storing large images and videos.
D. Strong consistency guarantees are required.
Answer: D
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A relational database is appropriate for scenarios that involve a high volume of:
A. Changes to relationships between entities
B. Geographically distributed writes
C. Transactional writes
D. Writes that have varying data structures
Answer: C
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
Transparent Data Encryption (TDE) encrypts:
A. A column to protect data at rest and in transit
B. Queries and their results in order to protect data in transit
C. The database to protect data at rest
D. The server to protect data at rest
Answer: C
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
- Azure SQL Database includes a fully managed backup service
- Azure SQL Database has built-in high availability
- Azure SQL Database can use Azure Advanced Threat Protection (ATP)
Answer: 1:Yes, 2:Yes, 3:Yes
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
- You must apply patches to Azure SQL databases regularly
- You need a Microsoft 365 subscription to create an Azure SQL database
- You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases
Answer: 1:No, 2:No, 3:Yes
Match the security components to the appropriate scenarios. To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Components:
A. Authentication
B. Firewall
C. Encryption
Answer Area:
D. Prevent access to an Azure SQL Database from another network.
E. Support Azure AD sign-ins to an Azure SQL database.
F. Ensure that sensitive data never appears as plain text in an Azure SQL database.
Answer: BD, AE, CF
Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse. Which type of processing does the reporting solution use?
A. Stream processing
B. Batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)
Answer: C
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?
A. Online Transaction Processing (OLTP)
B. Batch processing
C. Stream processing
D. Online Analytical Processing (OLAP)
Answer: D
You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?
A. Online Analytical Processing (OLAP)
B. Batch Processing
C. Stream processing
D. Online Transaction Processing (OLTP)
Answer: D
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
A. Denormalized data B. Heavy writes and moderate reads C. Light writes and heavy reads D. Schema on write E. Schema on read F. Normalized data
Answer: BDF
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
In a data warehousing workload, data:
A. from a single source is distributed to multiple locations
B. from multiple sources is combined in a single location
C. is added to a queue for multiple systems to process
D. is used to train machine learning models
Answer: B
What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Access to the latest features
B. Complete control over backup and restore processes
C. in-database machine learning services
D. Reduced administrative effort for managing the server infrastructure
Answer: AD
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application?
A. Azure Cosmos DB
B. Azure HDInsight
C. Azure SQL Database
D. SQL Synapse Analytics
Answer: C
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. PaaS database offerings in Azure provide built-in high availability
B. PaaS database offerings in Azure provide configurable scaling options
C. PaaS database offerings in Azure. reduce the administrative overhead for managing hardware
Answer: A:Yes, B:Yes, C:Yes
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. If you have a PaaS database in Azure, you are responsible for applying operating system updates.
B. If you have a PaaS database in Azure, backups are performed automatically
C. If you have a PaaS database in Azure, you are responsible for upgrading the database engine
Answer: A:No, B:Yes, C:No
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. PaaS database offerings in Azure require less setup and configuration effort than IaaS database offerings
B. PaaS database offerings in Azure provide administrators with the ability to control and update the operating system version
C. All PaaS database offerings in Azure can be paused to reduce costs.
Answer: A:Yes. B:No, C:No
What are two uses of data visualization? Each correct answer presents a complete solution.
NOTE: Each correct answer selection is worth one point.
A. Represent trends and patterns over time
B. Implement machine learning to predict future values
C. Communicate the significance of data
D. Consistently implement business logic across reports
Answer: AC
Match the types of visualizations to the appropriate descriptions. To answer, drag the appropriate visualization type from the column on the left to its description, on the right. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and place:
Visualization:
A. Key influencer
B. Scatter
C. Treemap
Answer Area:
D. A chart of colored, nested rectangles that displays individual data points, represented by the size and color of a relative rectangle
E. A chart that displays major contributors of a selected result or value
F. A chart that shows the relationship between two numerical values
Answer: CD, AE, BF
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. Azure Data Bricks can consume data from Azure SQL Database
B. Azure Data Bricks can consume data from Azure Event Hubs
C. Azure Data Bricks can consume data from Azure Cosmos DB
Answer: A:Yes, B:Yes, C:Yes
When can you use an Azure Resource Manager template?
A. To automate the creation of an interdependent group of Azure resources in a repeatable way
B. To apply Azure policies for multi-tenant deployments
C. To provision Azure subscriptions
D. To control which services and feature administrators and developers can deploy from the Azure portal
Answer: A
At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Database
B. Item
C. Container
D. SQL Partition
Answer: AC
What is a benefit of the Azure Cosmos DB Table API as compare to Azure Table storage?
A. Provides resiliency if an Azure region fails
B. Supports partitioning
C. Provides a higher storage capacity
D. Supports a multi-master model
Answer: D
You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. The throughput
B. The read region
C. The partition key
D. The API
Answer: AC
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
A. Multi-master replication
B. Availability zones
C. The strong consistency level
D. Automatic failover
Answer: B
At which level in Azure Cosmos DB can you configure multiple write and read regions?
A. Database
B. Partition
C. Collection
D. Account
Answer: D
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
You can query a graph database in Azure Cosmos DB…
A. as a JSON document by using a SQL-like language.
B. as a partitioned row store by using Cassandra Query Language (CQL).
C. as a partitioned row store by using Language-Integrated. Query. (LINQ).
D. as nodes and edges by using the Gremlin language.
Answer: A
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account.
B. Partition keys are used in Azure Cosmos DB to optimize queries.
C. Items contained in the same Azure Cosmos DB logical partition can have different partition keys.
Answer: A:No, B:Yes. C:No
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. Azure Table storage supports multiple read replicas
B. Azure Table storage supports multiple write regions
C. The Azure Cosmos DB Table API supports multiple read replicas
D. The Azure Cosmos DB Table API supports multiple write regions
Answer: A:Yes, B:No, C:Yes, D:Yes
Match the datastore services to the appropriate descriptions. To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Services:
A. Azure Blob storage
B. Azure Cosmos DB
C. Azure Files
D. Azure Table storage
Answer Area:
E. Enables the use of SQL queries against data stored in JSON documents
F. Enables users to access data by using the Server Message Block (SMB) version 3 protocol.
Answer: BE, CF
Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics
Answer: BC
What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Data is processed periodically
B. Low latency is expected
C. High latency is acceptable
D. Data is processed as it is created
Answer: BD
Which scenario is an example of a streaming workload?
A. Sending transactions that are older than a month to an archive
B. Sending transactions daily from point of sale (POS) devices
C. Sending telemetry data from edge devices
D. Sending cloud infrastructure metadata every 30 minutes
Answer: C
You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?
A. Online Transaction Processing (OLTP)
B. Batch processing
C. Massively Parallel Processing (MPP)
D. Streaming
Answer: D
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
Batch workloads
A. process data in memory, row-by-row.
B. collect and process data at most one a day.
C. process data as new data is received in near real-time.
D. collect data and then process the data when a condition is met.
Answer: D
Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Workload Types:
A. Batch
B. Streaming
Answer Area:
C. Analyzing web traffic from the past year
D. Classifying images that were uploaded last month.
E. Tracking how many people are currently using a website
Answer: AC, AD, BE
Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Workload Types:
A. Batch
B. Streaming
Answer Area:
C. Data for a product catalog will be loaded every 12 hours to a data warehouse
D. Data for online purchases will be loaded to a data warehouse as the purchase occurs
E. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions
Answer: AC, BD, AE
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
A. Processing salary payments once a month is an example of a batch workload
B. A wind turbine that sends 50 sensor readings per second is an example of a streaming workload
C. A home electricity meter that sends readings once a day to an energy provider is an example of a streaming workload
Answer: A:Yes, B:Yes, C:No
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
In batch processing
A. data is always inserted one row at a time
B. data is processed in real-time
C. latency is expected
D. processing can only execute serially
Answer: C
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. Batch processing can output data to a file store
B. Batch processing can output data to a relational database
C. Batch processing can output data to a NoSQL database
Answer: A:Yes, B:Yes, C:Yes
You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Zone-redundant storage (ZRS)
B. Read-access geo-redundant storage (RA-GRS)
C. Locally-redundant storage (LRS)
D. Geo-redundant storage (GRS)
Answer: BD
You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which of the following service within an Azure storage account could you use for this purpose?
A. Queue
B. Blob
C. File
D. Table
Answer: C
You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?
A. Azure Files
B. Azure Blob storage
C. Azure Cosmos DB
D. Azure Table storage
Answer: A
Which storage solution supports role-based access control (RBAC) at the file and folder level?
A. Azure Disk Storage
B. Azure Data Lake Storage
C. Azure Blob storage
D. Azure Queue storage
Answer: B
You need to store data in Azure Blob storage for seven years to meet your company’s compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs. Which storage tier should you use?
A. Archive
B. Hot
C. Cool
Answer: A
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation…
A. enable the hierarchical namespace
B. set Account kind to BlobStorage
C. set Performance to Premium
D. set Replication to Read-access geo-redundant storage (RA-GRS)
Answer: A
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a…
A. graph
B. table
C. partition key
D. document
Answer: A
Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Data Store Types:
A. Graph
B. Object
C. Key/Value
Answer Area:
D. Application users and their default language
E. Medical images and their associated metadata
F. Employee data that shows the relationships between employees
Answer: AF, BE, CD
Match the Azure Cosmos DB APIs to the appropriate data structures. To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
APIs:
A. Cassandra API
B. Gremlin API
C. MongoDB API
D. Table API
Answer Area:
E. Graph data
F. JSON documents
G. Key/value data
Answer: BE, CF, DG
Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Data Types:
A. Image files
B. Key/value pairs
C. Relationships between employees
Answer Area:
D. Azure Blob storage
E. Azure Cosmos DB Gremlin API
F. Azure Table storage
Answer: AD, BF, CE
Which of the following is required for an extract, load and transform (ELT) process?
A. A data pipeline that includes a transformation engine
B. A separate transformation engine
C. A target data store powerful enough to transform the data
D. Data that is fully processed before being loaded to the target data store
Answer: C
To complete the sentence, select the appropriate option in the answer area
Answer Area:
An extract, transform, and load (ETL) process requires…
A. a matching schema in the data source and the data target
B. a target data store powerful enough to transform data
C. data that is fully processed before being loaded to the target data store
D. that the data target be a relational database
Answer: C
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Locations:
A. An in-memory data integration tool
B. The CRM system
C. The data warehouse
Answer Area:
D. Extract
E. Load
F. Transform
Answer: AF, BD, CE
You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?
A. Microsoft SQL Server Data Tools (SSDT)
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Databricks
D. Azure Data Studio
Answer: A
You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use?
A. Microsoft SQL Server Management Studio (SSMS)
B. Azure Data Studio
C. Azure CLI
D. Azure PowerShell
Answer: B
A set of developers have computers that run Windows 10 and Ubuntu Desktop. They need to connect and query an Azure SQL database from their computer. The developers require code assistance features such as IntelliSense. Which of the following can be used for this requirement?
A. Azure Data Studio
B. SSMS
C. Azure Data Explorer
Answer: A
Which is not a tool to access DB?
A. Query Editor
B. Data Studio
C. Storage Explorer
D. VS Code
Answer: C
Explanation: All others can be used to access DB
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS.
B. Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.
C. Azure Data Studio can be used to restore a database.
Answer: A:Yes, B:No, C:Yes
Match the tools to the appropriate descriptions. To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:
Tools:
A. Azure Data Studio
B. Microsoft SQL Server Data Tools (SSDT)
C. Microsoft SQL Server Mgmt Studio (SSMS)
D. Microsoft Visual Studio Code
Answer Area:
E. A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management and administration tasks.
F. A lightweight source code editor with an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL
G. A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files.
H. A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.
Answer: CE, DF, AG, BH
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. You can use Azure Data Studio to query a Microsoft SQL Server big data cluster
B. You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse
C. You can use MySQL Workbench to query Azure Database for MariaDB databases
Answer: A:Yes, B:Yes, C:Yes
Which Azure Data Factory component provides the compute environment for activities?
A. A linked service
B. An integration runtime
C. A control flow
D. A pipeline
Answer: B
Which Azure Data Factory component initiates the execution of a pipeline?
A. A control flow
B. A trigger
C. A parameter
D. An activity
Answer: B
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
In Azure Data Factory, you can use…
A. a control flow
B. a dataset
C. a linked service
D. an integration runtime
…to orchestrate pipeline activities that depend on the output of other pipeline activities.
Answer: A
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. Azure Databricks is an Apache Spark-based collaborative analytics platform
B. Azure Analysis Services is used for transactional workloads
C. Azure Data Factory orchestrates data integration workflows
A:Yes, B:No, C:Yes
Explanation: Azure Analysis Services is used for Data Warehousing
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer Area:
A. A pipeline is a representation of a data structure within Azure Data Factory
B. Azure Data Factory pipelines can execute other pipelines
C. A processing step within an Azure Data Factory pipeline is an activity
Answer: A:No, B:Yes, C:Yes
Explanation: Datasets represents a data structure in Azure Data Factory
Match the Azure services to the appropriate requirements. To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service may be used once, more than once, or not at all.
Select and Place:
Services:
A. Azure Data Factory
B. Azure Data Lake Storage
C. Azure SQL Database
D. Azure Synapse Analytics
Answer Area:
E. Output data to Parquet format
F. Store data that is in Parquet format
G. Persist a tabular representation of data that is stored in Parquet format
Answer: AE, BF, DG
Match the types of activities to the appropriate Azure Data Factory activities. To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Activity Types:
A. Control
B. Data movement
C. Data transformation
Answer Area:
D. Copy
E. Mapping data flow
F. Until
Answer: AF, BD, CE
Match the Azure Data Factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Components:
A. Dataset
B. Linked service
C. Mapping data flow
D. Pipeline
Answer Area:
E. A representation of data structures within data stores
F. The information used to connect to external resources
G. A logical grouping of activities that performs a unit of work and can be scheduled
Answer: AE, BF, DG,
You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
A. Key/value
B. Columnar
C. Object
D. Document
Answer: C
Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema.
Which type of data store should you use?
A. Columnar
B. Key/value
C. Document
D. Graph
Answer: B
Explanation: In key/value stores schema values must be defined by the application
Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores all the data for an entity in the same document?
A. Document
B. Columnar
C. Graph
D. Time series
Answer: A
Explanation: Schema is flexible and not application-defined
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?
A. Key/value
B. Graph
C. Columnar
D. Document
Answer: C
Explanation: Column family stores have high throughput with low latency
Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?
A. Relational
B. Time series
C. Graph
D. Columnar
Answer: B
Your company needs to design a DB that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. Which type of data store should you use?
A. Graph
B. Key/value
C. Document
D. Columnar
Answer: A
Explanation: Performs queries across nodes and edges and analyzes network of relationships
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A key/value data store is optimized for…
A. enforcing constraints
B. simple lookups
C. table joins
D. transactions
Answer: B
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Answer Area:
A. When ingesting data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth
B. You can use blob, table, and file storage in the same Azure Storage account
C. You implement Azure Data Lake Storage by creating an Azure Storage account
Answer: A:Yes, B:Yes, C:Yes
A bar chart showing year-to date sales by region is an example of which type of analytics?
A. Descriptive
B. Diagnostic
C. Predictive
D. Prescriptive
Answer: B
I have a car showroom and I am thinking to open a new branch of my showroom. I want to find out where I should open my new showroom based on sales data. Which analytics will tell me that?
A. Descriptive
B. Diagnostic
C. Predictive
D. Prescriptive
Answer: A
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
Transcribing audio files is an example of…
A. cognitive
B. descriptive
C. predictive
D. prescriptive
analytics.
Answer: A
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
Descriptive analytics tells you…
A. what is most likely to occur in the future
B. what occurred in the past
C. which actions you can perform to affect outcomes
D. why something occurred in the past
Answer: B
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A visualization that shows a university’s current student enrollment versus the maximum capacity is an example of…
A. cognitive
B. descriptive
C. predictive
D. prescriptive
analytics.
Answer: B
Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Analytics Types:
A. Cognitive B. Diagnostic C. Descriptive D. Predictive E. Prescriptive
Answer Area:
F. Why did sales increase last month?
G. How do I allocate my budget to buy different inventory items?
H. Which people are mentioned in a company’s business documents?
Answer: BF, EG, CH
You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data remains intact. What should you do on the SQL pool?
A. Scale down the data warehouse units (DWUs)
B. Pause the pool
C. Create a user-defined restore point
D. Delete the pool
Answer: B
Explanation: Azure SA provides the ability to pause the pools that hosts your DWs
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Answer Area:
A. Azure SA scales storage and compute independently
B. Azure SA can be paused to reduce compute costs
C. An Azure SA data warehouse has a fixed storage capacity
Answer: A:Yes, B:Yes, C:No
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
The massively parallel processing (MPP) engine of Azure Synapse Analytics…
A. distributes processing across compute nodes
B. distributes processing across control nodes
C. redirects client connections across compute nodes
D. redirects client connections across control nodes
Answer: A
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. JOIN
C. MERGE
D. CREATE
Answer: D
Which of the following is an example of Data Manipulation Language (DML)?
A. REVOKE
B. DISABLE
C. INSERT
D. GRANT
Answer: C
You have designed a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?
A. An index
B. A view
C. A scalar function
D. A table
Answer: B
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
Relational data uses…
A. collections
B. columns
C. keys
D. partitions
to enforce relationships between different tables.
Answer: C
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A. A clustered index
B. A FileTable
C. A foreign key
D. A stored procedure
…is an object associated with a table that sorts and stores the data rows in the table based on their key values.
Answer: A
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A. A heap
B. A stored procedure
C. A view
D. An index
…is a virtual table that contains content defined by a query.
Answer: C
Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Terms:
A. Index
B. View
C. Table
Answer Area:
D. A database object that holds data
E. A database object whose content is defined by a query
F. A database object that helps improve the speed of data retrieval
Answer: AF, BE, DC
What should you use to build a Microsoft Power BI paginated report?
A. Charticulator
B. Power BI Desktop
C. Power BI Service
D. Power BI Report Builder
Answer: D
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution.
A. Report and dashboard creation
B. Data modeling
C. Report sharing and distribution
D. Data acquisition and preparation
Answer: AC
You need to develop a solutions to provide data to executives. The solution must provide an interactive graphical interface, depict various KPIs, and support data exploration by using drill down. What should you use in Microsoft Power BI?
A. A dashboard
B. A report
C. A dataflow
D. Microsoft Power Apps
Answer: B
Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. A report page B. A Microsoft PowerPoint slide C. A visualization from a report D. A dataflow E. A text box
Answer: ACE
To complete the sentence, select the appropriate option in the answer area.
Answer Area:
A Microsoft Power BI…
A. dashboard
B. interactive report
C. paginated report
D. subscription
enables users to create highly formatted, fixed-layout documents optimized for printing and archiving.
Answer: C
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
A. A Microsoft Power BI dashboard is associated with a single workspace
B. A MS Power BI dashboard can only display visualizations from a single dataset
C. A MS Power BI dashboard can display visualizations from a MS Excel workbook
Answer: A:Yes, B:No, C:Yes
Explanation: Reports can only use one dataset but dashboards can use multiple
You need to use T-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse. What should you use to query the files?
A. Azure Functions
B. Microsoft SQL Server Integration Services (SSIS)
C. PolyBase
D. Azure Data Factory
Answer: C
Explanation: Easy for use and query T-SQL data with PolyBase
Which of the following is an Azure storage solution that provides native support for POSIX-compliant access control lists?
A. Azure Queue storage
B. Azure Data Lake Storage
C. Azure Table Storage
D. Azure Files
Answer: B
Explanation: Implements an access control model
