Administering a SQL Database Infrastructure - PP Questions

Which one of these statements is incorrect?

• To connect to SQL Server, the principal must supply information that matches the credential data held by SQL Server.

• In a Windows-based environment, administrators can enable policies for Windows users that enforce password complexity and expiration. SQL Server can enforce similar restrictions for SQL Server logins.

• The trusted server application model is commonly used in large-scale enterprise applications, websites, and Internet services.

• You can only reset passwords using the ALTER LOGIN Transact-SQL statement.

• There are two levels at which you configure Azure Firewall Rules: Server and Database.

Put the following steps in order by numbering each to indicate the correct order.

• (1)Import SQL PowerShell module.

  (2)Use the SQL PowerShell provider to navigate to an SMO object.

  (3)Assign an SMO object to a variable.

  (4)Discover the object’s properties using Get-Member.

  (5)Amend a property.

  (6)Apply the amendment using the Alter method.

• (1)Use the SQL PowerShell provider to navigate to an SMO object.

  (2)Import SQL PowerShell module.

  (3)Discover the object’s properties using Get-Member.
  (4)Assign an SMO object to a variable.

  (5)Amend a property.

  (6)Apply the amendment using the Alter method.

What advantages are there to using PowerShell with Microsoft Azure?

• Advantages include being able to create standard, tested scripts to set up identical databases or virtual machines.

• PowerShell can be used to play video games
• PowerShell can be used to create 3D animations
• PowerShell can be used to design websites

True or false? PowerShell providers offer an alternative to using SQL Server Management Objects.

• FALSE

• TRUE

What is an SMO object?

• An object with which part of SQL Server can be managed programmatically.

• The top level object in the SQL Server hierarchy.

• Part of the Windows operating system.

• A SQL Server feature that improves performance.

• A SQL PowerShell provider.

Can you name three ways of getting information about a cmdlet?

• Using Get-Help cmdlet,
  Using Get-Command cmdlet,
  Using Get-Member cmdlet

• Using Get-Info cmdlet,
  Using Get-Command cmdlet,
  Using Get-Member cmdlet

• Using Get-Help cmdlet,
  Using Get-Info cmdlet,
  Using Get-Member cmdlet

• Using Get-Help cmdlet,
  Using Get-Command cmdlet,
  Using Get-Info cmdlet

When would you use a PowerShell provider?

• To access a data store such as SMO objects, the file system, or the registry. The SQL PowerShell provider is included with the SQLPS module. You must import it before you can access SMO objects.

• To create a new programming language
• To design a new operating system

What tasks might benefit from automating with PowerShell for your SQL Server environment?

• reporting issues from error logs, reporting issues from other Microsoft installed products that have an impact on SQL Server, and reporting on SQL Server instances.

• Creating a new SQL Server environment
• Designing a new database schema
• Implementing business logic in stored procedures

Which system DMV provides the list of events configured in an active Extended Events session?

• sys.dm_xe_session _targets

• sys.dm_xe_session_events

• sys.dm_xe_session_event_actions

• sys.dm_xe_sessions

If an Extended Events session has no targets defined, how would you view the data generated by the session?

• Use the Watch Live Data feature in SSMS.

• Using SQL Server Management Studio
• Using SQL Server Profiler
• Using Event Viewer