070-473 試験問題を無料オンラインアクセス

What should you use to schedule the nightly jobs to meet the technical requirements?

• A.Create an Azure Scheduler task.
• B.Migrate the SQL Server Agent jobs.
• C.Create an Azure runbook.
• D.Implement an Elastic Database jobs.

You need to configure auditing to meet the technical requirements.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

正解：

Explanation

References:
http://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/

You have a Microsoft Azure SQL database.
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database.
You need to examine the system utilization trends over time.
Which dynamic management view should you query?

• A.sys.dm_exec_query_stats
• B.sys.dm_db_missing_index_details
• C.sys.resource_stats
• D.sys.events

Relecloud recently implemented the planned changes.
you plan to add a new customer named Fabrikam, Inc.
You need to ensure that the administrators at Fabrikam can access their data after the data loading process.
You collect the IP addresses used by the Fabrikam administrators.
Which Transact-SQL command or Azure PowerShell cmdlet should you use next?

• A.sp_set_database_firewall_rule
• B.Set-AzureRmSqlServerFirewallRule
• C.sp_set_firewall_rule
• D.new-AzureRmSqlServerFirewallRule

You implement Microsoft Azure ExpressRoute.
You need to ensure that if the ExpressRoute connection is unavailable, you can manage the resources in Azure over a secure connection.
Which two actions should perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Install the Azure VPN client.
• B.Create a private IP address.
• C.Create an Azure virtual network.
• D.Create a certificate.
• E.Enable a point-to-site VPN on the gateway.