Quiz
DP-900 part1
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (50)
1Descriptive analytics tells you
- AWhat is most likely to occur in the future.
- BWhat occurred in the past.
- CWhich actions you can perform to affect outcomes
- DWhy something occurred in the past
2Normalization involves eliminating relationships between database tables.
- ATrue
- BFalse
3Normalizing a database reduces data redundancy.
- ATrue
- BFalse
4Normalization improves data integrity.
- ATrue
- BFalse
5An extract, transform, and load (ETL) process requires
- Aa matching schema in the data source and the data target.
- Ba target data store powerful enough to transform data.
- Cdata that is fully processed before being loaded to the target data store.
- Dthat the data target be a relational database.
6In batch processing,
- Adata is always inserted one row at a time.
- Bdata is processed in real-time.
- Clatency in delivering data processing results is acceptable.
- Dprocessing can only execute serially.
7Transcribing audio files is an example of ___ analytics
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
8Why did sales increase last month?
- ACognitive
- BDiagnostic
- CPredictive
- DPrescriptive
9How do I allocate my budget to buy different inventory items?
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
10Which people are mentioned in a company's business documents?
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
11Customer is ___
- Aa nested array
- Ba nested object
- Ca root object
12Address is
- Aa nested array
- Ba nested object
- Ca root object
13social media is
- Aa nested array
- Ba nested object
- Ca root object
14The data model is a
- Atransactional model
- Bstar schema
- Csnowflake schema
15Customer is a
- Afact
- Bdimension
- Cbridge
16The massively parallel processing (MPP) engine of Azure Synapse Analytics
- Adistributes processing across compute nodes.
- Bdistributes processing across control nodes.
- Credirects client connections across compute nodes.
- Dredirects client connections across control nodes.
17__ is an object associated with a table that sorts and stores the data rows in the table based on their key values.
- AA clustered index
- BA FileTable
- CA foreign key
- DA stored procedure
18A relational database is appropriate for scenarios that involve a high volume of
- Achanges to relationships between entities
- Bgeographically distributed writes
- Ctransactional writes
- Dwrites that have varying data structures
19Batch processing can output data to a file store
- ATrue
- BFalse
20Batch processing can output data to a relational database
- ATrue
- BFalse
21Batch processing can output data to a NoSQL database
- ATrue
- BFalse
22Your 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?
Extract:- AAn in-memory data integration tool
- BThe CRM system
- CThe data warehouse
23Your 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?
Load:- AAn in-memory data integration tool
- BThe CRM system
- CThe data warehouse
24Your 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?
Transform:- AAn in-memory data integration tool
- BThe CRM system
- CThe data warehouse
25A visualisation that shows a university's current student enrollment versus the maximum capacity is an example of ___ analysis.
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
26A chart of coloured, nested rectangles that display individual data points represented by the size and colour of a relative rectangle.
- AKey influencer
- BScatter
- CTreemap
27A chart that displays the major contributors of a selected result or value.
- AKey influencer
- BScatter
- CTreemap
28A chart that shows the relationship between two numerical values.
- AKey influencer
- BScatter
- CTreemap
29You 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.- AZone-redundant storage (ZRS)
- BRead-access geo-redundant storage (RA-GRS)
- CLocally-redundant storage (LRS)
- DGeo-redundant storage (GRS)
30Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings.
- ATrue
- BFalse
31Platform as a service (PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version.
- ATrue
- BFalse
32All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs.
- ATrue
- BFalse
33Which statement is an example of Data Manipulation Language (DML)?
- AREVOKE
- BDISABLE
- CINSERT
- DGRANT
34You need a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to return the same SQL query.
- Aan index
- Ba view
- Ca scalar function
- Da table
35A key/value data store is optimised for
- Aenforcing constraints
- Bsimple lookups
- Ctable joins
- Dtransactions
36__ Azure Blob storage
- AImage files
- BKey/value pairs
- CRelationships between employees
37__ Azure Cosmos DB Gremlin API
- AImage files
- BKey/value pairs
- CRelationships between employees
38__ Azure Table storage
- AImage files
- BKey/value pairs
- CRelationships between employees
39Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.
Azure Resource Group --> __1__ --> __2__ --> Folders --> Files- A1) Azure Storage account
- B1) File share
- C1) Container
- D2) Azure Storage account
- E2) File share
- F2) Container
40What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
- AData is processed periodically
- BLow latency is expected
- CHigh latency is acceptable
- DData is processed as it is created
41__ A representation of data structures within a data stores
- ADataset
- BLinked service
- CMapping data flow
- DPipeline
42__ The information used to connect to external resources
- ADataset
- BLinked service
- CMapping data flow
- DPipeline
43A logical grouping of activities that performs a unit of work and can be scheduled
- ADataset
- BLinked service
- CMapping a data flow
- DPipeline
44Data for a product catalog will be loaded every 12 hours to a data warehouse.
- ABatch
- BStreaming
45Thousands of data sets per second for online purchases will be loaded into a data warehouse in real time
- ABatch
- BStreaming
46Updates to inventory data will be loaded to a data warehouse every 1 million transactions
- ABatch
- BStreaming
47Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown in the fourth quarter?
- APredictive
- BPrescriptive
- CDescriptive
- DDiagnostic
48Which statement is an example of Data Manipulation Language (DML)?
- AREVOKE
- BDISABLE
- CCREATE
- DUPDATE
49Creating closed caption text for audio files in an example of __ analystics.
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
50A visualisation that illustrates a university's current student enrollment per department is an example of __ analytics.
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
Information
- Description
- Quiz on DP-900 part1, created by Annika LAIRD on 23/11/2022.
- Author
- Annika LAIRD
- Language
- English
- Views
- 18
- Rating
- No ratings yet Rate this quiz