Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Az900 > Az 900 > Flashcards

Az 900 Flashcards

1
Q

You have been tasked with applying a data analytics type to a data solution.
The data analytics type should interpret historical data to better understand changes that have happened.
Which of the following is the data analytics type you should use?
A.
Cognitive Analytics
B.
Predictive Analytics
C.
Descriptive Analytics
D.
Diagnostic Analytics

A

Descriptive Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You are developing an Azure SQL relational database.
You need to make sure that your solution allows for data redundancy to be minimized, and data integrity to be increased.
Which of the following is the process that should be included in your solution?

A.
Denormalization
B.
Normalization
C.
Extract
D.
Transform

A

Normalization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

You have a data solution that must be configured to process large amounts of data at rest for analysis.
Which of the following actions should you take?
A.
You should consider making use of Online Analytical Processing (OLAP).
B.
You should consider making use of Real time processing.
C.
You should consider making use of Online Transaction Processing (OLTP).
D.
You should consider making use of batch processing.

A

You should consider making use of batch processing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You are developing an application that translates stored sound files into text.
You need to choose an analytics type to use for the application.
Which of the following should you choose?
A.
Cognitive Analytics
B.
Predictive Analytics
C.
Prescriptive Analytics
D.
Diagnostic Analytics

A

Cognitive Analytics

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You are tasked with developing a relational database.
Which of the following advantages of using relational databases? (Choose all that apply.)
A.
Easy to retrieve data.

B.
Inexpensive Scalability.
C.
Flexibility.
D.
Agile Programming.
E.
Data Integrity.

A

Easy to retrieve data. Flexibility. Data integrity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

You are analyzing data using Power BI. Your report needs to include a chart that aids the comprehension of the considerations that impact a key metric.
Which of the following is the visualization type you should use?
A.
Gauge
B.
Doughnut
C.
Key influencer
D.
Matrix

A

Key influencer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

You are creating a query that alters current data in a table in SQL Server. You need to make use of a Data Manipulation Language (DML) statement to achieve your goal.
Which of the following are options that could be used?
A.
DENY
B.
RENAME
C.
UPDATE
D.
WHERE

A

UPDATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

You have a SQL query that combines data from two tables. Calculated columns are incorporated into the query.
You have to make sure that the query can be used by other users by persisting the SQL query
You decide to create a view.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

You have a SQL query that combines data from two tables. Calculated columns are incorporated into the query.
You have to make sure that the query can be used by other users by persisting the SQL query
You decide to create an index.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You have a SQL query that combines data from two tables. Calculated columns are incorporated into the query.
You have to make sure that the query can be used by other users by persisting the SQL query
You decide to create a trigger.
A.
Yes, it does
B.
No, it does not

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

You have a data solution that must be configured to meet the following requirements:
Low latency.
Process data as it is generated.
Which of the following actions should you take?
A.
You should consider making use of Online Analytical Processing (OLAP).
B.
You should consider making use of Real time processing.
C.
You should consider making use of Online Transaction Processing (OLTP).
D.
You should consider making use of batch processing.

A

You should consider making use of Real time processing.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Your company has an Azure SQL subscription with a database named Accounts. Employees in the Accounts department can access from their on-premises computers.
You are required to configure multi-factor authentication (MFA) for the Accounts database.
What should you do?
A.
You should implement OATH
B.
You should implement Azure Active Directory (Azure AD) authentication
C.
You should implement Kerberos
D.
You should implement Certificate authentication

A

You should implement Azure Active Directory (Azure AD) authentication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You have been tasked with developing a database.
You are required to make use of a graphical tool that allows for developing project-oriented offline databases.

You make use of Microsoft SQL Server Data Tools (SSDT).
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

You have been tasked with developing a database.
You are required to make use of a graphical tool that allows for developing project-oriented offline databases.
You make use of Microsoft SQL Server Management Studio (SSMS).
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

You have been tasked with developing a database.
You are required to make use of a graphical tool that allows for developing project-oriented offline databases.
You make use of Microsoft Visual Studio.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

You regularly connect to an Azure SQL database straight from the Internet.
As a result of your external IP address changing, you are unable to connect to the database. You are, however, able to access other Azure resources.
Which of the following could be a reason for this happening?
A.
You no longer have the necessary permissions.
B.
A DNS record is misconfigured.
C.
A network security group (NSG).
D.
A firewall at the database-level is preventing access.

A

A firewall at the database-level is preventing access.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

You have an Azure SQL database.
You are preparing to query the database from the command-line
Which of the following is the tool you should use?
A.
The sqlcmd utility.
B.
The bcp utility.
C.
The sqlpackage utility.
D.
The mssql-conf utility.

A

The sqlcmd utility.

The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt.

18
Q

You are preparing to implement a software as a service (SaaS) application for your company. The application needs a relational database to provide Online Transaction Processing (OLTP).
You need to make use of an Azure service to allow for the application to run properly.
You make use of Azure SQL Database.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

19
Q

You are preparing to implement a software as a service (SaaS) application for your company. The application needs a relational database to provide Online Transaction Processing (OLTP).
You need to make use of an Azure service to allow for the application to run properly.
You make use of Azure HDInsight.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

No

HDInsight is a non-relational database.

20
Q

You are preparing to implement a software as a service (SaaS) application for your company. The application needs a relational database to provide Online Transaction Processing (OLTP).
You need to make use of an Azure service to allow for the application to run properly.
You make use of Azure Data Factory.
Does the action achieve your objective?

A.
Yes, it does
B.
No, it does not

A

No

21
Q

Your company has an application that has its stored data in a shared folder.
You have been tasked with transferring the shared folder to Azure Storage.
You need to choose the correct Azure Storage type.
You make use of Azure Files.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

22
Q

