MDP(Custom)-Accenture-16/08/21 (Day 21)

Azure Cosmos DB analytical store is a fully isolated row store for enabling large-scale analytics against operational data in your Azure Cosmos DB, without any impact to your transactional workloads.

• True

• False

Azure Synapse Link is supported for :

• Azure Cosmos DB SQL (Core) API

  Azure Cosmos DB API for MongoDB

  Azure Cosmos DB Gremlin API

• Azure Cosmos DB SQL (Core) API

  Azure Cosmos DB API for MongoDB

  Azure Cosmos DB Gremlin API

  Azure Cosmos DB Cassandra API

• Azure Cosmos DB SQL (Core) API

  Azure Cosmos DB API for MongoDB

• Azure Cosmos DB SQL (Core) API

  Azure Cosmos DB Cassandra API

Apache Spark is a parallel processing framework that supports on-disk processing to boost the performance of big-data analytic applications.

• True

• False

1. You have a table in Azure Synapse Analytics created as shown:

CREATE TABLE Membership

(MemberID int IDENTITY,

FirstName varchar(100) NULL,

SSN char(9) NOT NULL,

LastName varchar(100) NOT NULL,

Phone varchar(12) NULL,

Email varchar(100) NULL);

Queries executed as User = “TestUser” fails for the following query execution:

SELECT * FROM Membership;

-- Msg 230, Level 14, State 1, Line 12

-- The SELECT permission was denied on the column 'SSN' of the object 'Membership', database 'CLS_TestDW', schema 'dbo'.

What was the correct syntax used to enforce column-level security for above scenario?

• GRANT SELECT FOR Membership(MemberID, FirstName, LastName, Phone, Email) ON TestUser;

• GRANT SELECT ON Membership(MemberID, FirstName, LastName, Phone, Email) TO TestUser;

• GRANT SELECT ON Membership(FirstName, LastName, Phone, Email) TO TestUser;

• None of the above

A query was executed in SSMS against a database named as AdventureWorksLT as follows:

SELECT o.name AS [Table Name]

,ac.name AS [Column Name]

,sc.label

,sc.information_type

FROM sys.sensitivity_classifications sc

INNER JOIN sys.objects o ON o.object_id = sc.major_id

INNER JOIN sys.all_columns ac ON ac.column_id = sc.minor_id

WHERE ac.object_id = o.object_id;

The query will return the results of :

• Rows being secured by row-level security

• Columns being secured by Dynamic Data Masking

• Classified columns

• None of the above

You heard about Azure Event Hubs which is a fully managed, real-time data ingestion service used to stream millions of events per second from variety of sources.

You have applications including Transaction processing, Anomaly detection and Archiving data.

You can use Azure Event Hubs for:

• Transaction processing and Archiving data only

• Anomaly detection only

• Transaction processing, Anomaly detection and Archiving data

• Anomaly detection and Archiving data only

While creating an Azure Databricks secret scope in order to fetch the secret value of the client secret for one application registered in AAD, you will mention

• Scope Name

  DNS Name

  Resource ID

• DNS Name

  Resource ID

• Scope Name

  Resource ID

• Scope Name

  Manage Principal

  DNS Name

  Resource ID

configs = {"fs.azure.account.auth.type": "OAuth",

"fs.azure.account.oauth.provider.type": "org.apache.hadoop.fs.azurebfs.oauth2.ClientCredsTokenProvider",

"fs.azure.account.oauth2.client.id": "<application-id>",

"fs.azure.account.oauth2.client.secret": dbutils.secrets.get(scope="<scope-name>",key="<service-credential-key-name>"),

"fs.azure.account.oauth2.client.endpoint": "https://login.microsoftonline.com/<directory-id>/oauth2/token"}

dbutils.fs.mount(

source = "abfss://<container-name>@<storage-account-name>.dfs.core.windows.net/",

mount_point = "/mnt/<mount-name>",

extra_configs = configs)

The following script will going to :

• authorize and create a mount point

• authenticate and create a mount point

• authenticate, create a mount point and list out the mount point

• None of the above

A job is a non-interactive mechanism for running a notebook or library either immediately or on a scheduled basis.

• True

• False

_________X_______ helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer.

It’s a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database is not changed.

What is X ?

• RLS

• Column Level Security

• TDE

• Dynamic Data Masking