Premium

Microsoft Certified: Azure Solutions Architect Expert Certification Questions and Answer (Dumps and Practice Questions)



Question : You are working in QuickTechie Inc and you manage a SQL Database in Azure named QuickDB which is running in Standard/SI tier. Database is in a server named QuickSvr
, which is a main production env of QuickTechie Inc. You also have another server named QuickTestSvr . Both QuickSvr1 and QuickTestSvr in the same subscription and same region
deployed on different Physical Clusters. Now development team asked you to copy QuickDB to test environment.

Select the correct steps you need to follow.

A. Use DB copy to create a copy of database QuickDB in QuickTestSvr named QuickDB
B. Set Export Status to Automatic for QuickDB in QuickSvr1
C. Use DB copy to create a copy of database QuickDB in QuickSvr named QuickDBTemp
D. Scale QuickDB to QuickTestSvr to Standard/SI tier
E. Import BACPAC file to the QuickTestSvr as QuickDB
F. Export QuickDBTemp in QuickSvr1 to BACPAC file in Azure Blob storage
G. Rename QuickDBTemp to QuickDB in QuickSvr1
H. Use active Geo-Replication and replicate QuickDB to QuickTestSvr
: You are working in QuickTechie Inc and you manage a SQL Database in Azure named QuickDB which is running in Standard/SI tier. Database is in a server named QuickSvr
1. A,B,C
2. C,D,E
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,G
5. A,C,H

Correct Answer : Get Lastest Questions and Answer : Exp: You can use the Azure SQL Database automated backups to create a copy of your SQL database. The copy operation copies the tail of the transaction log and then
uses the full, differential, and transaction log backups that are part of the automated backups to create that is transnationally consistent with the source database as of the time
of the final transaction log backup.

You can create the database copy on either the same server or a different server. The service tier and performance level (pricing tier) of the database copy are the same as the
source database. After the copy is complete, the copy becomes a fully functional, independent database. The logins, users, and permissions can be managed independently.

When you copy a database to the same logical server, the same logins can be used on both databases. The security principal you use to copy the database becomes the database owner
(DBO) on the new database. All database users, their permissions, and their security identifiers (SIDs) are copied to the database copy.

When you copy a database to a different logical server, the security principal on the new server becomes the database owner on the new database. Database users that are contained
users can be used in the copied database. However, when you copy the database to a new server, users based on logins will generally not work because the logins will not exist on the
new server, and if they do their SIDs may not match. After the new database is online on the destination server, use the ALTER USER statement to remap the users from the new database
to logins on the destination server. To resolve orphaned users, see Troubleshoot Orphaned Users.

To copy a SQL database you need the following:

An Azure subscription. If you need an Azure subscription simply click FREE TRIAL at the top of this page, and then come back to finish this article.
A SQL database to copy. If you do not have a SQL database, create one following the steps in this article: Create your first Azure SQL Database.

Bacpac is a sql database backed up file.
SQL Database supports the ability to import and export data using the BACPAC format.
A BACPAC file is an entity that encapsulates all of the objects (tables, stored procedures, views, and so on) along with the data in the database into a file.






Question : You are working in a QuickTechie Inc, you are managing a local VM, which you need to an Azure VM. You upload the virtual hard
disk (VHD) file to Azure Blob storage as a Block Blob . You need to change the Block blob to a page blob .
What should you do?



: You are working in a QuickTechie Inc, you are managing a local VM, which you need to an Azure VM. You upload the virtual hard
1. Delete the Block Blob and re-upload the VHD as a page blob.

2. Update the type of the blob programmatically by using the Azure Storage .NET SDK.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Create a new empty page blob and use the Azure Blob Copy Power Shell cmdlet to copy the current data to the new blob.


Correct Answer : Get Lastest Questions and Answer :
Explanation: To copy the data files to Windows Azure Storage by using one of the following methods: AzCopy Tool, Put Blob (REST API) and Put Page (REST API),
or Windows Azure Storage Client Library for .NET or a third-party storage explorer tool. Important: When using this new enhancement, always make sure that you create a page blob
not a block blob.

Azure has two main files storage format:
Page blob : mainly used for vhd's (CloudPageBlob)
Block Blob : for other files (CloudBlockBlob)




Question : You administer a Microsoft Azure SQL Database data base in the US Central region named
contosodb. Contosodb runs on a Standard tier within the SI performance level.
You have multiple business-critical applications that use contosodb.
You need to ensure that you can bring contosodb back online in the event of a natural
disaster in the US Central region. You want to achieve this goal with the least amount of
downtime.
Which two actions should you perform? Each correct answer presents part of the solution.

A. Upgrade to S2 performance level.
B. Use active geo-replication.
C. Use automated Export.
D. Upgrade to Premium tier.
E. Use point in time restore.
F. Downgrade to Basic tier.
: You administer a Microsoft Azure SQL Database data base in the US Central region named
1. B,D
2. C,E
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,E
5. A,C

Correct Answer : Get Lastest Questions and Answer : Exp: Standard = Passive Geo Replication
Premium = Active Geo Replication
Although geo-replication is available in Standard tier, it is passive. For active replication, you need Premium tier.

