[Q24-Q49] Attested DP-900 Dumps PDF Resource [2023]

Attested DP-900 Dumps PDF Resource [2023]

Latest DP-900 Actual Free Exam Questions Updated 242 Questions

NEW QUESTION 24
Match the types of workloads the appropriate scenario.
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.

Answer:

Explanation:

NEW QUESTION 25
You have a table named Sales that contains the following data.

You need to query the table to return the average sales amount day. The output must produce the following results.

How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

NEW QUESTION 26
Select the answer that correctly completes the sentence.

Answer:

Explanation:

NEW QUESTION 27
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. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Explanation

Box 1: The CRM system
Data is extracted from the CRM system.
Box 2: The data warehouse
Data is loaded to the data warehouse.
Box 3: An in-memory data integration tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.

NEW QUESTION 28
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:

Explanation:

Reference:
https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms
https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

NEW QUESTION 29
Which command-line tool can you use to query Azure SQL databases?

A. azdata
B. Azure CLI
C. sqlcmd
D. bcp

Answer: B

Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/az-cli-script-samples-content-guide?tabs=singledatabase

NEW QUESTION 30
You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point

Answer:

Explanation:

Reference:
https://en.wikipedia.org/wiki/Snowflake_schema
https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

NEW QUESTION 31
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

NEW QUESTION 32
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:

Explanation:

NEW QUESTION 33
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:

Explanation:

Explanation

Box 1: Yes
Like IaaS, PaaS includes infrastructure - servers, storage, and networking - but also middleware, development tools, business intelligence (BI) services, database management systems, and more. PaaS is designed to support the complete web application lifecycle: building, testing, deploying, managing, and updating.
PaaS allows you to avoid the expense and complexity of buying and managing software licenses, the underlying application infrastructure and middleware, container orchestrators such as Kubernetes, or the development tools and other resources Box 2: Yes You manage the applications and services you develop, and the cloud service provider typically manages everything else.

Box 3: No
There really is no way to pause / stop billing for your Azure SQL Database.
Microsoft's official answer "Yes, you can export your database. Delete the Azure SQL database and that will pause billing. Then when you need it you can create a new database and import your previously exported DB."

NEW QUESTION 34
You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one pint.

A. locally-redundant storage (LRS)
B. geo-redundant storage (GRS)
C. zone-redundant storage (ZRS)
D. read-access geo-redundant storage (RA_GRS)

Answer: B,D

Explanation:
Azure Storage offers two options for copying your data to a secondary region:

With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

NEW QUESTION 35
When you create an Azure SQL database, which account can always connect to the database ?

A. the sa account
B. the Azure Active director/ (Azure AO) account that created the database
C. the server admin login account of the logical server
D. the Azure Active Directly Azure AD) administrator account

Answer: C

Explanation:
When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

NEW QUESTION 36
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

NEW QUESTION 37
Which statement is an example of Data Manipulation Language (DML)?

A. DISABLE
B. CREATE
C. REVOKE
D. UPDATE

Answer: D

Explanation:
Data Manipulation Language (DML) affect the information stored in the database. Use these statements to insert, update, and change the rows in the database.
BULK INSERT
DELETE
INSERT
SELECT
UPDATE
MERGE
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

NEW QUESTION 38
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:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability

NEW QUESTION 39
Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

A. the integration runtime
B. linked services
C. datasets
D. control flow

Answer: D

NEW QUESTION 40
Select the answer that correctly completes the sentence.

Answer:

Explanation:
See the answer in explanation below.
Explanation
Answer below as:

NEW QUESTION 41
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. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

NEW QUESTION 42
You are reviewing the data model shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point

Answer:

Explanation:

NEW QUESTION 43
Your company is designing a data store tor 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. graph
C. time series
D. columnar

Answer: C

Explanation:
Explanation
Time series data is a set of values organized by time. Time series databases typically collect large amounts of data in real time from a large number of sources. Updates are rare, and deletes are often done as bulk operations. Although the records written to a time-series database are generally small, there are often a large number of records, and total data size can grow rapidly.

NEW QUESTION 44
You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Answer:

Explanation:

Reference:
https://azure.microsoft.com/en-us/overview/what-is-saas/
https://azure.microsoft.com/en-us/overview/what-is-paas/

NEW QUESTION 45
What should you use to build a Microsoft Power BI paginated report?

A. the Power BI service
B. Power BI Report Builder
C. Charticulator
D. Power BI Desktop

Answer: B

Explanation:
Section: Describe an analytics workload on Azure
Explanation:
Power BI Report Builder is the standalone tool for authoring paginated reports for the Power BI service.
Reference:
https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-bi

NEW QUESTION 46
Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.

Which type of analysis is shown for the fourth quarter?

A. prescription
B. diagnostic
C. predictive
D. descriptive

Answer: A

NEW QUESTION 47
To complete the sentence, select the appropriate option in the answer area.

Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

NEW QUESTION 48
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.