Searching CertSprout…
Searching CertSprout…
A little curiosity goes a long way
Search certifications, learning topics, career paths, public profiles and help across CertSprout.
Showing 20 results for “sql”. More results are available below.
AWS-CLF · Security and Compliance
…er, API Gateway or AppSync and blocks patterns such as SQL injection, cross-site scripting, bad bots and requests from specific countries or IP ranges. Hook: Shield is layers 3 and 4, WAF is…
AWS-CLF · Cloud Technology and Services
…Amazon RDS runs managed relational engines including MySQL, PostgreSQL, MariaDB, Oracle and SQL Server with automated backups, patching and Multi-AZ failover; Amazon Aurora is AWS's own MySQ…
AWS-DEA · AWS data engineering
…ansformed source records. Worked example Analysts need SQL queries over files in S3 without administering query servers. Which service fits? Amazon Athena Athena provides serverless SQL quer…
AWS-SAA · Design Secure Architectures
…LB, API Gateway or AppSync and blocks patterns such as SQL injection, bad bots or traffic from a country. AWS Shield Standard is on for everyone and mitigates common network-layer DDoS; Shie…
AWS-SAA · Design High-Performing Architectures
…ine a table in the Glue Data Catalog, and run standard SQL, paying per terabyte scanned. It shines for ad hoc analysis of logs and data lake files, and storing data as compressed Parquet sla…
AZ-104 · Monitor and maintain Azure resources
Azure Backup protects VMs, Azure Files, SQL in VMs, and on-premises files through the MARS agent into a Recovery Services vault. A backup policy sets schedule and retention with daily, weekl…
AZ-305 · Design identity, governance, and monitoring solutions
…. Grant the identity RBAC roles on Key Vault, Storage, SQL or other targets. When a question involves an Azure resource authenticating to another Azure service, a managed identity beats a se…
AZ-305 · Design data storage solutions
Azure SQL Database is a single database or elastic pool with the least to manage, ideal for new cloud applications. Azure SQL Managed Instance is a full SQL Server instance in a VNet with SQ…
AZ-305 · Design business continuity solutions
…up takes scheduled point-in-time copies of VMs, files, SQL and SAP workloads into a Recovery Services vault, with soft delete and immutability to protect against ransomware and rogue admins.…
AZ-305 · Design business continuity solutions
Active geo-replication creates up to four readable secondary databases in other regions, but each failover is per database and the application must change its connection string. Auto-failove…
AZ-305 · Design infrastructure solutions
…d a VNet identity to a PaaS service such as Storage or SQL so its firewall can allow that subnet, but the service keeps its public IP and traffic still resolves to a public address. A privat…
AZ-900 · Describe cloud concepts
…ves you a managed runtime such as App Service or Azure SQL Database; you bring code and data while Microsoft handles OS, patching and scaling. Software as a service delivers a finished appli…
CySA+ · Vulnerability Management
… fixed by output encoding and content security policy. SQL injection shows single quotes, OR 1=1, UNION SELECT and comment markers, and is fixed with parameterized queries. Directory travers…
DBT-AE · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DBX-DEA · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DP-300 · Azure SQL operations
…n holding locks unnecessarily. Worked example An Azure SQL Database query suddenly becomes slower after a plan change. Which feature helps compare query plans over time? Query Store Query St…
DP-300 · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DP-420 · SQL querying
SQL joins determine which rows are combined, filters determine which remain, and aggregation summarizes the result. Confirm the intended grain before calculating a total. Joining one parent …
DP-800 · Data modeling
A data model expresses entities, identifiers and relationships. Design it around the operations that must remain correct and the questions that need efficient answers. Normalization can redu…
DP-800 · Database administration
Database administration balances availability, integrity, performance and recovery. Investigate workload evidence before changing indexes or resource limits, and understand the impact on wri…
People search uses public names, handles and headlines. Private and unlisted profiles are excluded. Your goals are visible only to you in search.