Leave a Reply 13

Your email address will not be published. Required fields are marked *

Chef

Chef

No. it does not.

Amazon RDS currently does not support the following SQL Server features:

Maintenance Plans
Database Mail
Distributed Queries (i.e., Linked Servers)
Database Log Shipping
Change Data Capture (CDC) – Consider using Change Tracking as an alternative to CDC.
Replication
The ability to run Reporting, Analysis, Integration, or Master Data Services on the same server as the DB instance. If you need to do this, we recommend that you either install SQL Server on an EC2 instance or use an on-premise SQL Server instance to act as the Reporting, Analysis, Integration, or Master Data Services server.
Performance Data Collector
Service Broker or additional T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)
Distribution Transaction Coordinator (MSDTC)
WCF Data Services
FILESTREAM support
Policy-Based Management
SQL Server Audit
BULK INSERT and OPENROWSET(BULK…) features
Data Quality Services
Instant file initialization
Always On (2012 Enterprise Edition)
File tables
Server level triggers

Reply

networkmanagers

networkmanagers

I choose A

Reply

Guru

Guru

Has anyone given exam recently and these questions were asked in real exam?

Reply

Shipra

Shipra

hi Guru ,

I am planning to give AWS SAA exam ; Please let me know if these questions were asked in the exam ?

Reply

Rajan Vashisht

Rajan Vashisht

Yes

Reply

Ganesh Ghube

Ganesh Ghube

B.
Yes

Reply

CW

CW

Yes
Auditing To set up auditing, set the parameter rds.sqlserver_audit to the value fedramp_hipaa. If your DB instance is not already using a custom DB parameter group, you must create a custom parameter group and attach it to your DB instance before you can modify the rds.sqlserver_audit parameter. For more information, see Working with DB Parameter Groups.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html

Reply

Ran

Ran

The following Microsoft SQL Server features are not supported on Amazon RDS:

Always On (2012 Enterprise Edition)

Stretch database

Backing up to Microsoft Azure Blob Storage

Buffer pool extension

BULK INSERT and OPENROWSET(BULK…) features

Data Quality Services

Database Log Shipping

Database Mail

Distributed Queries (i.e., Linked Servers)

Distribution Transaction Coordinator (MSDTC)

File tables

FILESTREAM support

Maintenance Plans

Performance Data Collector

Policy-Based Management

PolyBase

R

Replication

Resource Governor

SQL Server Audit

Server-level triggers

Service Broker endpoints

T-SQL endpoints (all operations using CREATE ENDPOINT are unavailable)

WCF Data Services

Reply