Geo-restore: Designed for emergency data recovery when you need it most, geo-restore recovers a database to any Azure region in the event of a catastrophic event. Geo-restore uses
geo-redundant Azure Blob storage for daily database backups and is available with Basic, Standard, and Premium tiers in the current Azure Management Portal and standard API.
Standard geo-replication: Opt in to a Microsoft managed geo-replication service with an asynchronously replicated secondary database that's ready to take over if disaster strikes.
Azure regions are pre-paired, at least 500 miles apart, and within geopolitical areas to help ensure data sovereignty. Standard geo-replication is available with Standard and Premium
databases in the current Azure Management Portal and standard APIs. Standard geo-replication incurs a cost for the secondary database, which is billed at 75 percent of the primary
database.
Auditing: The new audit feature tracks and logs events that occur on your database. Dashboard views and reports provide at-a-glance insight into database events. Use auditing to
streamline compliance-related activities, stay informed about what's happening in your database, and identify trends, discrepancies, and anomalies such as business concerns or
suspected security violations. Audit events are written to an audit log that is stored in an Azure storage account that you designate (note that Azure storage rates apply). Auditing
is available in Basic, Standard, and Premium tiers and only available in the new Azure Preview portal and via standard APIs.



Related Questions

Question : You are working on a website named QuickTechie.com , which is hosted on Azure . Now you created a job which erase the logs. Name of the the job is EraseLogs.cmd
EraseLogs.cmd will be executed manually, twice or thrice a week. Now wanted to deploy this JOb. Select the correct folder in which this jobs needs to be deployed.
 : You are working on a website named QuickTechie.com , which is hosted on Azure . Now you created a job which erase the logs. Name of the the job is EraseLogs.cmd
1. ./App_Code/jobs/triggered/cleanLogs/EraseLogs.cmd

2. ./App_Data/jobs/triggered/cleanLogs/EraseLogs.cmd

3. Access Mostly Uused Products by 50000+ Subscribers

4. ./App_Data/jobs/continuous/cleanLogs/EraseLogs.cmd


Question : Your company network includes an On-Premises Windows Active Directory (AD) that has a DNS domain named contoso.local and an email domain named contoso.com. You plan to
migrate from On-Premises Exchange to Office 365. You configure DirSync and set all Azure Active Directory {Azure AD) usernames as %username%@contoso.onmicrosoft.com.

You need to ensure that each user is able to log on by using the email domain as the username. Which two actions should you perform? Each correct answer presents part of the
solution.

A. Verify the email domain in Azure AD domains.
B. Run the Set-MsolUserPnncipalName -UserPnncipalName %username%@co
ntoso.onmicrosoft.com -NewUserPrincipalName %usemame %@contoso.com Power Shell cmdlet.
C. Edit the ProxyAddress attribute on the On-Premises Windows AD user account.
D. Verify the Windows AD DNS domain in Azure AD domains.
E. Update the On-Premises Windows AD user account UPN to match the email address.
 : Your company network includes an On-Premises Windows Active Directory (AD) that has a DNS domain named contoso.local and an email domain named contoso.com. You plan to
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. D,E
5. A,E


Question : You develop a Windows Store application that has a web service backend. You plan to use the Azure Active Directory Authentication Library to authenticate users to
Azure Active Directory (Azure AD) and access directory data on behalf of the user. You need to ensure that users can log in to the application by using their Azure AD
credentials. Which two actions should you perform? Each correct answer presents part of the solution.

A. Create a native client application in Azure AD.
B. Configure directory integration.
C. Create a web application in Azure AD.
D. Enable workspace join.
E. Configure an Access Control namespace.
 : You develop a Windows Store application that has a web service backend. You plan to use the Azure Active Directory Authentication Library to authenticate users to
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. D,E
5. A,E


Question : AcmeShell Inc plans to migrate from On-Premises Exchange to Office . The existing directory has numerous service accounts in your On-Premises Windows Active
Directory (AD), stored in separate AD Organizational Units (OU) for user accounts. You need to prevent the service accounts in Windows AD from syncing with Azure AD
What should you do?

 : AcmeShell Inc plans to migrate from On-Premises Exchange to Office . The existing directory has numerous service accounts in your On-Premises Windows Active
1. Create an OU filter in the Azure AD Module for Windows PowerShell.

2. Configure directory partitions in miisclient.exe.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Create an OU filter in the Azure Management Portal.



Question : You manage an Azure Active Directory (AD) tenant you plan to allow users to log in to a third-party application by using their Azure AD credentials. To access the
application, users will be prompted for their existing third-party user names and passwords. You need to add the application to Azure AD . Which type of application should you add?
 : You manage an Azure Active Directory (AD) tenant you plan to allow users to log in to a third-party application by using their Azure AD credentials. To access the
1. Existing Single Sign-On with identity provisioning

2. Password Single Sign-On with identity provisioning

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Password Single Sign-On without identity provisioning


Question : You plan to use Password Sync on your DirSync Server with Azure Active Directory {Azure AD) on your company network. You configure the DirSync server and complete an
initial synchronization of the users.

Several remote users are unable to log in to Office 365. You discover multiple event log entries for "Event ID 611 Password synchronization failed for domain."
You need to resolve the password synchronization issue. Which two actions should you perform? Each correct answer presents part of the solution.

A.Restart Azure AD Sync Service.
B. Run the Set-FullPasswordSync Power Shell cmdlet.
C. Force a manual synchronization on the DirSync server.
D. Add the DirSync service account to the Schema Admins domain group.

 : You plan to use Password Sync on your DirSync Server with Azure Active Directory {Azure AD) on your company network. You configure the DirSync server and complete an
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,D
5. B,D