Your company has an application that has its stored data in a shared folder.
You have been tasked with transferring the shared folder to Azure Storage.
You need to choose the correct Azure Storage type.
You make use of Azure Blobs.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

No

23
Q

Your company has an application that has its stored data in a shared folder.
You have been tasked with transferring the shared folder to Azure Storage.
You need to choose the correct Azure Storage type.
You make use of Azure Disks.

Does the action achieve your objective?

A.
Yes, it does
B.
No, it does not

A

No

24
Q

Your company has an existing application that runs on Windows devices.
You have been informed that the application needs to be able to connect to a mapped drive. You need to make use of the necessary Azure service.
Which of the following actions should you take?
A.
You make use of Azure Files.
B.
You make use of Azure Disks.
C.
You make use of Azure Queues.
D.
You make use of Azure Tables.

A

You make use of Azure Files.

25
Q

You need to consider the underlined segment to establish whether it is accurate.
An object data store must be used for applications that will write large amounts of JSON data, as well as have an application-defined schema.
A.
No adjustment required.
B.
key/value
C.
search engine
D.
telemetry

A

Key/value

A key/value store associates each data value with a unique key.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.

26
Q

Your company has implemented an Azure database solution.
You must configure the use of a storage solution that allows for role-based access control (RBAC) at both the file and folder level.
Which storage solution should you use?

A.
Azure Tables
B.
Azure Data Lake
C.
Azure Blobs
D.
Azure Data Factory

A

Azure data lake

27
Q

A company compliance policy dictates that data must be stored in Blob storage for three years. Data retrieval time is insignificant, but the cost of the storage solution must be kept to a minimum.
You need to subscribe to suitable Blob storage tier.
You select the Archive storage tier.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

28
Q

A company compliance policy dictates that data must be stored in Blob storage for three years. Data retrieval time is insignificant, but the cost of the storage solution must be kept to a minimum.
You need to subscribe to suitable Blob storage tier.
You select the Premium storage tier.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

No

29
Q

A company compliance policy dictates that data must be stored in Blob storage for three years. Data retrieval time is insignificant, but the cost of the storage solution must be kept to a minimum.
You need to subscribe to suitable Blob storage tier.
You select the Cool storage tier.
Does the action achieve your objective?
A.
Yes, it does

B.
No, it does not

A

No

30
Q

You have an Azure SQL database named Sales that is a managed instance.
You want to implement disaster recovery for the Sales database. Your solution must ensure that there are at least two readable copies of Sales available during normal operations, and Sales must remain available even if a datacenter fails.
Which of the following features will meet your requirements?
A.
Azure Cosmos DB API.
B.
Availability Zones.
C.
Strong consistency levels.
D.
Global distribution.

A

Availability zones

31
Q

You are developing a database for your company.
Your database must meet the following requirements:
Persisting relationships in the storage layer
Which of the following should you implement?
A.
graph data storage
B.
data analytics
C.
time series data storage
D.
search engine

A

Graph data storage

32
Q

Your company has an Azure Synapse Analytics data warehouse.
You want to query files located in Azure Data Lake Storage using Transact-SQL, from the data warehouse.
You make use of PolyBase to query the files.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

Yes

33
Q

Your company has an Azure Synapse Analytics data warehouse.
You want to query files located in Azure Data Lake Storage using Transact-SQL, from the data warehouse.
You make use of Azure Data Studio to query the files.
Does the action achieve your objective?
A.
Yes, it does
B. No, it does not

A

No

34
Q

Your company has an Azure Synapse Analytics data warehouse.
You want to query files located in Azure Data Lake Storage using Transact-SQL, from the data warehouse.
You make use of Azure Data Factory to query the files.
Does the action achieve your objective?
A.
Yes, it does
B.
No, it does not

A

No

35
Q

You have an Azure Cosmos DB account that makes use of the Core (SQL) API. You are in the process of adding a container to the Azure Cosmos DB database.
Which of the following can be configured during this step? Answer by dragging the correct options from the list to the answer area.

Options:
The partition key

The throughput

The write region

The read region

A

The partition key

The throughput

Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/

36
Q

The statement is a data definition language (DDL) statement

Select
Update
Delete
Alter index

A

Delete

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data- warehouse-reference-tsql-statements

37
Q

The statement is required to alter the stock amount of a product in a SQL database table

Insert
Bulk insert
Update
Select

A

Update

Reference:

https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15

38
Q

You have an Azure SQL database with a very large table named ArchivedSales. The ArchivedSales table is shown in the following exhibit:

Column Data type
Sales_ID Int
Sales_Date DateTime
Sales_amount Numeric(8,4)
Customer_ID Int
product_ID Int
SalesPerson_id Int

You want to reduce the size of the ArchivedSales table.
Which of the following actions should you take?
A.
Apply page compression to the ArchivedSales table.
B.
Apply row compression to the ArchivedSales table
C.
Apply data compression to the ArchivedSales table
D.
Apply columnstore archival compression to the ArchivedSales table

A

Apply columnstore archival compression to the ArchivedSales table

Columnstore tables and indexes are always stored with columnstore compression. You can further reduce the size of columnstore data by configuring an additional compression called archival compression.
Note: Columnstore — The columnstore index is also logically organized as a table with rows and columns, but the data is physically stored in a column-wise data format.

39
Q

The table permission is required to query a table in a database

Read
Select
Alter
Insert

A

Select

40
Q

You have been tasked with generating an Azure Storage account.
You have to make sure that the account’s data automatically replicates outside the Azure region
Which of the following replication types could be used to achieve your goal? Answer by dragging the correct options from the list to the answer area.

Locally redundant storage
Zone redundant storage
Geo redundant storage
Geo zone redundant storage

A

Geo redundant storage

Geo zone redundant storage

Az900 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions