Az 900 Flashcards by Soleil Brown

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

Descriptive Analytics

How well did you know this?

Not at all

Perfectly

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

Normalization

How well did you know this?

Not at all

Perfectly

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.

You should consider making use of batch processing.

How well did you know this?

Not at all

Perfectly

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

Cognitive Analytics

How well did you know this?

Not at all

Perfectly

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.

Easy to retrieve data. Flexibility. Data integrity

How well did you know this?

Not at all

Perfectly

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

Key influencer

How well did you know this?

Not at all

Perfectly

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

UPDATE

How well did you know this?

Not at all

Perfectly

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

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?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

How well did you know this?

Not at all

Perfectly

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.

You should consider making use of Real time processing.

How well did you know this?

Not at all

Perfectly

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

You should implement Azure Active Directory (Azure AD) authentication

How well did you know this?

Not at all

Perfectly

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

Yes

How well did you know this?

Not at all

Perfectly

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

Yes

How well did you know this?

Not at all

Perfectly

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

How well did you know this?

Not at all

Perfectly

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 firewall at the database-level is preventing access.

How well did you know this?

Not at all

Perfectly

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.

The sqlcmd utility.

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

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

Yes

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

HDInsight is a non-relational database.

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

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

Yes

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

Does the action achieve your objective?

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

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.

You make use of Azure Files.

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

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.

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

Azure data lake

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

Yes

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 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

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.

Availability zones

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

Graph data storage

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

Yes

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

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

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

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

The statement is a data definition language (DDL) statement Select Update Delete Alter index

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

The statement is required to alter the stock amount of a product in a SQL database table Insert Bulk insert Update Select

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

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

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.

The table permission is required to query a table in a database Read Select Alter Insert

Select

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

Geo redundant storage Geo zone redundant storage