최신 DP-900 무료덤프 - Microsoft Azure Data Fundamentals
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
정답:
Which Azure Data Factory component provides the compute environment for activities?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
Your company is designing a data store that will contain student data. The data has the following format.
Which type of data store should you use?
Which type of data store should you use?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
정답:
Explanation:
A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.
One advantage of hierarchical namespace is atomic directory manipulation: Object stores approximate a directory hierarchy by adopting a convention of embedding slashes (/) in the object name to denote path segments.
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace
Hotspot Question
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
정답:
Explanation:
SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
The most significant difference from SQL Database and SQL Managed Instance is that SQL Server on Azure Virtual Machines allows full control over the database engine. You can choose when to start maintenance/patching, change the recovery model to simple or bulk-logged, pause or start the service when needed, and you can fully customize the SQL Server database engine.
With this additional control comes the added responsibility to manage the virtual machine.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is- overview?view=azuresql
Hotspot Question
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.
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.
정답:
Explanation:
Star Schema in data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. It is known as star schema as its structure resembles a star.
Dimension tables describe business entities - the things you model. Entities can include products, people, places, and concepts including time itself.
Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc. A fact table contains dimension key columns that relate to dimension tables, and numeric measure columns.
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Which of the following is not a checkpoint in the checklist for troubleshooting issues when you are working with Azure Cosmos DB .NET SDK?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
What is a characteristic of a non-relational database?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
A bank needs to ensure that after an account transfer transaction completes, the revised account balances persists even if the database system hosting the transaction becomes temporarily unavailable.
Of which ACID semantic is this an example?
Of which ACID semantic is this an example?
정답: C
You have data saved in the following format.
Which format was used?
Which format was used?
정답: A
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
Which Azure service should you use?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?
When should you implement a read-only database replica?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
Your company needs to implement a relational database in Azure.
The solution must minimize ongoing maintenance.
Which Azure service should you use?
The solution must minimize ongoing maintenance.
Which Azure service should you use?
정답: A
In Azure Table storage, each row in a table must be uniquely identified by which two components? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
정답: B,C
설명: (DumpTOP 회원만 볼 수 있음)
Drag and Drop Question
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.
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.
정답:
Explanation:
Box 1: SELECT
Box 2: GROUP BY
Example:
When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory.
SELECT TerritoryID, AVG(Bonus)as 'Average bonus', SUM(SalesYTD) as 'YTD sales' FROM Sales.SalesPerson GROUP BY TerritoryID; Reference:
https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql
Hotspot Question
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
정답:
An organization has been using a bar chart to present the year-wise sales of a region to track the status of sales year by year. How would you recognize the analytics here?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)